Viewing 15 posts - 54,391 through 54,405 (of 59,065 total)
But I am still curious as to why my UDF didn't work.
Your UDF works... but think about it... what do you get when you concatenate a NULL with...
October 27, 2007 at 9:09 am
Just a personal opinion...
I think you may be trying to do too much in a UDF. I think the UDF should do nothing but find the number you're looking...
October 27, 2007 at 8:37 am
The picture of what you wanted in your first post is not visible.
Layout some text on the next post that depicts the format that you would like. Use the...
October 27, 2007 at 8:32 am
I'm thinking this is wrong...
SELECT * FROM IPGDB..SHPHST
WHERE SIDATE > '2007-10-16'
AND SIDATE <= '2007-10-17'
Should be...
SELECT * FROM IPGDB..SHPHST
WHERE SIDATE >= '2007-10-16'
AND SIDATE < '2007-10-17'
Other than that, your transaction is pretty...
October 26, 2007 at 7:45 pm
Kenneth Wilhelmsson (10/26/2007)
SQL Server is very obedient and sorts exactly as asked to..
...if that wasn't exactly what one intended, is another matter..
The 'fault'...
October 26, 2007 at 7:39 pm
How would you like to import 5 million rows in about a minute? Post, say, 100 rows of data as an attachment and I'll show you how to build...
October 26, 2007 at 7:35 pm
bharani (10/23/2007)
ya, but my team want that to be an int value...
Your team is absolutely wrong... Peter Larson has a good viable solution... storing any date or time as other...
October 26, 2007 at 5:38 pm
Heh... no matter how you swing it, this whole thing is RBAR... if it's for a GUI single row proc... no problem... if it even comes near a batch, big...
October 26, 2007 at 5:32 pm
Heh... the only thing I might disagee with is you calling Celko "smart" 😉
October 26, 2007 at 5:27 pm
Bob Bridges (10/24/2007)
You got me on the right track... the problem is in the "SET @col" statement. I had
SET @col = 'Part2.Part1'
What I didn't realize is that the "Part2"...
October 26, 2007 at 5:25 pm
MrPoleCat,
Would you be kind enought to test this on your SQL Server 7? Thank you, Sir...
--===== If the test table already exists, drop it
IF...
October 26, 2007 at 5:13 pm
Greg Snidow (10/26/2007)
Well, I can't replicate it, but I know I had an issue with it before. Maybe I'm just crazy.
No, not crazy... both of the following will order...
October 26, 2007 at 8:25 am
Ooohh.... heh... the only time I ever explicity declare cursors is to demo how slow they are when I do... if SQL Server wants to use cursors internally, that's fine......
October 26, 2007 at 7:58 am
Heh... you already know this, but the emphasize, loop joins (especially) and a bunch of other "internal" things are really high speed "cursors" that operate at machine language levels.
October 26, 2007 at 7:11 am
Viewing 15 posts - 54,391 through 54,405 (of 59,065 total)