Viewing 15 posts - 1,471 through 1,485 (of 26,488 total)
My problem, you were also asked to show what you have tried to solve your problem. At this time, all I see is you asking others to do for free...
June 11, 2018 at 10:31 am
This would be the other method with execute as owner: USE SomeDatabase
GO
--sysadmin...
June 8, 2018 at 2:06 pm
June 8, 2018 at 10:53 am
June 7, 2018 at 12:40 pm
June 7, 2018 at 8:59 am
June 6, 2018 at 1:11 pm
We've gone to Meetup for our monthly meetings and our monthly lunch. IIRC, we still use EventBrite for SQL Saturdays.
June 6, 2018 at 12:19 pm
June 5, 2018 at 12:23 pm
June 5, 2018 at 11:58 am
Here is your answer, and it may not be much better as it is considered a catch-all query:
DECLARE @C CHAR(1);
SELECT @C = '1';
IF OBJECT_ID('tempdb..#t') IS...
June 5, 2018 at 11:57 am
Declare @C...
June 5, 2018 at 11:47 am
To state the obvious, in the first query the calculation has to be done for every row of data while in the second query it only needs to be done...
June 4, 2018 at 2:21 pm
Viewing 15 posts - 1,471 through 1,485 (of 26,488 total)