declare @Attorneyrname as string

declare @Report_Parameter_1 as string

declare @params table (ID tinyint)

if @Report_Parameter_1 = 'All'

Begin

   insert into @params (ID)

   select 1 union

   select 2

End

else

insert into @params (ID)

select CASE @Report_Parameter_1...

Basically......

Well, You don't.

Reporting services only works with recordsets.

No access to Return Codes.

I have never needed to use Output parameters, but I don't think you can as mentioned RS only...

Go to Report Parameters.

Modify your Query

Assign Report parmeter to query Parameter

Hope this make...

the Logical design is not saved anywhere in the database that you can query for.

you have to figure it out by the way its modeled.

if CustomerID is the primary key...

Can you verbalize your requirements a little better,

You stated that it is a many to many relationship.

a customer has many contacts, but can a contact belong to many customers?

the...

I believe yes.

When you shutdown your server, all services are stopped. at which point sql server "Closes" the mdf and ldf files.

apon reboot, sql server basically "Opens" the files again,...

You are correct sir.

If the app is explicitly passing in a null then sql will insert the null. If you put a not null constraint on the field then app insert...

Personally i'd make the presentation layer do it.

But you can use a UDF to do the same thing.

-- Set up Test Scenario

use pubs

Create table mytable (pk int identity, [ID] int,...

He he , Your funny, unfortunatelly t-sql and dates is not the functionality that sets MSSQL apart from Mysql.

Its always a good idea to...

Can you elaborate any more?

A few things you need to make sure a partitioned view perform well.

Each table needs to have a check constraint on the value you are partitioning...

Dare I say parameter sniffing.

When I see the behavior where straight t-sql runs fast, but procedure runs slow, is the query plan getting stored by the optimizer is not correct...

well it loooks like you have your data type declarations incorrect.

you have declared a numeric (10,0)

which means your number can only be up to 1,000,000 with no decimals.

If any numbers your...

A where clause must be constructed in the form of an expression.

so

Where p.SellerProductID not like '%-Wav%'

So you cannot have the entire portion of your expression within a single then statement of...

Check it out in books online.

http://msdn2.microsoft.com/en-us/library/aa933054(sql.80).aspx

You still need a method of authentication so you will know which reports a user can see.

Reporting services has Forms authentication, but it takes a little work.

http://msdn2.microsoft.com/en-us/library/ms152899.aspx