google has lots of examples - so which ones did you try and what was the result.

its not like YOU trying it will cause any issues - and you will...

you are aware that this has been answered rather often and that what you need can be found with a simple google search - not to speak on the old...

Remember, too, that the logical data model should be easily understood and use by business people.  In fact, if possible, keep all developers out of the first...

replacement for format to return just yyyy-mm-dd (or yyyy-mm) is easy - convert(char(10), datefield, 121) - change the char(10) to char(7) to return just yyyy-mm - but as mentioned...

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)"