Viewing 15 posts - 1 through 15 (of 16 total)
Thank you for all your assistance, I really appreciate it and have learned a lot!
One last question - This report is going to run every 2-3 days so I want...
July 22, 2021 at 4:08 pm
It also seems like my first row is actually showing the headers, can you help with a fix for that please. See screenshot.
July 22, 2021 at 1:42 pm
Here is the message:
Commands completed successfully.
Completion time: 2021-07-22T07:52:15.4415132-05:00
July 22, 2021 at 1:16 pm
I did get this query to run successfully, however, no email ever was received. I checked Database Mail Log and it didnt show any activity at the time I ran...
July 22, 2021 at 12:44 pm
Thank you so much for your help.
Is there a way to add the date to the end of the filename? For example, Filename072221.csv
July 22, 2021 at 11:52 am
It just has to be opened in Excel, so CSV file would work also. Thank you so much for your help!
July 21, 2021 at 8:32 pm
I also have older versions showing in my installed programs. Can I remove these older versions of SQL? Or will it affect my current SQL Server? Thanks!
December 24, 2020 at 1:51 pm
Yes, I fixed the Excel formatting and now it looks fine. Thank you for all your help, I appreciate it.
July 3, 2019 at 2:43 pm
Looking good. However, I need the Pay column to show zero instead of null, so it can total at the bottom.
July 3, 2019 at 2:15 pm
I figured out the syntax errors, now let me run it and see if it works. Thank you!!!
July 3, 2019 at 2:13 pm
I tried and get error
Msg 102, Level 15, State 1, Procedure wynne_incentive, Line 45 [Batch Start Line 7]
Incorrect syntax near ';'.
July 3, 2019 at 2:05 pm
USE [TMWSUITE]
GO
/****** Object: StoredProcedure [dbo].[wynne_incentive] Script Date: 7/2/2019 1:30:43 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[wynne_incentive] @datein1 varchar(10), @datein2 varchar(10)
as
with cte_drivers(id,nm,de,yr,py,st,se,ty,tr)
as
(select mpp_id, mpp_lastfirst,
(Case when mpp_hiredate > mpp_senioritydate
then mpp_hiredate
else mpp_senioritydate
End),
(Case...
July 3, 2019 at 1:49 pm
Thanks Thom, I appreciate the feedback. I will take a look at the documentation you referenced and let you know my results.
March 25, 2019 at 12:08 pm
Hi Drew,
Thank you for your response. Can you give me an example of the ON clause and also CROSS JOIN. Thanks!
September 13, 2018 at 8:01 am
Viewing 15 posts - 1 through 15 (of 16 total)