Also - there's no compelling reason that everything needs to be rolled onto the SAN on the same day. As a matter of fact - there would be lots...

If the straightforward method doesn't work - you MIGHT get away with, well, cheating..:)

Create a blank database with the same name and filenames as the one you're trying to attach,...

I can think of a few ways to do this, but I am not sure how solid or complete the rules are. Are we looking for EVERY instance of...

Vijay - I think that if you were to try to execute that as a recordset - you would get data back, just as if you had a "straight" SELECT...

I understand that - it's just terribly inefficient for what you're trying to do. I suspect that the appropriate SET-based solution (using the OUTPUT clause as previously mentioned) would...

When you're "windowing" aggregate functions - PARTITION BY is concaptually the same as GROUP BY. It defines the window you're operating on.

An example might work better:

Select customerID,

...

And just a friendly reminder....Don't try the "stop, smell, smile" trick in your data center. Most of them have some seriously FUNKY smells - whatever smile comes out of...

Grant Fritchey (6/6/2008)

---

Another guy just asked for something similar over in the Development forum. I had the same answer for him. I kind of thought it might be possible in...

If the datetime column is indexed, then Suresh's solution would probably give you better performance. It should allow for index seeks, whereas Telammica's will likely result in index scans.

Either...

Blandry -

psst....Lynn's a HE....:)

A T-SQL function probably will not be appropriate for this. At this point I can't think of a way to even "cheat" to make a T-SQL function do that,...

Trader Sam (6/6/2008)

---

It is funny how that sometimes it takes a crisis such as a severe illness, or death of a loved one to get us to take notice our...

hmm... and it takes the keeper of the Duck to make me notice it on BOTH lists....I somehow ahdn't noticed it there previously....

Thanks Brian!

You could also do this with the windowed version of an aggregate.

SELECT [order_key], promo_disc_amt,

Sum(promo_disc_amt) over (partition by NULL) totalPromo

FROM FactOrder

WHERE...

K. Brian Kelley (6/5/2008)

---

If you're using SSMS, right-click on the database itself. That'll bring up a pop-up menu which has...