Viewing 15 posts - 10,126 through 10,140 (of 15,374 total)
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
Also there needs to be some rationale more than just name for when there are more than 1 child rows.
Consider this:
select * from #oldAccount where Name = 'MyAccount1' order by...
November 5, 2012 at 2:09 pm
Zeev Kazhdan (11/5/2012)
You're correct - the values for #oldAccount.newId and #oldAccount.newParentId will come from #newAccount.Id and #newAccount.ParentId respectively. An only common field between the two tables is NameThank you
But can...
November 5, 2012 at 1:46 pm
Viewing 15 posts - 10,126 through 10,140 (of 15,374 total)