i agree with thomas

well in our concern we have faced a serious issue on this one that's why i posted...

To be honest, it's too much of calculation,

To me finding a geometric sequence with bare hands is not that much easier, when it reach over 10^th term it's...

sorry for the delay i am quite busy in an another work here is what i have you can modify for composite key

USE tempdb

IF OBJECT_ID('tempdb.dbo.Tblone') IS NOT NULL

BEGIN

...

yes that would be the good option, but i don't think that it exceed 100 level, any case suggest me please very interesting to know about it what kind of...

i don't know what you mentioned

USE tempdb

GO

CREATE TABLE [dbo].[EmpTbl](

[Employeeid] [int] NOT NULL,

[EmployeeName] [varchar](50) NULL,

[Department] [varbinary](50) NULL,

[Supervisorid] [int] NULL,

CONSTRAINT [PK_EmpTbl] PRIMARY KEY CLUSTERED

(

[Employeeid] ASC

)WITH (PAD_INDEX = OFF,...

well can you explain the scenario please because see the following code

USE tempdb

GO

CREATE TABLE [dbo].[EmpTbl](

[Employeeid] [int] NOT NULL,

[EmployeeName] [varchar](50) NULL,

[Department] [varbinary](50) NULL,

[Supervisorid] [int] NULL,

CONSTRAINT [PK_EmpTbl] PRIMARY KEY CLUSTERED

(

[Employeeid]...

learn a new thing today don't know that is null work in that way

i am also note out the 0

check it it's not wrong,or you need to change the fifth one

that was awesome this is what i Want,

just for curiosity

the recursive Cte take the fist record and process it further with the rest of the Data's found in xml, is...

thanks for your ref but is it not hard coded, is there a way we can do it dynamically,

is this a tough one

well i got it even a better result

;WITH Users AS(

SELECT 'D' as UserType,ROW_NUMBER() OVER ( PARTITION BY d.Projectid ORDER BY d.Developerid) AS Rid, d.Developerid AS USerid,d.Projectid FROM

i don't think so well try this kind of one

WITH cte AS

(

SELECT TOP 10 c.[object_id], c.column_id

FROM sys.[columns] c

WHERE c.column_id < 3

),cte2 AS

(

SELECT TOP 10 c.[object_id],...

Hi HanShi,

thanks for your advice, but the problem is we are not using the SSRS and More over we create a report for...

DECLARE @project AS TABLE (Projectid INT, ProjectName VARCHAR(100))

DECLARE @Manager AS TABLE (Projectid INT, Managerid VARCHAR(100))

DECLARE @developer AS TABLE (Projectid INT, Developerid VARCHAR(100))

DECLARE @User AS TABLE (Userid INT ,UserName...