RP_DBA (5/10/2012)

---

It would help to see the table definition and query you're working with but are the 4 columns in question the only 4 being used from that table?...

That really is a fast-paced development environment!

There might be some .NET frameworks you need, the installer will run a prerequisite check before the install anyway.

Any patched up to date Windows install should be fine 🙂

Eugene Elutin (5/10/2012)

---

WayneS (5/9/2012)

---

Tim Walker. (5/9/2012)

---

riya_dave, I've not been here for a couple of months, but you have at least three of the best experts giving you free help here....

First one, no, not a memory issue (although more CPU/RAM might get around it briefly, that'd just be papering over a large crack!)

It means SQL can't produce a valid execution...

Well, boringly, we just junked the server instead of fixing it.

The repair ran out of of disk space - didn't have 3TB available to that server!

(So that's something to remember...

pdanes (5/9/2012)

---

Thank you, Gazareth, I do know something about indexing and such. If I get stuck on that, I'll start a new post. My question was about the -CONCEPT- of...

Stops working, or just doesn't return an execution plan in a reasonable time?

Some plans can take a while to generate!

Self joins of one type or another are generally the way I've done this. It's easy to write a 'triangular join' though.

There are a few ways to do it -...

No problem!

I think @@ROWCOUNT is what you're after.

http://technet.microsoft.com/en-us/library/ms187316(v=sql.105).aspx

As in, SET v_count = @@ROWCOUNT.

Cheers

Far as I know, the only way to do it is using the OUTPUT clause as per your link.

You'll need to aggregate the data yourself to screen or a holding...

michael vessey (5/8/2012)

---

I'm not sure if reading good suggestions from this forum would prevent many of newbies from being "promptly escorted off the premises" after interview with some of us...

Cadavre (5/8/2012)

---

I'm sure I've read it somewhere, but to be honest after a quick search all I can find is this: -

GSquared (12/1/2011)

---

You can actually change the zero date at...

Can you?