kapil_kk (3/18/2013)

---

;with cte as

((select min(VoucherNo) VoucherNo, TransactionID from GV_Voucher

group by TransactionID

--order by VoucherNo asc

)

union all

select max(VoucherNo)VoucherNo, TransactionID from GV_Voucher

group by TransactionID

--order by VoucherNo desc

)

select * from cte

Thsi will...

This should get you started:

-- Inline tally from Jeff Moden et al.

DECLARE

@LastBookNo INT = 23,

@LastPageNo INT = 80,

@BooksToInsert INT = 2,

@PagesPerBook INT = 10

;WITH E1(N) AS (

...

bhushan_juare (3/15/2013)

---

[font="Courier New"]Hi Chris,

I have done some modifications in my script.. and I am getting correct result set but their are some (im.MATNR As ITEM) entries who are not present...

The #temp table isn't strictly necessary but may improve performance:

;WITH MassagedData AS (

SELECT Company,

MIN_Number = MIN(Number),

MAX_Number = MAX(Number),

rn = ROW_NUMBER() OVER(PARTITION BY Company ORDER BY MIN(Number))

FROM (

SELECT Company,...

What version of SQL Server are you connected to?

L' Eomot Inversé (3/14/2013)

---

That would be alright here, but I'd hate that if I were in England in wintertime.

I've been to...

Looks like whatever is causing the inconsistency has been lost in the simplification process. Try this:

-- Query 3:

SELECT a.col1, a.col2, b.col3

FROM tab1 a

FULL OUTER JOIN (

SELECT

col1,

col2,

col3--,

--row_number() over(partition by...

mkarthikeyan.mohan (3/15/2013)

---

Dear friends,

i build the stored procedure was much more logic, each and every column having calculation.That was handled by function. each an every function also having loops.i was doing...

TheSQLGuru (3/14/2013)

---

Hmm, I wonder what happens if the codeid's repeat instead of being unique across all 3 code tables. Hopefully the way the aggregates are done will factor the...

I'd check that it's doing...

Better.

bhushan_juare (3/14/2013)

---

[font="Courier New"]Hi Chris,

Thanks for reply One thing i wanna ask you Do I need to add same logic for condition 2..?

Because what I am getting is one side results...

ALTER TABLE MyTable ADD NewColumn BIT

GO

UPDATE MyTable SET NewColumn = 0

GO

ALTER TABLE MyTable ADD CONSTRAINT NewColumnDefault DEFAULT 0 FOR NewColumn

Incidentally, your WHERE clause turns this LEFT JOIN SALES_DATA sd

ON so.VKBUR = sd.VKBUR into an INNER JOIN.

The same happens with table VBAP inner joined to SALES_DATA. If you...

Something like this?

SELECT --DISTINCT -- not needed, covered by GROUP BY

year(sd.FKDAT) As YEARWISE_DATA,

so.vkbur As MARKET,

so.bezei As NAME,

sd.kunrg As PARTY,

cm.NAME1 As PARTY_NAME,

im.MATNR As...