Hi all,

Apologies for the delayed response. I have received feedback and it was confirmed that some of the example data I was provided had an anomaly. However, this was not...

Thanks @jonathan-2 AC Roberts & @steve-2 Collins for the suggestions.

I will just need to do some testing. I may have found a possible anomaly with the...

Hi @jeff Moden,

Many thanks for your reply. Also thanks for sharing your tally function. This has helped me solve many problems in the past.

My user base consists of...

• This reply was modified 6 months, 3 weeks ago by  ibbo14.
• This reply was modified 6 months, 3 weeks ago by  ibbo14.

@drew.allen

Thanks for your response! The depth can also start at other values. Not always necessarily 0.

Hi

@jonathan-2 AC Roberts,

Thanks for your help. I tried it, but this one is suppressing the rows. I am expecting530 and 242 is being returned.

I have tried the other...

• This reply was modified 6 months, 3 weeks ago by  ibbo14.
• This reply was modified 6 months, 3 weeks ago by  ibbo14.
• This reply was modified 6 months, 3 weeks ago by  ibbo14.
• This reply was modified 6 months, 3 weeks ago by  ibbo14.
• This reply was modified 6 months, 3 weeks ago by  ibbo14.
• This reply was modified 6 months, 3 weeks ago by  ibbo14.
• This reply was modified 6 months, 3 weeks ago by  ibbo14.

OK, SSIS is the way to go then. I'll give that a go. Thanks pietlinden!

Thanks for your reply.

The users will not have access and this is something I would like to Automate without having to open access and run it daily as a job.

Thanks for the response Rob.

I agree, SQL should not be able to access the web, but in this scenario the web service and the SQL server are contained within the...

Thanks Steve! That is exactly what I am after. I just could not remember how to tackle this, but the tally approach worked brilliantly!

Very much appreciated sir!

Sorry, could not attach SQL file. Attached it as a TXT

That worked like a charm! You have saved me hours of going down the rabbit hole.  I would have never thought of tackling this problem this way but it is...

Hi,

Apologies for the late reply, I was on leave.

Basically each file has a different header. At this point I cannot import straight into the destination table as I need to...

Nice one! Thanks for that buddy!

Thanks for all the inputs, they pointed me into the right direction:

I've managed to work it out using this CTE Expression:

;WITH cte

AS (

SELECT distinct *

...

Hi Jeff,

Thanks for the reply, as far as I can tell from the data it seems to be 3 so far.

Regards,

Ibo