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 4 years 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?

As TangoVictor mentions, there are other possibilities.

One is to keep the filename exactly as it is and instead modify your 'subsequent processing' tasks to use a variable file name. This...

In Excel, you see the incorrect...

SELECT ItemCode from T1 UNION SELECT ItemCode from T2

Thank you very much! If you have trouble getting this...