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 4 years, 1 months ago by frederico_fonseca.
• This reply was modified 4 years, 1 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 4 years, 1 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...

Steve have a look at this profile https://www.sqlservercentral.com/forums/user/papaku

I'm pretty sure I've reported them more than once - and there are similar profiles to this one - reply to one of...

you can only have exponentials if there datatype is a string...

how you see them in SSMS is not how the data is stored - that is an issue with how SSMS displays real/floats.

to see the real content you will need...

if insert is done in one go ...

adding page compression is likely to reduce the size of that table to around 90 GB - overall result is that querying the table will require less IO and less...

can you put the full DDL for the table - including indexes and data_compression clause. (you may need to change your ssms settings for generationg scripts for all these to...

forgot to add that option to the list.

to sort it out add

@SortInTempdb = 'Y'

to that list of options

with regards to that long run - get a copy of sp_whoisactive and...

google - the information you need is very abundance and clear - and if you don't have access to install those modules speak with your admins to get it installed.

or  the one below - but output will never be the one you desire

Select *
from (select distinct VID
         ...