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

Hi Phil

In this example i have one select statement . I want to stuff on a condition.

Suppose if Field1 has value 'Y' then above select statement should be used

else another...