Viewing 15 posts - 6,361 through 6,375 (of 13,874 total)
@Patrick123 (11/8/2016)
Hi,I want to delete temp table by joining dervied table.
EX:
; with cte
(
select * from employee
)
delete #temp
from #temp a
inner join a.id=cte.id
Or here's another version with a semi-join:
delete t
from #temp...
November 8, 2016 at 5:35 pm
komal145 (11/8/2016)
November 8, 2016 at 12:57 pm
komal145 (11/8/2016)
I did use lookup on column3 but this way we get only matched data right? i need all data + matched one too to insert into new table.
Have you...
November 8, 2016 at 12:46 pm
komal145 (11/8/2016)
November 8, 2016 at 12:25 pm
liorvikel (11/8/2016)
when i run this insert throw oracle localy (not throw dblink from mssql)
its worked .
but if i disable all constaint in oracle . that...
November 8, 2016 at 9:01 am
liorvikel (11/8/2016)
when i run this command in mssql
insert into [LinkedSRV]...[xfer_in_order] (seq_id, action_type, action_code)
values(2001, 'PTL_TEST', 'M')
i get error :
OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedSRV"...
November 8, 2016 at 8:06 am
And as you have no time component, consider using the DATE datatype, rather than DATETIME ... if you do, you'll save 5 bytes per occurrence.
November 8, 2016 at 7:00 am
richlion2 (11/8/2016)
I came accross this blog (like many other articles) and I cannot make out what is the correct syntax:
https://www.brentozar.com/archive/2016/04/updating-statistics-ola-hallengrens-scripts/
I can't copy paste the syntax, because it gives me...
November 8, 2016 at 5:43 am
komal145 (11/7/2016)
Ok. first let me ask. How can we write condition in conditional split where State in (us ,asia)?
Something like this
UPPER(State)=="US"||UPPER(State)=="ASIA"
Slightly off topic, but the United States is a...
November 7, 2016 at 1:14 pm
You need a single conditional split, with three different outputs.
November 7, 2016 at 12:57 pm
BowlOfCereal (11/7/2016)
Wow! Thanks for the quick and helpful reply. The code isn't quite perfect (3.0 returns 3.1, for example), but it gives me a great head start. 🙂
No...
November 7, 2016 at 11:21 am
BowlOfCereal (11/7/2016)
Looking for some quick help with a bit of SQL. The best way I can describe it is that I'm trying to add 1 to the least...
November 7, 2016 at 10:56 am
MyDoggieJessie (11/7/2016)
November 7, 2016 at 8:42 am
November 7, 2016 at 8:20 am
MyDoggieJessie (11/7/2016)
The table design is horrendous...in fact this is a rather small table 🙂 It's a...
November 7, 2016 at 8:10 am
Viewing 15 posts - 6,361 through 6,375 (of 13,874 total)