Use "Design Table" in EM.

Make all desired changes but don't press "Save". Click on "Create Script" and copy it to QA.

What are the values of @Stream1 and @Stream2

So,

select h.salesrep_Name ,disp_code,description,count(act_status)

from modifiedcalldata m

LEFT outer join histdata h on m.prog_sol_number = h.prog_sol_number

LEFT outer join dispositions d on d.disp_code = m.act_status

where month(calldate) = 3

group by h.salesrep_Name ,disp_code,description...

REPLACE(Country, ' ', '')

SELECT col1, col2, col3, MIN(col4)

FROM

GROUP BY col1, col2, col3

Which table column "calldate" belongs to?

Which table is main in this query?

Why you need it?

Where you gonna use it?

You don't need cursor at all.

DECLARE @TBL TABLE (

 PCT int,

 CDate datetime,

 GroupCol varchar(50))

INSERT INTO @TBL

SELECT 20, '2006-04-01', 'A'

UNION

SELECT 15, '2006-04-02', 'A'

UNION

SELECT 12, '2006-04-03', 'A'

UNION

SELECT 17, '2006-04-04', 'B'

UNION

SELECT 14, '2006-04-05', 'B'

UNION

SELECT...

So, there is no JOIN, there is INNER JOIN, and you may use alias name "JOIN" for referensing actual "INNER JOIN".

Same for LEFT JOIN and LEFT OUTER JOIN.

If you do...

Seems it's locking problem.

Check sp_who or sp_who2.

Optimiser choses the fastest way to execute query. That's why it applyes strongest condition first to eliminate maximum number of rows from resultset.

" > 5" is stronger that "ISMUMERIC", that's...

Author must have used set of values with another year.

Because he displays the table with value '2002-02-29' in datetime column.

It's impossible.

I think originally there was another year in those examples,...

It's obvious that author just used not the same DATEFIRST settings on his server as you.

I better not comment the code. Just for a purpose not to appear rude.

But you cannot supply empty string as a parameter to your SP because all of your parameters...

There is no "JOIN" ib SQL 2000.

There are:

INNER JOIN

LEFT OUTER JOIN

RIGHT OUTER JOIN

FULL OUTER JOIN

Which one you mean to use?

If you mean "INNER JOIN" (parser will make this replacement automatically)...