Viewing 15 posts - 1,201 through 1,215 (of 9,399 total)
July 18, 2017 at 6:02 am
autoexcrement - Monday, July 17, 2017 5:40 PMCan I ask why you prefer EXCEPT over NOT EXISTS?
More often than not, I find...
July 17, 2017 at 5:45 pm
I think a lot more people spend time splitting strings than any of us think. Like Jeff said, there are times when order is important, such as a broken-up path. ...
July 17, 2017 at 5:24 pm
July 17, 2017 at 4:37 pm
Which line is generating the error? The call to sto_NewKey looks to be correct. The sto_NewKey procedure itself contains calls to different stored procedures and functions and it might be...
July 17, 2017 at 4:27 pm
I want to get the distinct values from this table as row no...
July 16, 2017 at 2:07 pm
I want to write if the table exists in the database in dynamic sql then...
July 16, 2017 at 2:03 pm
July 15, 2017 at 8:36 am
July 14, 2017 at 10:03 pm
Here's an ITVF that does the job. It uses the number of classes in the list that the person has taken and compares it to the number of classes in...
July 14, 2017 at 9:54 pm
The most interesting things for me involve digging into SQL Server under the hood. I enjoy working with the DMVs to go searching for problems before they find me. I...
July 14, 2017 at 9:15 pm
Heh... it's almost as bad as trying to convince Microsoft that there's a...
July 14, 2017 at 9:08 pm
July 14, 2017 at 8:59 pm
I thought it was a good question that really made me think through each possibility. It took a while, but so does some of the stuff I do all day.
July 14, 2017 at 7:49 pm
Good question to illustrate the finer points of the function. I find that knowing the details of the functions is the key to using them effective...and not misusing them.
July 14, 2017 at 7:43 pm
Viewing 15 posts - 1,201 through 1,215 (of 9,399 total)