JohnG (12/21/2007)

---

Rather than casting/converting all of the WHERE clause values into the dynamic SQL query string you should be using the system stored procedure sp_executesql vs. just plain EXECUTE. ...

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 😉

You bet... thanks for the feedback.

jitumevada (12/21/2007)

---

I have one select query. Which is returning 1000 rows.It takes 20 min. But I dont want all rows simultaneously.

Is it possible that select query return row to screen...

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 😉