LOL - Tyson - you don't see it because it was in another post that you provided this solution!!!

remi - it's not the weekend yet..you can't just "go away" - not when so many live(lihood)s depend on you!!!

at any rate, if...

Yes Ian is right....well - Ian is obviously way better than I am at interpretations...

imran...while you're waiting for remi...here's something you can play around...

I hope 2nd interpration is not correct.....well, at least it's an interpretation..something obviously I'm no good at...so I'll just be a fly on the wall for this one and leave...

Ian has a different take on this than mine...but again..remi will definitely stop by later on with the "right solution"...

imran - if i...

so Amit - are you going to elaborate or just leave in the aura of mystery ?!?!

when stepping through the wizard - select "copy objects and data between SQL servers" instead of "Copy table(s) and View(s) from source database"...

how many different filters could there be other than "WHERE EventID = 1" ?!?!

besides, remi wanted you to post the entire code so that he could give you a set-based...

see if this link helps any...there aren't any alphas afaik but the logic seems to be what you're looking for..

sort

I'm not sure I understand this question...if you update your table, will it not then have 2 identical columns ?!?! what am I missing ?!

Here's an entire QOD and ensuing discussion on this...

model db

& here's another that I created "literally" 5 minutes ago...

CREATE TABLE [tblTotalObligations] (

[BudgetFK] [int] NOT NULL ,

[Obligations] [int] NOT NULL CONSTRAINT [DF_tblTotalObligations_Obligations] DEFAULT (0),

[LessReimbursables] [int] NOT NULL CONSTRAINT [DF_tblTotalObligations_LessReimbursables]...

question...what question...oh you mean the question that spawned this thread that started the discussion that led to all this enlightenment...........that lay in the house that Jack built ?!?!

pl. don't throw...

"(although, not any order that can be guaranteed or predetermined).."...order by...?????????

ok - ok - the light did finally dawn - I just threw that in because alien forces make me...

alright! one last question...

can you elaborate on "SQL Server's implementation thereof not withstanding..."...not quite sure if you were referring to indexes or something else ?!?!?!