This, maybe

Select Itemcode,Itemname,ItemGroup
    from tbl1
    where (itemgroup is null and @ItemGroup is null) or (itemgroup is not null and @ItemGroup is...

Still no question.

Hi

(Select Case (select count(*) from tbl1 T where T.num = T0.num ) when 0 then HCode=STUFF ( ( SELECT ', '+ CAST(A0.[aCode] AS VARCHAR(MAX)) FROM O A0 INNER JOIN...

DECLARE @x INT = 5;

SELECT Result = CASE
                   ...

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

Given the limited amount of information you have provided, that is not easy. You mentioned using a 'UNION ALL' condition, but there is...

This probably is not going to give you the results you want. Instead, you should include a STUFF() for each individual SELECT.

There are precisely zero temp tables contained in your code.

CREATE TABLE #T (SomeCol INT)

, for example, is how test tables are created.

If you want to use them in your code,...

The information we need to help, at a minimum:

1. The query itself
2. The Actual query plan (.sqlplan), added as a text attachment.

Once we have these, there may be requests for...

Why are you putting parentheses around some of your variable names? I'm not sure that they're needed.

Correct. It was trying to run the...

Try this command instead:

invoke-sqlcmd -ServerInstance $server -Database master -Username $sqlusername -Password $sqlpassword -Query $sql

What is the default database for the login which you are using? Is it master?

Can you give us the full command you are trying, sanitised if necessary?

• This reply was modified 3 years, 10 months ago by Phil Parkin.

Thanks, Jeff. Truly appreciate your help with this!

--snip

I am just curious as to what procedure you will be using. I was digging around a bit and I came across...

Can you provide DDL and sample data for dbo.ConvoHrs, rather than asking people to use guesswork?