actually in our Db it is look like this, i change my code for a single project but actually it is for multiple project

DECLARE @res AS TABLE (Id INT, PName...

people here are help you please mention the table details you used

(i.e)

columns you used in first table and columns you used in second table

and its data type etc...

i am not sure what you but here is my solution

SELECT c.CLIName1, c.CLICode, g.AGPName1 AS [GL Account Group], a.COAName1 AS [GL Account], d.DIVName1,

...

i think that's because your logic at the first cycle @min-2 is 1 and @end is 10000, so you insert all the record in the table...

Merge in msdn just read it i think you get a clear vision

@john-2 Mitchell-245523

Thanks that was superb, this is why i posted here, a new logic in different dimension actually i use my base table in Devdb

thanks...

but the scan count that's what make me worry when there is no primary key or unique key,

yes and i have the primary key in my original table for...

Sorry, seems something not clear in this question, in the Question (select 4) what it means

i am choosing 2 3 5 it say i am wrong

if object_id('test2') is not...

use the Urn.Type for your requirement

thanks for your response bro, i tried it works thanks , just make a little bit faster here which will increase the IO opeartion also

SELECT a.Eid, b.cDocNo

FROM ...

this is my contribution

USE tempdb

GO

IF OBJECT_ID('TestTbl') IS NOT NULL

DROP TABLE TestTbl

CREATE TABLE Testtbl (id INT PRIMARY KEY)

INSERT INTO Testtbl

(

id

)

SELECT TOP 1000 ROW_NUMBER() OVER ( ORDER BY c.object_id) id FROM...

thanks for you assistance i am just learning now how to use xml in sqlserver please assist me, can give some link to see like this kind of stuff

how about this one

SET @InvoiceID = 1;WITH rCTE AS

(

SELECT InvoiceID, BookingID, 1 AS HierarchyLevel

FROM #IDs

WHERE...

may be a Freetext index is a better option

seems this Cross Tab Procedure[/url] will help your to solve this issue