karthikeyan (6/20/2008)

---

sqldba,

first of all try yourself, otherwise you can't learn anything new. Try to write your own SP. Becuase it is a basic one, without knowing how to wite a...

There is a way to do this using SET ROWCOUNT 1 and a cursor (which is technically an intermediate table but fools most people). Performance will totally suck. ...

Please read the following article on Tally tables... there's also a script that demonstrates how to split a whole table's worth of CSV's, just like you have, without even coming...

No, I don't believe such a script exists... you'll need to write one. And, yeah, it's going to take a bit of time.

If I could find out how, I would in an instant. Anyone have a clue on how to get on that committee?

Ummmm.... how far away is your warm server?

Mark Beringer (6/20/2008)

---

Sounds like you need to write a query that groups by user and selects MAX date and also joins to a cost table. Which table are the costs...

Ok... since you're new, I'd like you to take a peek at the article in the Link in my signature... it'll help you get better answers quicker in the future....

I would really, really like to get my hands on the SQL Standards committee... they all need to be taken out for a porkchop dinner, Jeff Moden style... 😀

Mobasha,

I'm pretty sure what you ask cannot be done. You would have to capture the session name at the time of creation of the global temp table or something...

If it's BCP or Bulk Insert or maybe even the Bulk Insert task of SSIS, you may need a format file to do this...

Table variables are NOT memory only. Of course, don't take my (or anyone elses) word for it... read the following article about how similar Table Variables and Temp Tables...

mlimp (6/20/2008)

---

Hi,

This is an easy one.

How do delete rows from a table?

I want to delete all the rows from the last month of a table so i have to be...

And, apparently, another myth dies...

The old myth was that COUNT(*) and SELECT * performed better than anything else because it would look for the best index to use. Using...

JRJ (6/20/2008)

---

Thanks for your reply, sorry about the wrong naming.

Regarding my second query, I am deeling with constantly changing existing data as well as new data; if I don't delete,...