Masochism? 😀

NP. Sometimes a fresh pair of eyes is all that's needed.

Matt.Altman (11/9/2016)

---

Hello,

I have a stored proc I am trying to run but I am getting the error

"Conversion failed when converting date and/or time from character string"

The original table looks like...

Thanks for the well-written article. I haven't used BIML for a...

Or here's another version with a semi-join:

delete t

from #temp...

komal145 (11/8/2016)

---

i am doing look up on destination to see if there is key already exists if not insert new record. SO i cannot send both match and unmatched to...

Have you...

komal145 (11/8/2016)

---

I have a stage table S and new columns from other table T , i want to do left join on stage S to get all columns and new...

liorvikel (11/8/2016)

---

its not error constranit realy.

when i run this insert throw oracle localy (not throw dblink from mssql)

its worked .

but if i disable all constaint in oracle . that...

liorvikel (11/8/2016)

---

i have somthing strnage.

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"...

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.

richlion2 (11/8/2016)

---

Hello,

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...

Something like this

UPPER(State)=="US"||UPPER(State)=="ASIA"

Slightly off topic, but the United States is a...

You need a single conditional split, with three different outputs.

No...