There is no one to many relationship with parent to child, all are one-one.

Yes, this is what I wanted

thanks

Hi,

Please find attached scripts to create and insert data into tables, also I uploaded execution plan for both the queries.

I have written 2 queries one with inner join and other...

hi,

compare saturday and sunday with datename function (datename(w,datefield)) and build your logic.

hope this will help u.

thanks and regards

Raghavendra N S

Hi,

set the initial values if dates are null.

if @startdate is null

set @startdate='19000101' --dummy start date

if @enddate is null

set @enddate=getdate() --current date as end date

and in where clause add Time_Date between...

Hi Sergiy,

my stored procedure is as follows..

basically this procedure should return @NewStatus only once if it is called multiple times for a given @ID

UPDATE Table SET Status=@NewStatus WHERE ID=@ID AND...

You can try this from .Net,

http://dotnetslackers.com/articles/ado_net/SqlBulkCopy_in_ADO_NET_2_0.aspx

Thanks for the reply. I will go with scope_identity.

You can use case, which will ease your problem. But when fields are more you can write dynamic query like this

you will pass 4 parameters to stored procedure, say

@ColumnName...

Hi,

Here you can do this by 2 ways.

1. pass the data type of the column to stored procedure, and create dynamic update statements.

2. you can check datatype of...

hi Zahran,

please try this

DECLARE @Concat as varchar(8000)

SELECT @Concat = isnull(@Concat + ', ', '') + ltrim(rtrim(x))

FROM @T

-- result

SELECT @Concat as Result

Hi Rack,

use truncate statement to delete rows instead of delete statement.

yes , it will differentiate 1 and 11

Hi, All

I have created a stored procedure like this.

create procedure sp_getRelatedDepartments

(

@documentid int

)

as

SELECT * FROM Department WHERE document_list=@documentid OR document_list like '%,'+@documentid OR document_list like '%,'+@documentid+',%' OR document_list like @documentid+',%'

Hi Allen,

thanks for your suggestion, now i did this using like operator, will it affect the performance of sql server if i use like operator?