As has already been stated, importing such a file is, at best, entirely impractical until one of two things changes:

1.) The export process encloses every columns content in quote marks,

OR

2.)...

Turned out I just needed to recycle Visual Studio on my laptop.   That solved the funky problem.   Now I have to fight what seems like a silly problem.   I have...

Turns out I was able to find an embedded image that I could use from another .rdl file in the project, and while I had to copy and paste from...

I figured it out...   I had gotten very used to looking at VS 2019 and when I looked again at VS 2008, I found that variable from the "Template" namespace...

What, exactly, would you expect Visual Studio to display for a variable of type "Object" ?  Different objects could have any of a number of potentially useful properties, but how...

Okay folks... day 3 and I'm currently awaiting today's action to create a listener...  However....  There IS a listener in our production environment, and just to try and test things,...

Jeff,

Pretty sure you've nailed it...   I think we need a listener, and there isn't one.   I know for sure the server name of the primary, and it seems unlikely that...

Intriguing Jeff... but you'll need to go into slightly more detail....  I know for certain that the server I am referencing is the PRIMARY for that database.   It is where...

• This reply was modified 1 year, 7 months ago by sgmunson. Reason: Additional context based on Google search

Okay... new update.... take out the CTE entirely, and just try to test the concept, and suddenly I have a syntax error with "too many prefixes" for the object name. ...

As it turns out, my error is NOT from the DROP TABLE IF EXISTS statement.   It is the:

...
')
SELECT SD.*
' + CASE
WHEN @FileFrom = 'ONETIME' THEN 'INTO '...

The database is part of an AG group, but the server it is on is the publisher and is thus where we go when we need to make changes.   I'm...

Yep... this is an EXTREMELY POOR WAY TO GO ABOUT IT...   And for those folks not yet working with SQL Server 2022,  Ken McKelvey's suggested link to Jeff Moden's DelimitedSplit...

That's handy, Michael, but we're not ready as a company to embrace the use of PowerShell.   I'm going to create a new table that we can refresh via a SQL...

Indeed, the problem is primarily one of scheduling.   But now that you mention it, simply moving the stored procedure into a SQL Agent Job and having it TRUNCATE and then...

• This reply was modified 2 years, 8 months ago by sgmunson. Reason: grammar correction

@orbit,

As to the index, searching for the CHECKSUM value that is indexed will certainly work well, and maybe the primary question is how large the rest of the table is;...