I wound up using a couple of IF Else statements.

IF @type='Auto'

BEGIN

Select *

From Table

Where Class in ('RD','MD','RS')

END

IF @type='Industrial'

BEGIN

Select *

From Table

Where Class in ('ID','IW','JP')

END

ELSE

BEGIN

Select *

From Table

END

I've tried that, but what it does is treat everything inside the ' ' as 1 value of MD,RD,RS instead of the 3 separate...

to answer my own question:

DECLARE @OldUserID uniqueidentifier

DECLARE @NewUserID uniqueidentifier

SELECT @OldUserID = UserID FROM dbo.Users

WHERE UserName = 'MYDOMAIN\someuser'

SELECT @NewUserID = UserID FROM dbo.Users

WHERE UserName = 'MYDOMAINewuserhere'

UPDATE dbo.Subscriptions

SET...

I fixed it. I deleted the virtual directories from IIS and recreated them in the Reporting Service Configuration Manager. After that I was able to configure the Web...

The SMTP works fine. Running Svr 2003. I can send myself emails using database mail.

Paul White (6/24/2009)

---

Could I ask also that you confirm that we should compute the running totals in descending percentage order?

For example, if the available percentages were 35%, 20%, 15%, 10%...

I think that is going to work.

Thanks

I'm not sure what you are asking for. This?

If ShopDay between 1 and 5 then exec sp_ClassA

If ShopDay between 6 and 18 then exec sp_ClassB

If ShopDay between 19 and...

Well I do not understand why using the multivalue parameter caused the scans it did when hardcoding the same values works just fine, but creating a indexed temp table worked...

The tables I can copy. I start running into problems when I try to copy the views. The views are using udf and uxp procedures and it looks...

I am trying to replicate the Application DB, but the application has modifications to the Master DB as well. I have tried to copy, but I keep getting this...

That did the trick. Thanks

Sorry, I'm not always good at putting my questions down in words.

From msdn.com

"If you are distributing reports within an intranet and you are using an SMTP gateway to...

i am not designing a table or a database. the problem was not how the table was designed. the problem was how to use the tables that i have...

I got it with the CHARINDEX. As soon as I saw your post I knew that was the key, I just couldn't get it to work. Turned out...