ok,

But in my scenario i want the Alter Script, to update. Coz, we are developing a tool to update the other dbs, for that purpose i want to generate...

Hi All,

In the above code, i have noticed a problem that in the #Numbers table,

It is not a problem, just suppose if the query results more than the no.of the...

Greate Vicky,

Thank you very much for providing the solution.

See, this is the requirement that i want in 2000 as well as in 2005, thats I have posted here.

thank you.

it is great, Thank you Liliana.

Yes, you are correct it effects the performance.

Could you please tell the best logic, so i can use (in SQL 2000)

thanks in advance.

Hi All,

Thanks a lot for your help,

I have done this using Cursors,

Here is the complete code,

DECLARE @tblRolesWithComma TABLE(Roles VARCHAR(8000))

insert into @tblRolesWithComma VALUES('Role1,Role2,')

insert into @tblRolesWithComma VALUES('Role1,Role3')

insert into @tblRolesWithComma VALUES('Role1,Role4')

insert into @tblRolesWithComma...

Hi all

Thank you very much for you help.

I have done this using Cursors in SQL 2000.

DECLARE @tblRolesWithComma TABLE(Roles VARCHAR(8000))

insert into @tblRolesWithComma VALUES('Role1,Role2,')

insert into @tblRolesWithComma VALUES('Role1,Role3')

insert into @tblRolesWithComma VALUES('Role1,Role4')

insert into @tblRolesWithComma...

HI,

The above code is working perfectly as what i required. Thank you for providing this.

We need to use the same concept in SQL 2000 also, is there any possiblities to...

there is one column having many rows and each row can have any no of values randing from 1 to 'n'

yes you are rigth,

refernce to the link

-----------------

http://www.sqlservercentral.com/articles/Test+Data/61572/

Using function we can do,

CREATE FUNCTION dbo.fnConcatTest (@SomeID INT)RETURNS VARCHAR(8000) AS BEGIN DECLARE...

Hi,

Thank you for your valuable information.

So, to reduce the Logical Reads we need proper indexing for the tables.

Regards,

Santosh

hi,

thank you very much,

this is what exactly i need,

i am calculating the business hours between two days based on shifts using function,

there i need to eliminate the second saturday's as...

HI,

Thank you for ur quick reply,

I gone through the given link, it gives us the no.of days,

for the given date range,

but

What exactly i want is,

Whether the given...

Ok, Thank you for valuable information.

I will work on tuning..!!