Hi all,

I'm a newbie to T-SQL. Please can you help me with the below query . Thanks in advance!

my desired o/p

------------------

my...

This is so wrong.  Your company is trying to have you fix the wrong problem.  The real problem is the source of the data and THAT's what actually needs to...

We probably need to see that script.

I also cringe a bit when I see that people wrote a...

Or this? (Pipe is being used to indicate a separate column for each date)

2021-01-01 | 2021-01-02 | 2021-01-03 ...

If you do a search for "sys.dm_os_performance_counters", you'll find a ton of some pretty good articles on what to look for.  The trouble is, the counters are just reporting symptoms. ...

So... wha'cha wanna do with a name like "Jill St. John" or "James van Allen" or a name with a hyphen in it???

Seems like there's a pretty good chance...

So... wha'cha wanna do with a name like "Jill St. John" or "James van Allen" or a name with a hyphen in it???

Seems like there's a pretty good chance that...

Looks a whole lot like good ol' fashioned HTML.  Thanks for the link, Tomaz.

Understood there, as well.  No worries.  It's not difficult for me to cobble some example tables.  I was just going "for the real stuff" just to be sure.

There are several issues here and the most important of them all is an absolute show stopper for us and almost everyone that has posted has mentioned it in one...

Documentation is your friend.  This is an example specifically covered in the following...

Thanks for your speedy replies contacted sys administrator numerous group policies had been applied.

Server now same as other SQL instances no issues running various batch files & agent jobs...

The CSVs were created from Excel. I just save as CSV. I am guessing they are tabbed (they do appear in a table format)

The tables do contain confidential information...

Ok.  Understood on the column names and the table creation.

Is the data in the files separated by commas or tabs?

Also, is there any chance of attaching one of the files...

That's kind of cool.  Thanks for the article.

Do you have a link to some formal documentation for what the syntax and possible functionality is for this "markdown" language and how...