yuvipoy (12/26/2012)

---

hi

i am having two tables one table is having header details and another is having data

Table_idCol_1Col_2 Col_3Col_4 Col_5Col_6

1Mytab_1_1NULL Mytab_1_2NULL Mytab_1_3 ...

Is this what you are looking for?

--Creating Tables

Create Table Store_Audit_Type

(

Audit_Type_Id Int,

Audit_Type_Description NVarchar(30)

)

Create Table Store_Audit_Details

(

StoreId Int,

Audit_Type_Id Int,

CreatedDate Date

)

--Inserting Sample Data...

Bhuvnesh (12/26/2012)

---

vinu512 (12/24/2012)

---

Lets drink then :

Select Char(34) + Char(67) + Char(72) + Char(69) + Char(69) + Char(82) + Char(83)+ ' ' + Char(68) + Char(87) + Char(65) + Char(73) +...

Sean Lange (12/21/2012)

---

Excellent job posting ddl, sample date and desired output!!! I wish everybody would post their questions like this.

Here is one way to do this.

select * from #temp

where cCurrentGradeCode...

No probs Hemal....it was my bad.

I'm sorry Hemal, there is a slight error in my query. If there is data for more than one year then the data would be grouped only according to month...

You're Welcome!! 🙂

Anytime Lokesh. It was just a matter of Grouping the data before joining.

This would do what you are looking for:

Select p.Month, SUM(p.cramount) As Credit, SUM(q.dramount) As Debit From

(

Select b.voucherno, DATENAME(MM, a.dt) As Month, SUM(b.cramount) As cramount From voucher As a...

There are 3 tables which are: 1. a claims table by client number that has the duplicate data wtihin some of the rows. 2. a price table and 3. an...

Happy Holidays to you too Steve..........I guess the others have already started.....anyways wishing everyone a Merry Christmas and a Happpy New Year!!!!!! 🙂

dwain.c (12/24/2012)

---

vinu512 (12/24/2012)

---

dwain.c (12/24/2012)

---

vinu512 (12/20/2012)

---

dwain.c (12/20/2012)

---

Looked like...

dwain.c (12/24/2012)

---

vinu512 (12/20/2012)

---

dwain.c (12/20/2012)

---

Looked like a single...

Lidou123 (12/20/2012)

---

Hi Vinu,

thank U for your answer !!!

I tested the script but I have an error !!! it is in french .

Msg 116, Niveau 16, État 1, Ligne 8

Une seule expression peut être spécifiée...

Yes it is always good to learn something new Melanie.

And what is...

dwain.c (12/20/2012)

---

Looked like a single quote when...