Thanks for all the help.... but seems management changed their minds... again... grrrr..

I modified the code a bit based on above so here is the current code:

CREATE...

Thanks Mark.

had to make a change. Gave me an error:

Msg 242, Level 16, State 3, Line 9

The conversion of a varchar data type to a datetime data type resulted in...

Dang thought I was done....

One more thing I need to reslove.

I have some "pickdates" from #DaysinStatus on the first row that may be NULL. How can I SET the...

I got it with the above help... Had to change #DaysinStatus.rownum to d.rownum

Thanks!!!

thanks for the quick reply... but didn't work...

#DaysinStatus.rownum couldn't be bound...

YES!!! Initially it would actually 'Filed' but that is exactly what I need... 🙂

First let me say, I appreciate the help.... I know it is difficult to work with someone that doesn't explain very well his needs due to lack of experience....

The unique...

Kind of but not way off base.... First I apologize... I am not a DBA but a hardware guy that got suckered into writing SSRS reports.... with that said......

There are 2 tables that are required:

Here is the query to pull the data:

SELECT case_pick.case_sk, case_pick.group_code, group_items.description AS Status

FROM ...

WOOOHOOOO!!!! That got it!!! THANKS JACK FOR YOUR HELP AND PATIENCES IN THIS...

I apologize for being a block head... this stuff is a bit outside my skill set....

OK so far I am not doing to bad... couldn't get the syntax correct for convert so used cast instead. So I modified this section based on your recommendations:

SELECT ...

It is a view but the base table is the same for the address_1 column. The view simplfies some joins I need to return the entire address (i.e. name of...

Philipp Post (2/20/2009)

Am I incorrect in this thinking? or Is it better to pass the enitre table. I figured that passing the field would be more efficient than passing the...

The table does have a primary key and this is just one of the tables that I may have to pull an address from but all the tables that I...

I am making some progress... I am using the code that Jack put above (thank you Jack)... I am kind of got it running....

First, I am running this against...