Hi,

I don't understand your issue here, but what could be happening is.

That the create stored procedure action of you is not held against the

database statistic and optimizations, and therefor the...

Hi,

I would suggest to stay out of the Three-State-Logic with NULL's involved.

This could be very complicated when working with complex database solutions.

A simple idea could be;

Create Procedure s_ProductTest

@parm1 int =...

Hi,

It can be done many ways, depends on the solution you want.

Here how it can be done in a simple query;

select

 product,

 max(case productsize when 'Sm' Then 'Sm,'Else ''End) +

 max(case productsize...

Hi,

Try to study the microsoft articles carefully, you will find them in:

http://support.microsoft.com/kb/325023/en-us

Although I never did an upgrade from MSDE to SQL 2000 Standard or Enterprise,

the microsoft site suggest it...