Yes, it is SS2000, though I never can decipher the error messages headers of 'State X, Level Y' apart from the 'Line 3' part.

But I think I fixed the problem,...

Thanks, Mr Polecat. Problem Solved.

I want to calculate the date associated with 3 day of 3 week of next month. If Sunday is taken as Date First it would be 11/13/2007. This needs to...

SQL Server is a Relational Database Management System. It has many powerful features that help in administering complex databases. Although we can write many programs in it, it has limitations...

I ran Saritha's code and my @sql var builds up as:

Update #temp set Oct = case when @col = ''Oct'' then @oct else @sep end

I am puzzled why...

Many many thanks to each of you for your help. It's been a great help.

Thanks all for your tips.The VB forum gys recommended formatting in backend and the SQL forum guys say do it in frontend. Isn't it interesting?

create table CustomerFlags

( CustomerId not null

, CustomerFlag not null

, constraint CustomerFlags_P primary key (CustomerId , CustomerFlag )

)

create table OrderFlags

( OrderId not null

, OrderFlag not null

CustomerId not null

, constraint OrderFlags_P primary...

Thanks a lot, it really helped. The duplicate post came accidentally when I lost my connection briefly yest. I triedto delete it twice but no dice.

Thanks, Vladan, for your explanation. And yes, I am talking of the datetime datatype.

I suspected as much. Unlike most of the members here, I am not a SQL Server professional...

I am not much of a Windows engineer (I can hardly distinguish between Windows domains and workgroups). The server I am referring to is installed on my development PC. My...

I won't claim to be an expert in SQL Server but the possibile cause that quickly comes to mind is that SQL server resultsets dispalyed in EM will often prompt...

Works fine for me. Have you double-checked the rest of your syntax?

Also try replacing the variable with a hard value.

I have 2 issues with the table:

1) it seems to be doing too much

2) it's conceivable that a person could find themselves in this table, even though they're neither a...

I normally place a GO before any CREATE statements to distinguish the BATCH.

SET @cmd = 'USE ' + @dbname + ';GO;CREATE VIEW...