Hi

Here is the possible solution.

create proc [dbo].[parent_child_relation]

@childid char(1)

as

begin

;with cte as

(select Parent,Child from parent_child c

where c.Child = @childid

union all

select c.* from cte p, parent_child c

where p.Parent =...

We can use left function also.

Declare @sss varchar(100)

Set @sss ='12,11,23,34,567,690,4,321'

set @sss = reverse(@sss)

set @sss = reverse(left(@sss,charindex(',',@sss) - 1))

print @sss

You need to take a variable which is of Object data type whch stores all the records into variable

Can you explain the requirement clearly. I am little confused. You want to move files as they come in...or what exactly you are looking for!!!

somebody provide sample data of table!!!

Try soemthing like this!!!

select ID, [Description], Field =

case when ID = 1 then Field1

...

Here is the sample query... for the above post

select [Doc Name],

count(case when [Start Date] between '2010-06-01 00:00:00.000' and '2010-06-07 00:00:00.000' then cast(RegID as...