Viewing 15 posts - 10,126 through 10,140 (of 15,381 total)
Yes this is no problem. Even though this link is for 2005 it is the exact same process in 2008, not sure about 2012 since I don't have it.
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/d91d265a-59d3-4c8a-94ad-227611c342d8/%5B/url%5D
November 6, 2012 at 3:19 pm
Is the datatype for archiveID int? Do you have any triggers on these tables?
November 6, 2012 at 3:15 pm
reliableitservice (11/6/2012)
It works!!!!
I just not sure this this is what I was expecting. See, I am getting three columns: BILL_NUM, VALUE, and zzedatawhse.value.
The table shows all records from...
November 6, 2012 at 2:20 pm
David F (11/6/2012)
November 6, 2012 at 9:40 am
Zeev Kazhdan (11/6/2012)
It is pretty embarrassing! I didn't think about the update option at all it works like a charm with a minor change - ORDER BY...
November 6, 2012 at 9:37 am
ROFL. I drove past this bar the other day...honest it is called RBAR.
See the attached photo.
November 6, 2012 at 9:35 am
George M Parker (11/6/2012)
We referred to that as an ID 10 T error...
Eye Dee Ten Tea????
November 6, 2012 at 9:34 am
halifaxdal (11/6/2012)
GSquared (11/6/2012)
EXEC sp_executeSQL...
November 6, 2012 at 8:15 am
river1 (11/6/2012)
Sean Lange (10/30/2012)
create trigger TRG_CONTRIBUINTES_VERIFCA_RF_E_NIF on contribuintes
for update
as...
November 6, 2012 at 8:04 am
I am glad you found a way to solve your issue and thanks for letting us know.
I'm only disagreeing with the sentiment that listing out the columns is "the way...
November 6, 2012 at 7:46 am
David F (11/5/2012)
menon.satyen (11/5/2012)
You have an incorrect query thats the reason why I asked for sp_help tables.
1. When you do an insert with record_change_date the end then it means...
November 5, 2012 at 3:54 pm
David F (11/5/2012)
Sean Lange (11/5/2012)
Insert Into [Table1]
Select *, GETDATE()
From [Table2]
Where Record_ID NOT IN (Select Record_ID From Table1)
You could also make your Record_Change_date not null...
November 5, 2012 at 3:52 pm
weston_086 (11/5/2012)
November 5, 2012 at 3:38 pm
Looks like all you need is:
Insert Into [Table1]
Select *, GETDATE()
From [Table2]
Where Record_ID NOT IN (Select Record_ID From Table1)
You could also make your Record_Change_date not null with a default of...
November 5, 2012 at 3:29 pm
OK I think this may be what you are looking for.
;with cte as
(
select *, ROW_NUMBER() over (PARTITION by Name order by ParentID) as RowNum
from #oldAccount
)
,cte2 as
(
select *, ROW_NUMBER() over (PARTITION...
November 5, 2012 at 3:08 pm
Viewing 15 posts - 10,126 through 10,140 (of 15,381 total)