This:

CREATE TABLE #Test(TestID int)

DECLARE @Inserts TABLE (TestID int)

DECLARE @InsertCount int

INSERT INTO #Test

OUTPUT inserted.TestID INTO @Inserts

SELECT 1 UNION SELECT 2

SET @InsertCount = @@ROWCOUNT;

PRINT @InsertCount

Somethin more like this?

Select

approxrank,

Count (approxrank) as BeltCount

From

PersonalFinance PF

Inner join PersonalProfiles PP

...

Duplicate post. Please post answers here.

The manager who did my third interview where I now work actually researched me. He read my blogs, articles, and asked questions based of those as well.

Easy question, good for a Monday when starting a new job.

Jack Corbett (3/1/2012)

---

Lynn Pettis (2/24/2012)

---

Quite an interesting day. I gave my two weeks notice and was basicly told that I would not need to come back. ...

I agree that we need to pass along our knowledge to others in our field of work. But the mentoring has to be a two way street, the person...

Perhaps something like this:

SELECT

ExamsId ,

DateOfExam ,

PAPERNAME,

FROM

TBLEXAM

WHERE

PAPERID = 2

...

CELKO (2/29/2012)

---

This is an old Sybase syntax which goes back to the pre_ANSI Standards days. You will also see UPDATE.. FROM.. and *= in the code from that era.

The...

Please read the article I suggested. It may be for deletes but the...

AndrewSQLDBA (2/29/2012)

---

Hello Everyone

I found something today, that I do not ever remember seeing in the past.

I found a table name with the word '(obsolete)' directly next to it. I have...

I must be missing something then. I was pretty...

MyDoggieJessie (2/29/2012)

---

DELETE

FROM loadprogress.[PUB].[TC-CARD]

FROM loadprogress.[PUB].[TC-CARD]

JOIN #TCCard_Temp t ON

t.TCNum = [tc-number]

AND t.TCCard = [tc-card]

AND active = 0

Can't say I've ever seen a double FROM clause like this, but it...

I haven't done this in an OLTP system, but in an ODS environment I have setup the tables to allow me to see what day to day changes have occurred...

You may want to read this article: Deleting Large Number of Records[/url].