Viewing 15 posts - 166 through 180 (of 842 total)
You could set up something in a data flow in SSIS to redirect the 'bad' rows. Myself I like to load the CSV data to a 'work' table where all...
August 23, 2019 at 4:25 pm
why would anyone need to create a synonym over a temp table?
Interesting question, thanks Steve
That's what I was thinking. Why would you?
August 23, 2019 at 1:32 pm
Since I'm using SSIS to map the data from the flat file to my staging table I prefer to get all the data in the staging table, then...
August 19, 2019 at 4:40 pm
IMHO, you are on the right path. I'm currently doing exactly what you described. Importing flat, delimited files to a 'staging' table where all fields are defined as...
August 14, 2019 at 6:20 pm
IMHO, you are on the right path. I'm currently doing exactly what you described. Importing flat, delimited files to a 'staging' table where all fields are defined as VARCHAR(500), some...
August 9, 2019 at 4:53 pm
I haven't used the MERGE statement since I got burned many years ago doing a
WHEN NOT MATCHED BY SOURCE THEN DELETE
As it turns out, you...
August 5, 2019 at 8:32 pm
To me this is what the code is doing, modified just to make it easier to understand:
/*WITH TRANSDETAIL_CTE (Property , Account , Book , FinMonth ,...
August 2, 2019 at 7:31 pm
Don't really need to know how or what built the #TRANSDETAIL_TEMP table.
The CTE of TRANSDETAIL_CTE is some what like a temp table of the results from that SQL.
Then you are...
August 2, 2019 at 7:17 pm
We (I) use synonyms a lot. I tend to like to write SQL to do the data manipulations or whatever the task is. Some of my co workers tend to...
August 2, 2019 at 7:01 pm
Your code will be inserting, updating and deleting the results from the CTE, but it then doesn't do anything with the results of the CTE, not even selecting from it. ...
August 2, 2019 at 6:39 pm
I'm surprised more people didn't choose 1,2,3. The update will fail, leaving the 2nd select giving the original values.
Exactly my thought. I can't be expected to interpret the intent...
August 2, 2019 at 2:06 pm
The way you have it written you don't need the "TYPE <> 35 AND ACCT1 <> 2". The check where the Type IN (30, 31) will insure you don't get...
July 31, 2019 at 1:38 pm
In the later versions of SSMS, you can actually select a thin vertical line of "no characters". Then when you type something, it will be typed on all...
July 30, 2019 at 1:44 pm
"Correct. It doesn't matter if it's tabs or spaces. And, if you consider the column names example I gave, now you also understand one of the reasons why I...
July 30, 2019 at 1:41 pm
but I still prefer the 'AS' method instead of '='. 😀
The reason I prefer the "=" method is simply because of my habit to do vertical...
July 25, 2019 at 1:56 pm
Viewing 15 posts - 166 through 180 (of 842 total)