Thank you!!

Thanks Serg and MadAdmin....I took your suggestions and did a similar approach based on the specific outcome I was looking for and I got it to work.

Much appreciated!

Thanks for the suggestions.

The one with the derived tables was faster and didn't do a table scan, it performed an Index Seek. It was only slightly faster with the derived tables on...

I think I just answered myself....In BOL for "LIKE" it does not mention anything about the {#} in pattern matching therefore I'm assuming you can't do it as I was...

Thanks Ben and Camilo.

Thanks for your help Carl. I've been looking at this query and modifying it numerous times over the past 3 days and got stuck on that....ahhhhh!....Thanks again!

Thanks it seemed to help with setting the date parameters to local variables....=)

We're using a C# Windows app which calls the stored proc and returns the data to a crystal reports viewer. We're using the function instead of the stored procedure...

With that I am getting this error message:

Server: Msg 197, Level 15, State 1, Procedure WAPSnapshotProc, Line 62

EXECUTE cannot be used as a source when inserting into a table variable.

Follow...

Can you give me an example with my function....I'm not sure how to use/create dynamic SQL.