halifaxdal (9/19/2012)

---

Other than waiting and applying...

Boris Pazin (9/19/2012)

---

Hi All,

There is a job which executes each day and copy some records from one table to other.

The query looks something like:

INSERT INTO DestTable

...

SQLKnowItAll (9/19/2012)

---

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test SELECT * FROM...

Miles Neale (9/19/2012)

---

Hugo Kornelis (9/19/2012)

---

Huh? Why?

SELECT TOP ... without ORDER BY is like saying "give me the first...

Then the MERGE as the fine example already posted is exactly what you want. Here is the link to the BOL article about MERGE.

http://msdn.microsoft.com/en-us/library/bb510625.aspx

Miles Neale (9/19/2012)

---

I would say also that it was dishonest, or at a minimum deceptive. In any case it shows that you can not always trust certain functions of...

Brandie Tarvin (9/19/2012)

---

Yep.

My current drama is...

rhythmk (9/18/2012)

---

Kingston Dhasian (9/18/2012)

---

1.How many columns a SQL table can hold.

2.How many string functions are there in SQL.

3.How many non-clustered indexes a SQL table can have.

4.What is the port to...

My answers would have been similar to this.

I don't know the exact number but it is far more than I have ever needed...

Paul White has great 2 article series about Apply.

Understanding and Using APPLY (Part 1)[/url]

Understanding and Using APPLY (Part 2)[/url]

--posted to wrong post, sorry.

No offense but you seem to keep posting this same link to your blog over and over. Sadly,...

Hi and welcome to SSC!!! It is somewhat unclear exactly what you are trying to do but in your trigger you are not referencing the insert virtual table. http://msdn.microsoft.com/en-us/library/ms191300.aspx

If you...

sknox (9/19/2012)

---

Another QotD which does not test what it purports to test.

Even if you know TABLESAMPLE inside and out, you cannot expect to get this question correct without knowing...

Ahh...

--McCrackis Philled