What is less clear is SARG-ability in HAVING clauses. That is, to what extent can the having clause conditions carry through to selectivity before the GROUP BY, possibly through...

smunson (12/3/2008)

---

Almost, Barry... Given the methodology involved here, @ROW1 is ALWAYS going to be 1, and @ROW2 is ALWAYS going to be 2, so some of this can...

John Barry (12/3/2008)

---

If we want to use IDENTITY, we would need to generate an AD record, get the IDENTITY value, then use that to generate each DOC record, stopping each...

I assmued that he wanted "to split" memory in terms of figuring out how much is being used by each database.

rajesh_281984 (12/3/2008)

---

Thanks to all of you guys for giving me good information and the code is working fine now. Can u guys suggest some stored procedure samples that i can...

Heh. Sorry, I understood the question, but not the answer. 🙁

John Barry (12/2/2008)

---

For each new sequence number, I just want to pop one off a stack without affecting any other processes, because I don't want anyone to be parked behind...

It's not clear what you are trying to do or what you want. Please give some examples.

Like this:

Select tr.tradername

, opbalanace

, closingbalance

From dbo.Traders tr

Left Join (Select traderid

, IsNull(Sum(debit),0)- IsNull(Sum(credit),0) as opbalance

From dbo.btty

Group By traderid) op

ON op.traderid = tr.traderid

Left Join (Select...

Glad I could help.

Yes, we need more information. Please read the following article and then provide the information that it describes in the format that it shows: http://www.sqlservercentral.com/articles/Best+Practices/61537/

I doubt that you can change protocols for already established connections.

And whenever you want to post a 370+ line output file like this, please feel free to either trim it down some or post it as an attachment instead.

Chris Morris (12/2/2008)

---

Grant Fritchey (11/30/2008)

---

Well, it was a thrilling moment, I don't mind saying. I'll be picking up one of those integrated face sheild/helmet/ear protection things soon (read ASAP). First...

Garadin (12/2/2008)

---

Don't create the non-clustered index at all. Shouldn't be necessary.

WITH (INDEX(0))

Since the clustered index is the only one, that will grab it correctly. While this...