Viewing 15 posts - 1 through 15 (of 36 total)
Hi Sue, thanks for your reply! I added a line SET
September 18, 2017 at 8:05 am
I'm having trouble with what seems to be this exact issue. I have a stored procedure that has been working for years, and suddenly I get this error about string...
September 11, 2017 at 9:34 am
This reminds me of a question-of-the-day I posted a few years ago: http://www.sqlservercentral.com/questions/T-SQL/65712/. This question was the result of some testing I was doing with comments, and one of the...
July 8, 2013 at 12:25 pm
Jesse McLain (5/17/2012)
chris.stuart (5/17/2012)
I always enjoy reading the articles, but this one got me a bit stumped. Where would you actually use this?:unsure:
I used this method in an algorithm to...
May 17, 2012 at 7:44 am
chris.stuart (5/17/2012)
I always enjoy reading the articles, but this one got me a bit stumped. Where would you actually use this?:unsure:
I used this method in an algorithm to identify unique...
May 17, 2012 at 7:16 am
There are two advantages to comparing code programmatically versus manually: quantifiable results and the ability to automatically compare every stored procedure in a database to every other one. Imagine consulting...
April 8, 2011 at 7:34 pm
I started this exercise because I found it intellectually interesting. It stemmed from a task for a client, but of course this extended exercise I did on my own time....
April 8, 2011 at 8:23 am
The question was easy in a technical sense, but also had a psychological angle what with the "2", "three" number-word confusion. Sort of like the psych test (the "Stroop effect"),...
October 9, 2009 at 7:22 am
I thought it was a decent question - the double negative almost made me answer 'NOT OK' rather than the correct answer, 'OK'. The author was simply pointing out that...
September 16, 2009 at 7:49 am
leea (9/9/2009)
Only way I've found to do this is...
September 10, 2009 at 2:26 pm
Elliott W (7/29/2009)
You could write the output into a table variable and then pull the rows out one-by-one using a CURSOR (I know, I know)...
At the risk of starting an...
July 29, 2009 at 9:48 am
The idea is that if you have two or more different ways of solving the same problem, and want to compare the performance difference between solutions, this script can help...
June 26, 2009 at 8:00 am
Tara (6/23/2009)
yes both are smalldatetime.when extract data using ssis pkg i am not getting the 3 additional decimals bu when do a regular insert i am getting them.
Do the destination...
June 23, 2009 at 1:08 pm
If your destination column is smalldatetime, it shouldn't have the milliseconds added on as decimals at the end. Are you 100% it's smalldatetime and not datetime?
June 23, 2009 at 12:42 pm
Dude, where's your car? (Sorry, couldn't resist. :-P)
You might also want to check out PATINDEX if you have multiple possible delimiters.
June 17, 2009 at 9:06 am
Viewing 15 posts - 1 through 15 (of 36 total)