Your syntax is wrong for SQL Server.  You can't use SELECT in a CREATE TABLE statement.  I recommend you review the documentation from Microsoft on CREATE TABLE syntax (https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver15) and...

• This reply was modified 3 years, 5 months ago by Mr. Brian Gale.

Without seeing your data or table structures, my best guess is one of the following:

1 - your data is unordered - that is you are not putting in an "ORDER...

The error message is telling you EXACTLY what is wrong - the path was not found.

Looking at your code, there are a few things that I am a little confused...

Personally, I think that sounds like a lot to work on, but I am hoping that you do get some interest in it.  One concern an end user may have...

Personally, I wouldn't put the GPX file on there.  I have never looked at those, but I have a feeling that it contains GPS data in there.  People could use...

I agree with TangoVictor on this one - I would be looking to have the business sanitize the data before allowing it to be handled by SSIS.  one user puts...

What I would strongly recommend to get good results on this forum is:

1 - post DDL in a consumable format such as:

CREATE TABLE sample (JSONData NVARCHAR(MAX))

2 -...

I agree with Homebrew01 here - I would do this in a table.  That way the logic is EASY to update in the event your fiscal year changes.  You MAY...

To add to what Jeff said - I got my DBA (Jr. DBA at the time) job with no degree or any certs.  I got some certs after getting the...

My approach was to get certified in the tool I was going to be supporting - Microsoft SQL Server.  I started my training at Ucertify which I liked as it...

I am 99% sure that that is a limitation of HTML.  Can you imagine the headache if you clicked on a single link and 100 web pages popped open you? ...

My opinion - this should be solved at the presentation layer, but you also have some data issues.  First, I'd fix the data issues - your RCLTIM column is a...

If the code is running longer due to waits, I would review which wait is causing the slowest performance of the query and go from there.  If it is something...

• This reply was modified 3 years, 6 months ago by Mr. Brian Gale.

I agree with Grant here - what are you trying to debug with the debugger?

In general, my "debugging" of SQL scripts is to take the UPDATE, INSERT, or DELETE statements...

I was just reviewing the link you provided and it basically tells you what to do, just not in plain terms.  Basically, determine what is causing the latch, then determine...