I looking for the second result you have given.

1;2;3;4;11;18;17;10;9;8;7;14;15;16;21;22;23;24;25;30;29;28.

How many days left after 9th from the given numbers.

that means for this particulat row the count is 15

Thanks guys.. I am gonna try that and see.

is there a way to split the transactions and execute like ,deleting 5k rows each time. so that it has small log file and can easily get rid of that.

Drop Indexes

ALTER TABLE [dbo].[PRTran] DROP CONSTRAINT [PRTran0]

if exists (select * from dbo.sysindexes where name = N'PRTRAN_si90' and id = object_id(N'[dbo].[PRTran]')) drop index [dbo].[PRTran].[PRTRAN_si90]

if exists...

may be there are relationships between tables and so they are droping indexes so that it allows them to delete blank records.

Actually its an old system running which i need...

Right now we are kind of managing this but it takes lots of time and also locks the tables related and degrades the performance.

The way we do is

Drop Indexes

Delete blank...

Hey guys take a look at my Execution PLan I have attached as zip file.

thanks

When i tried performance check with Execution Plan..

I get cost:94% for scanning the table UserGroupUserGroups when cheking for child and parent group ids.

how do i deal with this cost.

finally i want to test performance for this

How can i test performance for this query. I dont have any data as of now but want to test performance for future.

sorry,i didnt get that article from the search.

since i got the view working, now i have to populate my result set required.

by the way how can i insert some test...

I created a view with cte

WITH UserGroupUserGroups AS (

SELECT

CAST(NULL AS UNIQUEIDENTIFIER) AS ParentUserGroupID,

ug.UserGroupID AS ChildUserGroupID

FROM

UserSecurity.UserGroups AS ug

WHERE

NOT EXISTS(SELECT 'X' FROM UserSecurity.UserGroupUserGroups AS ugug WHERE ugug.ChildUserGroupID = ug.UserGroupID)

UNION ALL SELECT

parentGroups.ChildUserGroupID AS...

how to get nested set representation for those 2 talbes?

Any other idea to deal this?

can u give tht in a tsql query since i already gave all my tables and relationships