It all depends on how quickly you have to get the data from A to B, first option would be a linked server (via ODBC), have you tried this?

😎

First thought would be the PERMISSION_SET, check this out on the subject: http://technet.microsoft.com/en-us/library/ms345101.aspx

Ciao 😎

Window function solution, works on 2012 and later

😎

Create Table #Temp (ID int not null primary Key, Name varchar(25) not null, DOB datetime not null, Sex char(1), Race char(1), Height int,...

No better way of putting it!:-D

GilaMonster (4/9/2014)

---

Eirikur Eiriksson (4/9/2014)

---

According to my findings (observed behavior) , using the minus "-" bypasses (for the lack of better word) the logical operator, select * from table where x...

dj341 (4/9/2014)

---

Eirikur Eiriksson (4/9/2014)

---

According to my findings (observed behavior) , using the minus "-" bypasses (for the lack of better word) the logical operator, select * from table where x...

According to my findings (observed behavior) , using the minus "-" bypasses (for the lack of better word) the logical operator, select * from table where x >- y brings...

I have a sketch but cannot have it ready until the end of the month, is that OK?

The transaction is still logged, everything that happens between begin tran and commit tran must be logged, regardless whether it is an implicit...

Increase the...

Slightly twisted but works 😎

CREATE TABLE #ColumnNames

(

ItemNumber INT,

ItemValue VARCHAR(200)

)

CREATE TABLE #ColumnValues

(

ItemNumber INT,

ItemValue VARCHAR(500)

)

CREATE TABLE #XML

(

XMLDocument XML

)

INSERT INTO #XML (XMLDocument) VALUES ('<properties>

<Prop1>ABC</Prop1>

<Prop2>1</Prop2>

<Prop3>2014-01-01</Prop3>

<Prop4>52.12</Prop4>

</properties>')

INSERT INTO...

Would be nice to have some information on the enhancements from 110 to 120.

😎

Sean Lange (4/8/2014)

---

Eirikur Eiriksson (4/8/2014)

---

hisakimatama (4/8/2014)

---

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the"...

Check "Jorgensen, Adam; Wort, Steven; LoForte, Ross; Knight, Brian (2012-03-28). Professional Microsoft SQL Server 2012 Administration"

😎

hisakimatama (4/8/2014)

---

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the" way to do it....