Sorry, please remove the line "AND SYSCOLUMNS.NAME LIKE '%guidRequestIdentification%' " from the above script. I had included them to limit my testing.

I have modified the same script to include UNIQUEIDENTIFIERS and it works. If you are searching for GUIDs, don't include the curly braces.

DECLARE

 @VAR1 SYSNAME,

 @VAR2 SYSNAME,

 @VAR3 NVARCHAR(4000),

 @search_str NVARCHAR(1000),

 @counter INT,

 @dbname...

This shouldn't be hard. Just create a DateValues Table with a date column with every possible date in the date range you are working with.

Example

dt                  

-----------

01/01/2004

02/01/2004

03/01/2004

04/01/2004

05/01/2004

06/01/2004

07/01/2004

08/01/2004

09/01/2004

10/01/2004

11/01/2004

12/01/2004

13/01/2004

14/01/2004

15/01/2004

Then apply the below...