is it good method - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

is it good method

Author

Topic

jayram11
Yak Posting Veteran

97 Posts

Posted - 2011-07-12 : 14:32:12

i have a thought, could i just
insert records where concatenate (STATE + ID) not in STATE1 from STATE2 and use a default dates
Update dates in STATE1 for concatenate (STATE + ID) not in STATE2

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2011-07-12 : 14:59:16

i have a thought.... "Ehhh ?!?"

You're going to have to do better than that if you want realistic help.

Corey