Error - Windowed functions cannot be used in the context of another windowed function or aggregate.

SELECT ROW_NUMBER() OVER (PARTITION BY Account ORDER BY A."Account") AS "RowNo", A."Account" AS "Account", (A."Debit") AS...

Hi

In Sql Query or using Stored Procedure

Thanks

Hi Jeff

How the below code works

Sampl11=SUM(IIF(Sampl11='Y',1,0))

Thanks

Hi Jeff

Below is the data

CREATE TABLE Persons (LastName varchar(255),FirstName varchar(255),Sampl11 varchar(255),Sample2 varchar(255)); Insert Into Persons values('1','A','Y','N')Insert Into Persons values('1','A','Y','Y')Insert Into Persons values('1','A','N','Y')Insert Into Persons values('1','A','Y','Y')

Thanks

hi

I want same group by condition which is in outer. What is the other to solve this issue

Thanks

Hi

Closed . Field was wrong

Thanks

Hi

I have asked the question Inner select count is not returning any Data

Thanks

Hi Jeff

Since i have not used T0.U_Date that's why i think it is giving error but it should not work like this

How i can resolve it

Thanks

Hi Jeff

When i print dynamic sql it shows U_Date in where clause whereas i have given T0.U_Date. i have made bold where it gives error

SELECT

T1.U_VendCode as "Vendor Code",T1.U_CabNo,T1.U_VendName as "Vendor...

Hi Brian  Below is the correct codeWhen i print below Dynamic Sql it shows below statement in PrintALTER PROCEDURE [dbo].[Temp]@frDate date,@toDate date,@VCode nvarchar(15) = null,@VName nvarchar(100) =...

Hi

When i print above sql it shows below issues

In where Clasue i have given T0,U_Date but it is showing U_Date

Secondly it is giving error Must declare scalar variable @frDate

SELECT

T1.U_VendCode as...

Hi

WHen i write like this it says Incorrect syntax near 2021

Set @sql = 'Select * from tbl1 '

SET @Where = @Where + ' T0.U_DATE BETWEEN '2021-03-01' and '2021-03-31'...

Hi Steve

Can't we use with where clause only

Thanks

Hi

Error is coming  Invalid column HCode

Thanks

Hi Phil

if field1 = 'Y' then

Code=STUFF

(

(

SELECT ', '+ CAST(A0.[SCode] AS VARCHAR(MAX))

FROM tbl1 A0

INNER JOIN tbl2 A1 ON A0.[Id] = A1.[Id]

WHERE A1.docentry = A0.DocEntry

FOR XMl PATH('')

),1,1,''

)

else

Code=STUFF

(

(

SELECT ', '+ CAST(A0.[ACode] AS VARCHAR(MAX))

FROM...