Viewing 15 posts - 616 through 630 (of 851 total)
[font="Verdana"]You can log output from a job using SQL Server Agent to a file. Or if you are running it from the command line using SQLCMD, redirect the output...
February 17, 2009 at 12:28 pm
[font="Verdana"]My suggestion would be as follows:
The reasons cursors are "bad" is that they reinforce the "one row at a time" type of solution. It's not the cursor as such...
February 17, 2009 at 12:22 pm
[font="Verdana"]Thanks Milla. You read the question way better than I did, and I think your solution will be more appropriate.[/font]
February 16, 2009 at 4:50 pm
Jeff Moden (2/16/2009)
Bruce W Cassidy (2/16/2009)
In another thread, Jeff [font="Arial Black"]Modan [/font]reminded me that numbers of the form '1d3' and '1e3' are legitimate.
Heh... and Bruce W [font="Arial Black"]Cassody [/font]used the...
February 16, 2009 at 3:41 pm
[font="Verdana"]I'm wondering whether the reason that the datetimes have been posted in the string form is that the application needs to preserve the timezone data.
I think the best bet would...
February 16, 2009 at 3:38 pm
Jeff Moden (2/16/2009)
It's a GREAT day for arguments! 😛 Too bad we're not having one.
[font="Verdana"]Wait! All is not lost! Now we are arguing about whether we...
February 16, 2009 at 2:09 pm
Roy Ernest (2/16/2009)
Calm down people ... Calm down...:D It is a Monday afternoon...:D Not the best day to have arguments.... 😉
[font="Verdana"]Tuesday morning here. My Dr said I'm allowed to...
February 16, 2009 at 1:59 pm
Jeff Moden (2/16/2009)
February 16, 2009 at 1:52 pm
Gift Peddie (2/16/2009)
At least on 2006 the business chose Oracle
Cannot find anything more recent of the same weight/popularity...
I don't think those sales translate to business choice because I...
February 16, 2009 at 1:49 pm
[font="Verdana"]Interesting. I thought the code looked a little wonky, so I did a quick test:
select dbo.isReallyInteger('1')
----
0
Last time I looked, 1 was an integer. 🙂
I suspect your PATINDEX needs...
February 16, 2009 at 1:46 pm
gints.plivna (2/16/2009)
At least on 2006 the business chose Oracle 😉Cannot find anything more recent of the same weight/popularity...
[font="Verdana"]No surprises there. Well, hang on... Unix is still more popular...
February 16, 2009 at 1:41 pm
Jeff Moden (2/16/2009)
Business needs to start considering "which is easier to program in?"
[font="Verdana"]Pulls out the choir robes and the preacher robe Which do you wanna wear?[/font]
February 16, 2009 at 1:33 pm
[font="Verdana"]Me either. Here's hoping someone else on here has some ideas! Did you try creating multiple CTEs?[/font]
February 16, 2009 at 1:26 pm
James (2/16/2009)
February 16, 2009 at 1:23 pm
[font="Verdana"]StreetName is a varchar, right? With values like 'CAMBRIDGE' I would hope so!
Can you run the query just filtering on StreetName? Maybe build it up in layered CTEs.
[/font]
February 16, 2009 at 1:13 pm
Viewing 15 posts - 616 through 630 (of 851 total)