Jeff,

select * from TableA

where TransactionDate NOT between dateadd(dd , -90 , getdate()) and getdate()

will be even more faster, but I believe TableB was mentioned in original query on purpose.

Your...

select * from TableA

LEFT join TableB b on a.ID= b.ID AND (a.TransactionDate between dateadd(dd , -90 , getdate()) and getdate())

WHERE B.ID IS NULL

I'm sure you have clustered index on column...

Happy to help you out of that tree.

Did not mention SPID because it's too obvious for such old wolves

No, you've got it wrong.

Result of your expression is REAL.

As I understand it must be DECIMAL(12,1)

So, you need to do this:

CAST(CAST(@n AS FLOAT) / @p AS DECIMAL(12,1))

Check it out for...

You are missing order of operations.

1) you do division. You divide int by int, result is int (see BOL) = 0

2) you do conversion of the division result to DECIMAL(12,1)...

Will this work for you?

Does not modify sysprocesses but lets you catch user defined name and associate it with whatever security context you deal with.

Create table "SomeTable" in pubs on...

You don't need full workload.

You need only indexes used during selects.

What kind of script will tell you which keys on you keyboard are unused?

You need to see all texts you...

Start Profiler.

I would create table function instead of second procedure.

But if you insist on having SP do this:

INSERT INTO #Resultset (... columns list ...)

EXEC dbo.ReportSP (@Month, @Year)

Actually there is a point to specify object type.

If you check for table existence OBJECT_ID will bring you valid ID and you could end up trying insert something into non-updateable...

Yes, saving a CASE is nice thing, but I would prefer to use one CASE instead of repeating query to the same table:

SELECT COUNT(case when PLtat + PLunworkable > 75...

OBJECT_ID('dbo.Result','U') does not work in SQL2000.

Did not try it in 2k yet.

I would prefer to use system functions:

IF OBJECTPROPERTY (Object_ID('Result'), 'IsUserTable')= 1 and OBJECTPROPERTY (Object_ID('Time_definition'), 'IsUserTable') = 1

BEGIN

Your query will include views as well.

You need to add "AND TABLE_TYPE =...

I can assure you: it's 100% not right.

I lost count of my reports created using bcp. And only case when I've got pads is when I've got CHAR or NCHAR...

What you get is a result of SP execution.

In order to change that result you need change SP.

If you cannot change this SP then create another one which will be...