Viewing 15 posts - 46 through 60 (of 763 total)
Another venting.. first thing though, I don't want to get into the whole argument on of using EOM vs BOM.
Where I work currently they use EOM. Which is fine with...
February 28, 2020 at 5:22 pm
Not a 100% on this, but set the SQL for each to not check for a specific employee. Set the page breaks to be on the Employee.
February 21, 2020 at 8:17 pm
Thanks Brian, this works. And for what I need this for speed isn't an issue. Just saving me time from cutting and pasting or typing.
February 10, 2020 at 10:18 pm
Sorry, I was in a hurry to get this out before a meeting. I don't want the dynamic SQL statement to be stored or used outside of me trying to...
February 10, 2020 at 9:26 pm
Speaking of a comedy of errors. This past weekend they moved our servers to a new location. After the move they released any jobs that were on HOLD. Now I...
February 10, 2020 at 8:48 pm
I heard a song on the radio the other day that was a parody of Aerosmith's 'Sweet Emotions' called 'Sweet Emoji's'. Not sure the comedians name, but it got a...
January 30, 2020 at 9:15 pm
I like the simplicity of finding the February 29 dates, then subtracting that DesNorton posted. But it didn't calculate correctly when I used the start date of 01/01/2019 end date...
January 13, 2020 at 3:54 pm
Thanks for the feedback and info Jonathan, I'll take a look at it.
Found lots of holes in the prior SQL I posted, here is my revised SQL:
DECLARE...
January 10, 2020 at 7:51 pm
Of course, if I would read through the comments(at the link I posted), Jeff Moden would have a simpler way to determine a leap year.
SELECT
CAST(DATEDIFF(d, @Eff_Date,...
January 10, 2020 at 5:48 pm
Maybe I just needed to post something to get the brain going.
Here is what I came up with. I borrowed some code I found at https://www.mssqltips.com/sqlservertip/1527/sql-server-function-to-determine-a-leap-year/
January 10, 2020 at 5:24 pm
Adaptability, I think is key to survival in this business. But as Jeff said 'change for the better is not'. And at my previous job I was labeled 'resisting change'...
December 23, 2019 at 6:11 pm
Happy Holidays to all! I don't think I'll see Star Wars this weekend. Even though I have a chance to go see it for free on Friday, plans changed so...
December 18, 2019 at 2:30 pm
p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, it doesn't get...
December 4, 2019 at 8:22 pm
Is anyone one else still getting directed to the wrong page of responses? I was on the 'Active Threads' view and clicked on the link for Josana.work response on this...
December 4, 2019 at 5:32 pm
p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, it doesn't get done. ...
December 4, 2019 at 3:51 pm
Viewing 15 posts - 46 through 60 (of 763 total)