Sounds like a nice idea for some.  For me I don't have any trouble using all of my PTO, OK I carried over a day this year.  I've stated this...

Try adding this WHERE statement:

WHERE DLA7 >= DATEPART(YEAR, DATEADD(MM, -6, GETDATE())) * 1000 + DATEPART(dy, DATEADD(MM, -6, GETDATE()))
The DATEADD is subtracting 6 months from...

Search for table name across all databases on serve:

CREATE TABLE#temp_list

(

db_names        varchar(500),

tbl_names        varchar(500)

)

;

EXEC sp_msforeachdb'INSERT INTO #temp_list SELECT "?" AS db_names, name AS tbl_name FROM[?].sys.tables'

;

--SELECT COUNT(*)

--FROM #temp_list

--;

SELECT *

FROM #temp_list

WHERE...

You're embarrassed?  I know I've been working on SSRS reports for more than 10 years and I didn't think of it, now that's embarrassing.  And only after reading your thoughts...

I often thought about this, why we didn't have a place to 'log' the changes we are making to a report.  
I really like your idea of creating a dataset,...