Viewing 15 posts - 2,701 through 2,715 (of 15,381 total)
Grant Fritchey (7/1/2015)
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days off, and...
July 1, 2015 at 12:29 pm
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days off, and the people who don't,...
July 1, 2015 at 12:12 pm
Jacob Wilkins (6/30/2015)
Based on what I've tested, Scott is technically correct. Under the right conditions, even where it is not...
June 30, 2015 at 1:24 pm
OLSONEJ (6/29/2015)
ID...
June 29, 2015 at 2:00 pm
That's great news Alan!!! Enjoy paternity leave. Just wait a couple weeks and that sleepy feeling you remember from college will pale in comparison to weeks on end with no...
June 29, 2015 at 1:25 pm
Luis Cazares (6/29/2015)
That's weird Sean, I would be more scared of rar files.
Heh, well I have a VM with winrar on it but it doesn't have office. I was able...
June 29, 2015 at 10:00 am
james.milner (6/29/2015)
Curious...how is NEWID() considered a deterministic function?
It is not a deterministic function. The answer to the question states that DATEADD is the only deterministic function and all of the...
June 29, 2015 at 9:58 am
karthik82.vk (6/29/2015)
Hi,Your solution works fine..
However I cannot have the myTime < '08:10:00' value always as '08:10:00'.
Is there any workaround for this?
You have several rows in your sample with...
June 29, 2015 at 9:51 am
You should be able to just change the datatype from ntext to nvarchar(max). When you want to limit the length though you will get a warning that you might lose...
June 29, 2015 at 9:49 am
I too was bitten by the vague bug. I got the right answer but that was because it was the only non-ANSI function. There are just too many ways this...
June 29, 2015 at 7:47 am
farrukhhameed786 (6/27/2015)
Hi Sean,Thanks
Please find in the attachment Create Table.sql,Insert Script.sql and sample new.xlsx ( contains results).
I hope not miss any thing.
OK we are getting closer. The file contains...
June 29, 2015 at 7:18 am
Since you say you are new to SQL I would ask if you understand what that NOLOCK is really doing. It can and will get missing and/or duplicate rows. It...
June 26, 2015 at 2:52 pm
ScottPletcher (6/25/2015)
GilaMonster (6/25/2015)
Nolock hints, do you know what they do? (hint, they don't make queries faster)
Why does everyone keep repeating that?
Scott you have been around sql long enough to...
June 26, 2015 at 2:48 pm
alex.sqldba (6/26/2015)
Hi Guys,If I granted execute right to Schema1 for sp MyProc;
And MyProc updates something in Schema2
Will it work? Or will it fail as its a different Schema?
Cheers
Alex
If the user...
June 26, 2015 at 2:39 pm
farrukhhameed786 (6/26/2015)
First of all I apologized may be my way of writing not correct !
Actually data is already inside database I want to write the sql query to get...
June 26, 2015 at 2:32 pm
Viewing 15 posts - 2,701 through 2,715 (of 15,381 total)