Viewing 15 posts - 7,516 through 7,530 (of 59,072 total)
If you don't understand these steps, I'd suggest finding a tutorial on SSIS that includes setting variables, ForEach and Connection Managers.
That's why I'm asking people to write a definitive...
March 17, 2020 at 2:37 pm
I would open the CSV file in Excel and search-and-replace the apostrophe with nothing, then save the revised file as a CSV file that now contains no apostrophes.
Apostrophes generally...
March 17, 2020 at 12:23 am
p.s. This is also why I default EndTime columns to '9999', which is the same as 9999-01-01. It means that I don't have to have an OR in...
March 16, 2020 at 9:13 pm
Jeff, I think your bracket should be after 'AND', not before it.
Thanks for the catch, Phil. Corrected it.
March 16, 2020 at 9:10 pm
p.s. This is also why I default EndTime columns to '9999', which is the same as 9999-01-01. It means that I don't have to have an OR in my code.
March 16, 2020 at 8:23 pm
Changes in RED. Also, Do add an index but it should NOT be filtered in this case. Don't miss the "equals" sign I added and, yes, the parentheses are necessary.
select...
March 16, 2020 at 8:20 pm
I don't have much time today but do a search for PowerShell and WMI for disk space.
March 16, 2020 at 7:57 pm
Dynamically create and populate staging tables from CSV files. Program can't load records that have the apostrophe character . Do you have any solution for that?
Yes... get a better...
March 16, 2020 at 7:36 pm
While I agree that a good logical design is essential and required before a physical design, I've found that the wrong people are frequently the wrong people to do so...
March 16, 2020 at 7:15 pm
Sorry, Steve... there is no correct answer here.
March 16, 2020 at 1:46 am
Itzik Ben-Gan used 5 million rows (your "Source4") in his performance testing. What is the performance of your proposed Geometry method?
March 16, 2020 at 1:36 am
You cannot use Table Valued Functions in computed columns in a table, though.
EDIT: Sorry... I've obviously confused this with some other post I was working on. The OP never mentioned...
March 16, 2020 at 1:17 am
I have a txt file that has about 5 columns when i import it. 1 of the column imports the data incorrectly and puts 15 columns into 1. It...
March 15, 2020 at 11:23 pm
and what do you recommend to do? I was looking into using a cross apply, but I think it will be the same
The query isn't appropriate for a computed...
March 15, 2020 at 11:13 pm
Viewing 15 posts - 7,516 through 7,530 (of 59,072 total)