... and, if there are any questions about possible performance, lets use the good ol' million row test table I keep around...

---

--===========================================================================================

-- Build a million rows of test data. THIS...

Original thread seemed pretty darned clear... but I could be wrong...

This should do it...

--===== If the temp table exists, drop it

IF OBJECT_ID('TempDB..#SandBox') IS NOT NULL

...

But, that's what I'm talking about... I wasn't talking about...

Or, just...

SELECT @bLookForChangedCUSIPs = SIGN(COUNT(*))

FROM Performance.dbo.gChangedCUSIPs

WHERE CUSIPKey = @vchVAGK + @vchPAC

Yes, they do... Please refer to Q4/A4 at the following URL...

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k

No... I wouldn't make an alpha-numeric primary key... they're slow and difficult to maintain.

Why don't you just use an INDENTITY column and a Country column?

This will help, as well...

http://www.w3schools.com/sql/default.asp

Heh... You did go backwards, indeed...

Instead of me trying to figure out what the function is supposed to do, please tell us so we can tell you how to do...

Muhammad Furqan (10/2/2007)

---

Well, well !!!

i think i was unclear.

what i meant was that constraint should be enforced, but a constraint being violated should not give an error and terminate the...

My recommendation would be to import the data into a staging table using BULK INSERT. Nasty fast... then, you can add the necessary indexes for performance... can't do that...

dhay1999 (10/5/2007)

---

Yes, this is a non-analysis services Datawarehouse. so basically I am processing a "cube" to get aggregations at 6 different hierarchical levels/views. No matter what I do,...

Oh, thank goodness... it's not "Bankers Rounding" 😀

This is going to sound mean and I don't mean it that way...

The table is improperly designed... why do you have separate date and time columns? And, I'll bet...

After that... drink beer! 😀

You need to do two things...

1. Click on the Windows {Start} button, click "Help and Support". When the new window appears, enter "BATCH COMMANDS" in the search field,...