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...

and while we at it - always specify the size of your varchars

CONVERT(VARCHAR, MONTH(DateOfServiceFrom))

the replacement of null's with zeros should be done by the presentation layer.

try

select [type]
     , Group1Value
     , Grup2Value
 ...

• This reply was modified 3 years, 5 months ago by frederico_fonseca.
• This reply was modified 3 years, 5 months ago by frederico_fonseca.

this is not a postgreSQL site - you better off posting elsewhere (or read documentation).

you may or not get a reply here.

process is as follows

1. create new table
2. create clustered index (if it is a PK the pk should have a new name associated with the new table)
3. insert data onto...

• This reply was modified 3 years, 5 months ago by frederico_fonseca.

In response to both frederico_fonseca and ratbak

I am using global temp tables because I need to persist the data across SPIDs.  The table in question is built from some...

you can't have 2 processes running concurrently that try to drop/create the same global temp table - you get the conflict you have.

either change it so that the 2 processes...