Viewing 15 posts - 13,921 through 13,935 (of 26,486 total)
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
March 5, 2012 at 9:00 pm
Somethin more like this?
Select
approxrank,
Count (approxrank) as BeltCount
From
PersonalFinance PF
Inner join PersonalProfiles PP
...
March 5, 2012 at 3:07 pm
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.
March 5, 2012 at 2:57 pm
Jack Corbett (3/1/2012)
Lynn Pettis (2/24/2012)
March 1, 2012 at 10:38 am
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...
March 1, 2012 at 10:35 am
Perhaps something like this:
SELECT
ExamsId ,
DateOfExam ,
PAPERNAME,
FROM
TBLEXAM
WHERE
PAPERID = 2
...
February 29, 2012 at 3:22 pm
CELKO (2/29/2012)
The...
February 29, 2012 at 3:14 pm
Kwisatz78 (2/29/2012)
Ahh no worries at least its not me going mad, its been a long day 😛
Please read the article I suggested. It may be for deletes but the...
February 29, 2012 at 10:06 am
AndrewSQLDBA (2/29/2012)
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...
February 29, 2012 at 10:03 am
Kwisatz78 (2/29/2012)
How is that? Have I just explicitly stated what it was implicitly doing? None of them are nested
I must be missing something then. I was pretty...
February 29, 2012 at 10:00 am
MyDoggieJessie (2/29/2012)
DELETEFROM 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...
February 29, 2012 at 9:55 am
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...
February 29, 2012 at 9:51 am
February 29, 2012 at 9:42 am
Viewing 15 posts - 13,921 through 13,935 (of 26,486 total)