The structure of your...

Vincy-856784 (6/20/2013)

---

Thank you very much for your quick response!

Hmm. So, the only option I have is to get rid of the function since I was using LOWER(FRUIT) = 'apple'....

inevercheckthis2002 (6/20/2013)

---

Point of clarification -- sometimes data will be entered in TableA and not in TableB or TableC....

Can you also post the expected results based on your sample data along with a brief description of the logic?

It will help us to test the solutions before we post...

Do you find this simpler?

SELECTid,

MAX( CASE WHEN characteristic = 'color' THEN value ELSE NULL END ) AS color,

MAX( CASE WHEN characteristic = 'age' THEN value ELSE NULL END ) AS...

I agree with the poster above

Going by the description that you have provided even I don't think there is any need for a CURSOR

Please post the table definitions, sample data...

WayneS (6/19/2013)

---

Kingston Dhasian (6/19/2013)

---

Sai Viswanath (6/19/2013)

---

Hi All,

One more doubt on partitioning.

- Do we need to have a primary key in the table which needs to be partitioned?

- Can I...

A CROSS TAB will give you the desired results

SELECTControlNo, MODELKEY,

SUM( CASE WHEN SEQ = 1 THEN InspInterval ELSE 0 END ) AS int0,

SUM( CASE WHEN SEQ = 2 THEN InspInterval...

marin-231997 (6/19/2013)

---

Hello Dixie Flatline and Kingston,

many thanks for your quick responses, much appreciated.

Kingston's solution is exactly what I am looking for - I did not know how to group by...

Krishna1 (6/19/2013)

---

Thanks for quick reply. How do I test this. I need to show the diff that log will not get trucated even if we take full back every day....

Removed as it was a duplicate post

Something like this

DECLARE@startdate DATE

DECLARE@enddate DATE

SET@startdate = '20130701'

SET@enddate = '20130703'

SELECTT.ITEM, DATEADD(DAY, D.number, @startdate) AS Dt, SUM(T.QTY) AS QTY

FROM@t AS T

CROSS APPLY(

SELECT*

FROMmaster.dbo.spt_values AS sv -- You can use a Tally table instead...

SELECT * FROM customer WHERE customer.customerid in (SELECT customer.customerid FROM salesorder)

In the above query, the term customer.customerid references the customer table outside as the customer table is still in scope

For...

Are you sure? Check this

CREATE TABLE customer

(

customerid INT

)

CREATE TABLE salesorder

(

customerid INT

)

INSERTcustomer

SELECT1 UNION ALL

SELECT2

INSERTsalesorder

SELECT1

SELECT...

Are you in the middle of some exam or is your exam over?

This does not seem to be some real time scenario that you are facing in your assignment.