Yes, that would be a good enhancement to...

If you right click the table in SSMS you can "Script Table as..." to generate a CREATE TABLE script.

Then if you right click the table you can generate an INSERT...

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

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