Viewing 15 posts - 916 through 930 (of 4,086 total)
September 14, 2018 at 9:55 am
Heh... must be one of those people that think that "Just because you...
September 14, 2018 at 8:53 am
Most people are hesitant to open up documents posted by random strangers. Please provide sample data as outlined in the first link in my signature. You also haven't mentioned how...
September 13, 2018 at 2:37 pm
Jeff Moden - Thursday, September 13, 2018 11:57 AMBut it's fast, right? :D:D:D
It took almost 16 minutes to copy about 80K...
September 13, 2018 at 2:32 pm
OMG. I'm working on a stored procedure that references an EAV table and it has 73 separate subqueries in a single SELECT statement to pull values out of the EAV...
September 13, 2018 at 11:44 am
September 13, 2018 at 7:55 am
September 13, 2018 at 7:48 am
September 13, 2018 at 7:40 am
SELECT *,
MAX(CASE WHEN [Headquarters or Branch] = 'Headquarters' THEN 'HDQ, and the city of ' + BusinessCity + ', ' + State' END) OVER( PARTITION BY CompanyName)...
September 12, 2018 at 3:20 pm
September 12, 2018 at 3:12 pm
September 12, 2018 at 2:27 pm
September 12, 2018 at 12:33 pm
We added additional temp data files to match our 8 cores. We were expecting...
September 12, 2018 at 12:25 pm
laurie-789651 - Wednesday, September 12, 2018 8:31 AMHow about this:
SELECT KidID, MAX(EndDate) as MaxEndDate
FROM [dbo].[Payments]
WHERE EndDate < GETDATE()
GROUP BY KidID;
That...
September 12, 2018 at 9:55 am
Assuming that ACT_Status and Status are not nullable, this should work.
select s.[Status], count(a.ACT_Status) [Count], s.[Rank]
from [(local)\ISYS].Intelligent.dbo.vwStaffStatus2 s left join
[(local)\ISYS].Intelligent.dbo.vwStaffDayActivity a on s.[Status] IN...
September 12, 2018 at 9:49 am
Viewing 15 posts - 916 through 930 (of 4,086 total)