Everything in the FROM clause MUST be all upper case...

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... 😛 ...

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

...

Mark,

Any idea how to insert more than 1 value without a loop? Insert/Select doesn't seem to do it...

karthikeyan (12/21/2007)

---

Jeff,

Actually there is nothing wrong with this statement.But it is not required.

The logic of this sql code is :

if 'Somecolumn' has 'NULL'...

karthikeyan (12/21/2007)

---

Thanks.But,is it possible to get lastmonth's lastdate without using localvariables ?

I mean i want to find last month's last date only ? I don't required the current month's first,last...

Jason Selburg (12/21/2007)

---

I thought...

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/

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...

Hear! Hear! We've invoked similar rules.

You bet...

... and, there are two "f's" in "Jeff"... I know a name isn't much, but it's all I've got 😉

karthikeyan (12/21/2007)

---

Madhivanan,

Thanks.Suppose if i have like this,

Declare @Str varchar(300)

@Str = 'Karthikeyan,Madhivanan,JeffModen,Steve-Jhones,MattMiller,GilaMonster'

do we have to repeat your code for 6 times? Suppose if i have around 20 names do we repeat...

I don't believe so... other than running it or taking it apart and running the peices...

You could always setup to exec it and run an estimated execution plan on it,...

Heh... I hate Oracle...

I create a linked server to the Oracle DB, grab the data I need and store it in permanent "working" tables in SQL Server, and then all...

THAT would be the ticket...