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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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,

...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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 to another...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

@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 for the...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

use the Urn.Type for your requirement

foreach (DependencyCollectionNode dcoln in dcollect)

{

if( dcoln.urn.Type=="View")

-- do what you want

}

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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 ...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

how about this one

SET @InvoiceID = 1;WITH rCTE AS

(

SELECT InvoiceID, BookingID, 1 AS HierarchyLevel

FROM #IDs

WHERE...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

may be a Freetext index is a better option

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]