that's how you implement case statement

CREATE TABLE #Fields

(

MODEL_SIZE INT,

...

bhushan_juare (2/4/2013)

---

[font="Courier New"]Hi All,

I Have table where it includes fields model_size, model_type, actual_qty, process_qty, order_type. Now I want to display all fields + model_size who has order_type = 'Some X'...

+1

thanks for the question Tom...

greg.senne (2/4/2013)

---

In my stored procedures that change data, I include data change logging. It logs to a table the Table name, the PK value of the table, the field name,...

Lokesh Vij (2/4/2013)

---

This is what I have come up with based on your requirement. Not sure for what you need a group by when total amount in there in Transaction...

pawan_rb (2/3/2013)

---

Thanks. Can you please also show me thae way to compose the sql? I was also thinking in the same line like in er joining and grouping but couldnt...

pawan_rb (2/3/2013)

---

I have two tables. One has records for transactions, another has records for purchased products. Transaction table has TransactionID, TotalAmount, TransactionDate. The purchasedProducts table has ProductID and TransactionID. Each...

please provide ddl(table definitions ) and sample data ...

easy one to start the day..

Nice question ..

Dineshbabu (1/31/2013)

---

Actually I'm unable to understand the comments and answers properly. Problem is with the word "CLOBBER".

But I'm aware of UPDATE behaviour and I know there won't be...

reminder of the basics ..

thanks for the Question

+1

Thanks for the question !!!

Don. (1/29/2013)

---

Hi Guys,

I was working on a script that would show all records in Table A that didnt have corresponding records in Table B.

I thought it would be simple enough...

Exactly Jason ; That ought to...

Lokesh Vij (1/29/2013)

---

Using merge (as pointed out by demonfox) you can easily user INSERTED.* and DELETED.* (as mentionded by Dwain) after MERGE in order to capture, columns and values which...