Viewing 15 posts - 53,446 through 53,460 (of 59,068 total)
JohnG (12/21/2007)
December 21, 2007 at 11:08 am
It was kind'a real life spoof... for some of us, though, it's closer to the truth than I care to think 😀
Glad it made some laugh 😉
December 21, 2007 at 11:06 am
You bet... thanks for the feedback.
December 21, 2007 at 10:59 am
jitumevada (12/21/2007)
Is it possible that select query return row to screen...
December 21, 2007 at 10:48 am
Everything in the FROM clause MUST be all upper case...
December 21, 2007 at 10:43 am
Heh... I'm the new guy to 2k5 and even I know that you don't need a CLR to solve this bad-whammer with some very simple and fast code... 😛 ...
December 21, 2007 at 10:30 am
Thanks, Mark... only way I can get it to work for more than 1 row is to have a second column to hold, well, a NULL...
CREATE TABLE dbo.MyTable
...
December 21, 2007 at 9:57 am
Mark,
Any idea how to insert more than 1 value without a loop? Insert/Select doesn't seem to do it...
December 21, 2007 at 9:26 am
karthikeyan (12/21/2007)
WHERE ISNULL(SomeColumn, ' ') <> ' '
Actually there is nothing wrong with this statement.But it is not required.
The logic of this sql code is :
if 'Somecolumn' has 'NULL'...
December 21, 2007 at 9:18 am
karthikeyan (12/21/2007)
I mean i want to find last month's last date only ? I don't required the current month's first,last...
December 21, 2007 at 9:12 am
Jason Selburg (12/21/2007)
karthikeyan (12/21/2007)
Can you tell me where exactly you can apply spt_values table?I mean In which situations you go to spt_values.can you list out some examples ?
I thought...
December 21, 2007 at 8:57 am
Yes, it is possible... read the following article... because these are a bit "tricky", make sure that you read and understand the entire article before you try anything like that...
http://www.sqlservercentral.com/articles/Administering/utilityprocedures/2272/
December 21, 2007 at 8:35 am
Midan,
What John is asking for is covered in the following URL...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
You have a lot of data posted... we should use your data to give you the best answer. As...
December 21, 2007 at 8:12 am
Hear! Hear! We've invoked similar rules.
December 21, 2007 at 7:53 am
You bet...
... and, there are two "f's" in "Jeff"... I know a name isn't much, but it's all I've got 😉
December 21, 2007 at 7:18 am
Viewing 15 posts - 53,446 through 53,460 (of 59,068 total)