Instead of using LAG you can use OUTER APPLY. I've used both in this query so you can see the difference.

CREATE OR ALTER VIEW TestView AS
 ...

Well, if you call this fnTally with a start value of zero (0), you get two zeros (0). You can eliminate:

SELECT N = 0 WHERE @StartN = 0 UNION...

With a minor change to the function you could increase the functionality so that instead of specifying a bit for Zero or One for the starting value you could specify...

• This reply was modified 4 years, 1 months ago by Jonathan AC Roberts. Reason: correction

Yes, lots of code and it's not my style of writing code so I haven't done much with it.

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?