Viewing 15 posts - 1,051 through 1,065 (of 4,087 total)
Can this be of any help?
SELECT MinDate.Account_Number
, MinDate.MinimumDate
, A.Account_Type
, B.Customer_Id
...
August 7, 2018 at 2:45 pm
You have too many fields in your GROUP BY. Specifically, you should not have B.Sales_Date. If that still doesn't help, follow the directions for posting sample data and expected results...
August 7, 2018 at 2:35 pm
August 7, 2018 at 11:35 am
It's been a long time since I worked with SSIS, but we actually used a table/view to do our configurations. The table had a field for server name and the...
August 7, 2018 at 9:14 am
Hi
Thanks for your reply. Please find the sample attached. I attached an excel spreadsheet.
The...
August 7, 2018 at 8:16 am
I don't know about SSIS, but SQL will automatically convert TRUE to 1 and FALSE to 0 when assigned to a bit field.
Drew
August 7, 2018 at 7:49 am
August 7, 2018 at 7:43 am
You can actually simplify this. There is no reason for the nested CASE expressions and you can greatly simplify the sign.
I'm assuming that CONFIG.PremiumSignShowData is both a BIT...
August 7, 2018 at 7:34 am
August 6, 2018 at 3:15 pm
August 6, 2018 at 3:07 pm
I got it to work. Here are some of the changes that I made.
August 6, 2018 at 2:59 pm
August 6, 2018 at 1:37 pm
August 6, 2018 at 1:18 pm
Putting the semicolon at the beginning of a CTE is my biggest pet...
August 6, 2018 at 1:11 pm
August 6, 2018 at 1:05 pm
Viewing 15 posts - 1,051 through 1,065 (of 4,087 total)