based on the tables above and their relations I have the following comments/questions

• Ticket

  • Serviceable needs to be removed as you moved it to table Service
  • Service Category - you...

there is no SQL code on your post - only something that looks like VBA.

so do go post on a VBA or Google Sheets forum where there are bound to...

and... why you using Excel on the server? It is unsupported and likely you are breaking the licensing terms for Office/Excel.

Common approach for these is to have a set of metadata tables that contains all the information related to tables/views in such a way that you can query those tables...

For each database do ( including msdb - will allow view jobs )

GRANT VIEW DEFINITION TO [<USERNAME>]

And

USE [msdb] GO ALTER ROLE [SQLAgentReaderRole] ADD MEMBER [<username>] GO USE [msdb] GO...

TO_CHAR(trunc(Sysdate,'MM')-1,'MMYYYY')) - this is returning the first day of the current month (trunc(sysdate, 'MM) minus 1 day (-1) in format MMYYYY

TO_CHAR(tab.x, 'MMYYYY') is returning the value of tab.x on format...

from what I can see on documentation you can't grant the view alone - in order to allow a user to view the definition you must also give the same...

You just re-stated exactly the first line of what I wrote in an earlier post. ...

even if it does Google does not advise it - look at https://cloud.google.com/compute/docs/instances/sql-server/best-practices

it kink of looks your data is not a real representation of what happens.

you can't have the same case (C1) going to 2 distinct master cases (m3 and M4) and...

invoke... "$($servervariablefromlist)"

that error looks like you are querying a Sybase database. is that correct?

and what driver are you using? vendor and version.

and... what are you doing with the returned value?

103 (dd/mm/yyyy)  is the wrong format for that input

101 (mm/dd/yyyy) would be the right one

and from your last post you are trying to convert from a varchar to a datetime...

if zero records is not a valid answer then kindly explain why the following code returns zero records and why, according to you, it SHOULD return something.

if...

invalid question - and adding rules afterwards to explain why your desired good answer is right is really not a good thing.

and if there are locking transactions then the query...