I stand to be corrected, but the pattern appears to be as follows

• P1 is the only PartNumber that has PartValue in (1,2,3,4), therefor has its own UniqueNumber
• P2...

I work on sql server 2019 i face issue i need to give unique number to every group of numbers without using string aggreagte or stuff

original table as below...

You could paste the results into Excel and colour the results with an Excel formula.

Can you just create a linked server in SSMS, then just do an "insert into select * from" command in SSMS?

If you cannot create a linked server then, if it...

Hi Community,

I have tried refactoring code to execute with CTE  as described on this site but I keep on getting errors:

The code that I'm trying to refactor is:

            
July 14, 2022 at 10:45 pm
            
#4063550

            
            
                                                
        

I'm not sure what you are trying to do but if you install this function: https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function

Then this code might do the job:

Declare @StartDate Datetime
Declare @EndDate Datetime
Select @StartDate...

You could try this script: https://www.sqlservercentral.com/scripts/get-file-sizes-of-database-files-and-free-space-on-disk

I'm not really sure what you want to do. Do you want to group rows by "Time"?

SELECT ss.StoreCode, 
       ss.ProductCode, 
...

I would just shrink the files. If your are on a SAN disk you might not even notice any performance degradation. If you do you might just need to rebuild...

Can you provide a sample of how you are calling the procedure and what is going into the parameters?

I think 5 is the out of the box default setting.

I've...

I take it you...

I've run it again after a reboot and closing the Chrome, the figures are more consistent but my first method is faster by a long way (on my desktop). For...

These are the results from my machine

***********************************************************************************************************************
===== Scott's Code) =====
DBCC execution...

ok, that's not what I thought you meant. I thought you meant flip all the bits.

This works for 0 and 1:

DECLARE @smallint smallint...