Ok I found the problem... I didn't drop the table and it inserted the result set a couple of times. This happened prior to me doing a select with a where clause....

Well not really.... now I know that it's just really screwy. Thanks for the replies it helped to return some interesting results. I'll poke around some more and post when I...

I missed your select statment. I tried that and "ordered by" the column I'm including in my where clause. When I ran that it returned 261 rows many which are...

Distinct is not specified but there are a lot of joins. However it still doesn't make sense.

When I run the procedure there are no duplicate rows. The output from running...

Thanks everyone for the suggestions and quick replies. I didn't think it was that simple.

Rao,

The original statement didn't work exactly (but it was close) and utlimately helped me find my solution. It only provided results for one row. So I added a second select statement...

Steve,

Thank you for the reply as well. The rowsize isn't going to be large at all for this paticular email nor will the complete record set. However we do send a lot of SQL driven...

Rao, Thank you for the response.

I'm not worried about reaching my variable size limit. Right now I'm only returning 4 rows with maybe 10 bytes each. However what you provided didn't...

Ok I understand Default Constraints now... These columns all have default values set to them.

I was looking into constraints because we are calling a view from an application and...

Here is the error I receive when run in Management Studio:

Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near '{'.

Here is my code:

{

CALL...

Thanks John,

I moved the tempdb some time ago and there were very specific instructions for it. However I wasn't sure if the reportserver tempdb required the same sort of instructions. I'll...

Yeah if I keep doing it they both run about the same.

For this paticular status the SP took 2 secs the SELECT Statement took 12.

Ken,

Your onto something. I just created that SP and tested it against "select * from v_order where ShipmentStatus= 'Live' "  and the SP blew away that select statement. There is...

Ken,

They both take the same amount of time.