Comments by Trogers96

Trogers96 15-Apr-19 14:26pm View

I meant that only column C is in a CSV type format. I improved my question to hopefully add more clarification.

Trogers96 5-Apr-19 8:15am View

Worked perfectly by putting the FROM below the SET statement. Marking at solution.

Trogers96 27-Mar-19 12:13pm View

It's a one time thing

Trogers96 15-Mar-19 13:21pm View

I am marking this as the solution. One small problem I am having is that it is making empty rows at the end of the emails for reports because in my data I have a , after the last email as well. Anyway to get around this for efficiency purposes? Thank you!

Trogers96 13-Mar-19 15:35pm View

Report Title | Emails
Report One | Emailone@email.com,Emailtwo@email.com
Report Two | Emailone@email.com,Emailthree@email.com,emailfour@email.com
Report Three | Emailfive@email.com,Emailone@email.com,emailsix@email.com
Report Four | Emailseven@email.com

Will this work?

Trogers96 12-Mar-19 7:57am View

I realized I made this post before I drank coffee so bare with me LOL but In my table I have
[day_full_name] varchar(9), -- Contains name of the day, Sunday, Monday
[day_of_week] char(1),-- First Day Sunday=1 and Saturday=7
[day_business_day_flag] bit Null -- 1=BusinessDay, 0=NonBusinessDay
[day_bank_holiday_flag] bit, -- 1=Holiday, 0=Not Holiday
[day_weekday_flag] bit, -- 1=Weekday, 0=Weekend
The function I have to calculate if the day is a business day or not it must be 0 for day_bank_holiday_flag and 1 for day_weekday_flag.

/*Business Day Indicator*/
UPDATE [EDW_MDM].[dbo].[FCFCU_CALENDAR_DIM]
SET day_business_day_flag = '1'
WHERE day_bank_holiday_flag = 0 AND day_weekday_flag = 1
UPDATE [EDW_MDM].[dbo].[FCFCU_CALENDAR_DIM]
SET day_business_day_flag = CASE WHEN day_business_day_flag is not null THEN 1 WHEN day_business_day_flag IS NULL THEN 0 END

Comments by Trogers96 (Top 6 by date)