String Concat missing, ur trying to concat a string and an integer

DECLARE @frdate date = '01-01-2021'DECLARE 
@ytdfrDate date
if Month(@frDate) < 4begin
SET @ytdfrDate = '01/04/' + cast(dateadd(y,-1,@frdate) as...

Im curious how to solve this properly, the first step might be checking for gaps with the LAG function, but all after that i can think off on the fly...

For future posts, please provide a simple temp table code example like mine, saves the others doing the same thing every time

I left out some columns which are not relevant...

I think Google has some type of API that does address correcting.

I'd look for that or some other known app to do this.  What you're trying to do is...

Every column thats used in select but not  an aggregation (avg/sum/...) needs to be in the group by after the from:

group by [candidateref],                 
   ...

Depends on what ur looking for, are you looking for a count or a distinct count (counting each ref only once, ignoring duplicates)

Maybe something like this case when helps

            
August 10, 2021 at 11:18 am
            
#3918404

            
            
                                                
        

Does it have to be a query using variables etc?

In theory you can get the first of each month and then do a group by with your distinct count of...

For future posts, please post some example code:

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Intresting

I always feel like im not using so much of the available stuff that SQL Server offers.

Most of the stuff i discover is from reading forum replies here.

Maybe someone else understood what you want, i myself am totally lost at what ur problem is or even what ur trying to achieve.

Always provide sample code, because text descriptions...

This should do the trick:

Identify the columns you want to group by --> ID_Order, ID_Product from either table

Identify the columns you want to aggregate --> IN.Amount, Out.Amount

Identify the columns you...

Something like this?

Creating the 2 Tables

select CDMLOCID = '201', CDMPOLL = cast('2021-06-20 00:00:00.000' as datetime2), JOBCODE = '10', DATETIMEIN = cast('2021-06-20 10:32:00.000' as datetime2), DATETIMEOUT = cast('2021-06-20...

What is the source data for this? Where do these variables come from? What will the 'dynamic string' be used for, once it has...

I am experimenting...

That does not look feasible to me.

It would be helpful if you could explain the background and reasons for trying to do this – there may be some...

• This reply was modified 3 years, 8 months ago by  ktflash.