Hi,

I'm afraid i am a little dense this morning.

What does this mean? I don't see any option of adding code tags.

What you do is wrap your code in [...

Thank you for this helpful article.

One further issue i have is i don't know how to actually post in SQL code.

I see people have it added and it seems to...

Hi,

Thank you all. I am a little overwhelmed, in a very nice way, with all the help and new SQL to pick apart.

You are an awesome crowd.

😀

Q

Thank you. I will see if i can place the new code in the right place and then run.

Q

Thank you so much for your time.

Awesome.

It works. Now have to get my head round it what it actually all does.

Thank you!

Thank you.

What is this line you are using:

dbo.DelimitedSplit8K?

Thank you for the replies.

I will try to adapt what has been posted to suit our sandpit environment where i have discovered that some functions are not available (LAG...

Hi,

I cannot guarantee that. In the template submitted for the last 7 months, the only changes i have seen to this text field have been:

1. number of spaces (white space...

Hi,

The output would be a row that would populate a table with headers Date,Admissions,Discharges:

Date Admissions ...

Hi,

Thank you for the replies.

I have managed to write the script.

I will try and be more specific and give better examples in future.

I have had problems with links...

Hi,

I don't understand this bit:

select

'oldf9' = f9

I have the following:

Declare @Wed varchar(MAX)

Set @Wed =

(Select F10 from #TempBHRNELFT where F10 like '%Wed%')

Q

Hi,

Please find link to image of the input data, transformations and output.

I am taking a raw data input extracted via SQL statement in SSIS package and is loaded into a...