Viewing 15 posts - 256 through 270 (of 844 total)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 22, 2019 at 12:04 pm
Wouldn't it be more like this?
WHERE Birthdate >= DATEADD(YY, -65, CAST(GETDATE() AS DATE))
AND Birthdate <= DATEADD(YY, -12, CAST(GETDATE() AS DATE))
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 22, 2019 at 10:32 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 22, 2019 at 8:17 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 22, 2019 at 8:12 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 19, 2019 at 10:59 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 12, 2019 at 8:50 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 7, 2019 at 2:52 pm
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 5, 2019 at 12:23 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 5, 2019 at 12:01 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 31, 2019 at 2:58 pm
ManicStar - Friday, January 25, 2019 9:00 AMTaco
Shell
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 25, 2019 at 9:08 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 24, 2019 at 7:28 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 24, 2019 at 7:26 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 23, 2019 at 3:28 pm
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,...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 23, 2019 at 12:41 pm
Viewing 15 posts - 256 through 270 (of 844 total)