So, why not views?

SELECT O.* FROM orders O

INNER JOIN dbo.orders_approved A ON O.order_id = A.order_id

INNER JOIN dbo.orders_by_region R ON O.order_id = R.order_id AND R.region_id

INNER JOIN dbo.orders_by_manager M ON  O.order_id = M.order_id AND M.employee = 1

INNER JOIN dbo.orders_by_year...

If your SP is a single query you may consider replacing it with a view or a table function.

Try it for

set @inputdate =  '12/31/06 00:00'

Stupidiest idea to store date as int(CYYMMDD format)!

How you would explain Server that 20061201 = 20061130 + 1? Not to mention heaps of other problems created by this approach!

You need...

You better read a little bit about design of relational databases.

Why would anybody need it?

Error 'string or binary data would be truncated' has nothing to do with EXEC(@String)

It happens when you are trying to insert character value with length > 50 into varchar(50) column.

Check the...

It contains list of parameters, not columns from returning recordset.

Database just cannot contain this information.

SP may return different results depending on the values of parameters, it may return more than...

You are probably missing the case of February.

You better use :

IF DAY(@date) <>  DAY(dateadd(MONTH,-6,@date))

....

You don't need 30th ot 31st date. You need LAST date of the month.

Last day of the month is ALWAYS the one day before the 1st of the next month.

1st...

Right-click on the database in EM. Choose All Tasks - Generate SQL Script.

Include all objects. Run. Save it. Run to create new empty database.

Runs faster than delete from a...

If there are FK's the order of tables to delete data from is really important.

They say that one of two betting is a cheater and another one is a fool.

Pretty sure.

Wanna bet?

It would be much quicker if you would have table dbo.PostCodesDistance with columns

PostCode1ID, PostCode2ID, Distance.

You may insert/update records in this table every time you add new post codes in your...