I think it should be

Select IDENTITY(Numeric, @MAX_ID, 1) AS RowNum, * into #t2 from #t1

This does work in my machine. Check the alias name given to COUNT(*) field.

DECLARE @strColumnName VARCHAR(100)

DECLARE @strTableName VARCHAR(100)

DECLARE @strColumnValue VARCHAR(100)

DECLARE @strSQL ...

Add this block above the EXECUTE( @strSQL ) statement

SET@strSQL = ' SELECT * '

+ ' FROM ( ' + @strSQL + ' ) T '

+ ' WHERE Count > 0...

This should help..

DECLARE@strColumnNameVARCHAR(100)

DECLARE@strTableNameVARCHAR(100)

DECLARE@strColumnValueVARCHAR(100)

DECLARE@strSQLVARCHAR(MAX)

SET@strColumnName = 'EmployeeID'

SET@strTableName = 'mstEmployees'

SET@strColumnValue= 6

SELECT@strSQL = COALESCE( @strSQL + ' UNION ALL ' + CHAR(10), '' )

+ ' SELECT''' + OBJECT_NAME( FK.fkeyid ) + ''' TableName, COUNT(*)...

Yes, it does. It can delete any number of rows.

Try this

DECLARE@tblTable TABLE

(

Col1 INT

)

INSERT@tblTable

SELECT1 UNION ALL

SELECT1...

But, don't you think the method would be a bit tedious....

Look at this buddy

rajagopalanseeth (3/29/2010)

---

if there is 3 duplicate records found, i want to delete only 2 records and keep the...

You can use the ROW_NUMBER() function. It would have been helpful if you would have given us the table structure and some sample data to work with.

Glad to help you out:-)

This should help you out..

DECLARE @tblTable TABLE

(

AN_CODE1 VARCHAR(50),

AN_CODE2 VARCHAR(50),

[VALUE] INT

)

INSERT @tblTable

SELECT 'CAP', 'ENERGY1', 200 UNION ALL

SELECT 'CUR', 'ENERGY1', 400

SELECTAN_CODE2,

SUM( CASE WHEN AN_CODE1 = 'CAP' THEN [VALUE] ELSE 0 END )...

chandrasekaran.ganapathy (4/8/2010)

---

Hi Kingston and all,

Got it. I have read some article. So If i make a query like

Select * from employeeId where employeeId between 'xxxxxx' and 'xxxx'

or

Select * from...

My method makes use of ROW_NUMBER() and NEWID(), ROW_NUMBER() a ranking function and NEWID() a function that returns a unique value for every row in the result. You can Google...

You can never execute an Index. To get the data you will have to always SELECT * from the table.

And one more thing, is you get some script from somewhere...

Looks like too much of code to me too. But this works

IF OBJECT_ID( 'tempdb..#tmpOrdered' ) IS NOT NULL

DROP TABLE #tmpOrdered

DECLARE@tblTable TABLE

(

FranchiseID INT,

SectorID INT

)

INSERT@tblTable

SELECT 1,...

Trybbe (4/8/2010)

---

the query I tried is:

Insert into Areas

Select...