Viewing 15 posts - 301 through 315 (of 842 total)
November 8, 2018 at 10:43 am
Ed Wagner - Tuesday, November 6, 2018 3:46 PMTerminator
Predator
November 7, 2018 at 7:29 am
November 6, 2018 at 12:40 pm
Thanks for the post Steve, really hits home today for me. Today would have been my dad's 74 birthday. He passed away in July of 2017 from leukemia. He wasn't...
November 6, 2018 at 6:59 am
I've repeatedly explained to my mother in law what I do, but she still tries to ask me questions about her iPad. I don't have an iPad myself, but she...
November 5, 2018 at 1:23 pm
Jeff Moden - Monday, November 5, 2018 11:03 AM"It Depends" 😀
indifference
November 5, 2018 at 1:08 pm
Ed Wagner - Wednesday, October 31, 2018 1:49 PMSeven Red Lines
Oceans 8
November 5, 2018 at 7:40 am
david.gugg - Tuesday, October 30, 2018 7:52 AMAnyone out there ever used calculus in their programming career?
Nope, not in my 27+ years...
October 30, 2018 at 8:38 am
ManicStar - Tuesday, October 9, 2018 12:42 PMPounding
Pound Cake
October 9, 2018 at 2:21 pm
If you are making changes how about changing the view of your 'Replies', so it has a 'Date of Last Change'.
I brought this up in this thread: https://www.sqlservercentral.com/Forums/1930136/Need-simpler-way-to-see-a-list-of-my-posts-and-possible-replies-to-them#bm1967227
October 8, 2018 at 9:02 am
ManicStar - Friday, October 5, 2018 8:52 AMCat
Nip
October 5, 2018 at 9:35 am
Changed what Steve posted:DECLARE @Today AS date = GETDATE();
DECLARE @FirstOfTheMonth AS date = DATEADD(DD, 1 -DATEPART(DD, @Today), @Today);
DECLARE @TodayMinus12Months AS date = DATEADD(month, -12, @FirstOfTheMonth);
October 4, 2018 at 10:41 am
Try this:declare @StartDate date = '01-01-2018',
@EndDate date = '09-30-2018'
;
SELECT C.No_ AS [No_],
C.Name, C.Spcode, C.Address, C.City, C.[PostCode], C.County, D.dcValue
INTO...
October 4, 2018 at 8:12 am
October 3, 2018 at 2:23 pm
Viewing 15 posts - 301 through 315 (of 842 total)