I found my code that used this function but it splits the single column into multiple rows by the delimiter vs into multiple columns but think I can use it...

I checked my db and that function is there and created 6 years ago but none of my existing code used it.  From what I can see, this one was...

It was the missing END.  It works perfectly now.  There is only one LogOn record per SessionId so a MIN or MAX will have the same results.

Yes and I do thank you.  The STRING_SPLIT pointed me in the right direction.

Kept googling and googling and found this and it works.  https://www.youtube.com/watch?v=htpoAyuWw5o

Yes they have leading and trailing spaces and it's literally in every single table of the database.  It's many of the key fields too.  I think I'll stick with Crystal...

Our SQL is hosted and still only on 2016 so have no control over the version.  I already have a separate DataSet created that is the source of the phases...

I figured it out but no option to delete post

I figured it out.  Instead of using Subreports, which I'm so used to, I added an image then added an action to it to open the report.  Works like a...

Fantastic!  The number of records that each @Incl filters out is minimal.

Sweet!  sp_who2 then kill works perfectly.

• This reply was modified 4 years, 10 months ago by  Luv SQL.

i'm running SSMS 18.4 so not sure if that 17.9 article applies.  Anyway, when I open it the processes is not paused it's just empty.  All of them are.  Eventually...

Yes it's very clear the backup system is flawed but unfortunately our IT is outsourced and that was all I was given and have access to.  I've requested a new...

Unfortunately now that it's in Emergency mode I cannot connect to any tables in order to update our live table's with a query.  Is there NOTHING I can do?

I tried...

I've been able to get the database in Emergency mode so at least I can run queries on it and export the data I need.