The query is basically "asking" which column to total, and then setting the query up to accomplish that. It's just a slightly more advanced version of using parameters.

It's saying...

need to write IIF condition; like if labor then populate VendorNo information and right side is inoviceamt information data below) we need to pull data

If Labor THEN what?

Sounds like you...

Could you post some data as a UNION query or a CREATE TABLE and then some INSERTs... (Not millions, just enough to get an idea of what you're dealing with.)...

I saw the first part and thought... oh, use STUFF...

and then I saw the odd requirement (show all permutations)

Here's the sample data part I did from the example... since he's...

Never thought I was qualified for it anyway. =)

After coming up with one answer, I looked around at all the other options, and that one is probably the worst. ...

I don't see any reason why you couldn't create a @FileName variable or similar and just build the string in pieces, and then use it in a loop to process...

It's a health care company, so they do a lot of data importing, I assume.

The client stated that the candidate must understand Identity in SQL. They need to know what...

"Believe it or not, SQL Saturdays are one of the best places to network."

Actually, there were a bunch of recruiter types there last week (#272). Someone actually e-mailed...

I was just wondering how you could get all the datasets filled in such a way that they would be accurate as of a point in time, instead of having...

I'm going to talk to Kevin Kline if I can track him down. (@KEKline on Twitter, I think.) He's a serious smarty (SQL Server MVP), so his advice should...

Just wondering - since I'm not absolutely new to SQL Server (I have a couple of those Microsoft pieces of paper) but lack paid experience in SQL Server, what would...

You might want to read Dwain Camps' article on Creating Dynamic Crosstabs... that might give you some ideas.

SQL Saturday? It's a bargain, so absolutely go! You may not understand it all, but go to beginner lectures (I went to the one in Nashville last week,...

Can you use SSRS, or are you doing this in a query only?

Just wondering, but can you force the queries to run in a single transaction, so they all execute and then the report is rendered? (Sorry to hijack the post...