Hello, it seems to work ok. I tested it a couple of times...It's probably because it's looking at a staging table and that table gets truncated...
Thank you. I modified my code to Select the TOP1. I left the date, the way it is because it may change later. And i figured it's easier to read....
Hello all, I just completed my first DTS package [:D]. I wrote an activeX script in the first workflow properties section to avoid execution if...
That worked perfectly....thanks a million <img src='/community/emoticons/emotion-1.gif' alt=':-)' />
Hello, I've been messing with this all day and can't figure out what's wrong with it. This is the code I'm sticking with (I've changed it about a...
UPDATE <img src='/community/emoticons/emotion-1.gif' alt=':-)' /><br /><br />Thanks you guys!! I will look into the @@Identity and Scope_identity...
I think that an ID key would be ideal if a table didn't have a child...reminder...new :-(. The only way that I can think of having the same ID on...
Thanks everyone!! I removed the clustered index <img src='/community/emoticons/emotion-1.gif' alt=':-)' /> Just as FYI:<br />The column datatypes...
Hello,<br /><br />I'm kind of new to databases and I'm trying to follow all the basic rules for creating tables. For the primary Key, since...
Separate names with a comma.
