Des,

I ran the script, still getting some added stuff appearing in the ByWho column:

SELF SERVICE Attended on 15/02/2018 09:43:48 (SELF SERVICE)

X1234567 Paid on 20 Feb 2018 12:04 by Y1234567

X1234567 Amended...

Hello everyone,

Thanks for your replies, again I really appreciate your input.

Des, you were spot on, when I looked at the Live Data for that field, i was horrified to find...

Hi Des,

When running the SQL against the live data source, just to test it, i'm getting this error:

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or...

• This reply was modified 4 years, 3 months ago by  rkelly58.

I got my first bit of code working myself:

CASE When AttendedCol = 1 THEN 'Attended' ELSE 'Not attended' END AS OMGThisWorked

But can't quite add the result to another column as...

• This reply was modified 4 years, 3 months ago by  rkelly58.
• This reply was modified 4 years, 3 months ago by  rkelly58.
• This reply was modified 4 years, 3 months ago by  rkelly58.
• This reply was modified 4 years, 3 months ago by  rkelly58.

thanks Des,

asked third party aboyut the indexed views, they said absolutely not, will void contract, lol

Can't add to my own table, as i want to use the source, SQL to...

• This reply was modified 4 years, 3 months ago by  rkelly58.

Hi Des,

Unfortunately i am unable to add any new columnsto the table, as it is a third party DB and we only have read permissions to the source data.

I added...

• This reply was modified 4 years, 3 months ago by  rkelly58.
• This reply was modified 4 years, 3 months ago by  rkelly58.

Thank You Des,

That works well. Could i now use this hidden table with the results to then populate another table using SSIS? Would there be any issues with it being...

Des,

That is spot on, worked wonderfully, so thanks.

One last thing, can i do a WHERE clause on the "BookingDate" field to only show bookings for the last two hours?

I tried...

• This reply was modified 4 years, 3 months ago by  rkelly58.

Hi Des,

Thanks for that. How do i connect that code to use my column from a table, rather than the example test you used? Sorry if its obvious

Hi all,

Thank you everyone for your input, it works perfectly.

Your speed and responses have been fantastic.

I also have a question on Splitting values, but i will post that in a...

Hi Jeff,

Here is the result of your code:

Date                                             ...

Hi Thom,

Feel daft asking, but instead of the values you manually inserted here:

FROM (VALUES(CONVERT(datetime,'2020-11-20T00:00:00.000'), 900),

(CONVERT(datetime,'2020-11-21T00:00:00.000'), 1700))V(D,T))

How do i get it to point at my actual table and get the values...

Hi Phil,

Any idea how i change your script to use my actual values in my table columns? - Sorry my sql is fairly poor

Hi Thom,

thanks for your swift reply.

I cannot change the source data, as it's from a fixed source and comes through as is with Time column as a Smallint.

Checking the times,...

Hey Auto, thank you very much for that script, works great.

All the best