Hi.. What about this

declare @str varchar(100)

select @str = @str +','+ + fld_index FROM table_index where table_index in (select distinct fld_index FROM table_index )

you will hv to remove...

There is a option to generate scripts. Rightclick on the db\Tasks\GenerateScripts. On the "choose script options" page can say "True" to "Include IF NOT Exists."

You have not passed the start value for the charindex function.

Ex:- CHARINDEX(',', Logins,1)

ThankYou Gail. I have done exactly what you said in your mail.

One more thing... supposing that this is live production database with a large amount of data...

Hi

There are many experts out there who can continue this thread... So keep the dice rolling....:cool:

Hi

The main issue here lies with the choice of data type , but cast does have some impact on performace specially if the number of rows are large.

You can use the PIVOT operator for this. It transposes rows into columns. Check out BOL for this. If you any issues then come back here.

yes use sys.dm_db_index_physical_stats.

Gail

Thanks for your response & Sorry for the delay in replying.

Your suggestion to run DBCC CHECKDB worked . It returned some errors. Mostly the error said that...

Hi

Jasmin's code looks good. A simple holiday table would have the following self-exlpanatory columns.

HolidayID - Identity column

HolidayDate - Datetime

Description.

You could go further and insert all the satrudays & sundays...

Hi Gail

Iam a sysadmin. I login as SA.

Thanks

Hi

thanks for your response.

I have already queried sys.objects table and there is no object named "PositionInsert_sp".

even if i create the procedure with the following code i get the error "There...

Hi

I agree with jaypee... Its much better to keep a holiday table. Its a flexible design and also the querying to find out the next working day will be easier.

Hi

Name of the procedure is irrelevant but here its is

"PositionInsert_sp". To add i could successfully create a procedure called "PositionUpdate_sp" .

Hi

is it deferred name resolution ?