David Burrows (4/25/2014)

---

SELECT

'Type'[Type]

,SUM(CASE WHEN code='09' THEN Amt/100 ELSE 0 END) AS [Col1]

,SUM(CASE WHEN code='10' THEN Amt/100 ELSE 0 END) AS [Col2]

,SUM(CASE WHEN code='11' THEN Amt/100 ELSE...

Stuart Davies (4/25/2014)

---

Thanks for the update.

Irrespective of which solution you use, test it on your system. All of the solutions work against the 10 or so rows provided, but what's...

Hi Thava,

Thanks for sharing your thoughts on this query. I will try this one.

pmadhavapeddi22 (4/25/2014)

---

My solution as follows.

SELECT 'Type' Type

, col1 = [09]

, col2 = [10]

...

Hi Stuart,

Thanks for your solution. I will try and study this one.

Hello Stuart,

Thanks for you reply.

I apologize for posting a query that does not follow the standards.

Anyway, here it is again.

I have this example table

CREATE TABLE TEST(

Code nvarchar (2),

Amt numeric(18,...

select

sum(case when loan.amount < 15000 then 1 else 0 end) as criteria1_count,

sum(case when loan.amount < 15000 then loan.amount else 0 end) as criteria1_amount,

...

Bob Hovious (5/13/2009)

---

Piece of cake.

select

sum(case when amount < 15000 then 1 else 0 end) as criteria1_count,

sum(case when amount 15000 and terms ...

Thanks for the info Bob. I will try to search it here in the forum.

Bob Hovious (5/13/2009)

---

Your options include:

1. Cut-and-Paste from Sql Server Management Studio (SSMS)

2. Using the "RESULTS to FILE" option in SSMS

3. Using Sql Server Integration Services

4. ...

Great! Thanks Bob...

Now, how am I going to export the result to an excel file? 🙂

Thanks for your reply.

I want to total the amount as well as count the number of records that falls to the criteria.

Jack Corbett (2/6/2009)

---

Since I don't really know what you need to do and why I can't really make any suggestions. If you have SQL Server other than express edition...

Im a newbie to T-SQL and a little programming knowledge. What can you suggest? Do you have a sample script just to give me an idea on how to start...

Actually Im not. Maybe my...