The Dixie Flatline (7/22/2010)

---

Try to find an online server for "Diplomacy". Similar in concept to Risk, but no luck is involved. Only one turn per day,...

Jeff Moden (7/22/2010)

---

It actually does matter a bit especially when it comes to formatting things like dates. SQL Server doesn't have much of chance of formatting dates correctly on...

chandrakala.shetty (7/22/2010)

---

Have the below option in the begining of the script, i.e before calling the SP. This defaults the the provided database name & you do not have to...

I'm not sure, but I'm thinking that you might be breaking up the statements into separate IF blocks to filter data rather than actually having a separate query. If...

I really don't understand what you're asking. To do the inserts is simply:

insert into clientvendor (clientid, vendorid)

select 2, 2 union

select 2, 3

Normally you would have some sort of front...

Looking at this more ... I think he's trying to run this from another database. I'm guessing this is all he's trying to do:

CREATE PROCEDURE usp_proc_d_zone AS

IF EXISTS (SELECT...

Will this always be performed in the same database?

MegaDBA,

I don't understand your response. If you don't want honest feedback then you shouldn't plop down hundreds of lines of code and ask for feedback. If you do...

What exactly is your question?

Paul White's sans formatting (since you're doing that at presentation) would just be:

SELECT case_number,

fee_percent,

fee_portion,

settle_amount = CASE ROW_NUMBER() OVER(PARTITION BY case_number ORDER BY case_sk)

WHEN 1 THEN settle_amount

ELSE 0 END,

initials

FROM #test

ORDER ...

Dell XPS M1730 ... nothing like running SSMS with SLI enabled!

I've long had a theory that you can either be an *** or you can be wrong, but nobody can get away with being both.

I know some people here are...

This is really inefficient. If you are still looking for help, provide a table definition and some sample data as well as an example of the data you would...

Ok ... I got to say this ...

The first baseman for the Orioles deserves whatever bad karma is going to come his way. If you're in the major leagues...

TonyK_Ga (7/21/2010)

---

One more help please.

I am getting invalid column name PKCol after Table 1 and Table 2 with the actual table names.

What is PKCol? is this the primary...