rs80 (4/16/2013)

---

I have two oledbsources. One oledbsource has the distinct list of product ids (DataSet A) and another oledbsource has all of the order information with product id (DataSet B)....

I make that 32x quicker .....pretty impressive...

Hi...at the moment I am not at all clear what the "data" is ...it lives on SQL...but how did it get there and what is it being used for?

Is this...

glad to hear you are making some progress.

kind regards

maddhi.srikanthreddy (4/15/2013)

---

My requirement is,we have a drop down in our application with YTD,QTD,MTD

YTD--Year To Till Date.

QTD--Quarterly To Till Date.

MTD--Monthly To Till Date.

Please suggest me a query for retrieving values for...

maybe be useful

SELECT Datename (WEEKDAY, GETDATE())

http://ola.hallengren.com/

for the benefit of others who may in the future read your post...would you care to share your solution.

many thanks

interesting......

still stand by my first post ref table indexes....

was intrigued with this....so have built a test harness that I hope goes someway to replicating OP real world environment...please feel free...

Maybe something along these lines will help

;WITH cte AS

(

SELECT itemid ,

location ,

ROW_NUMBER()OVER( PARTITION BY...

I would start with looking at what indexes exist on tables

[CRALTNUMBERS]

[MATCHNAME]

[BOM]

[CRALTTITLES]

[font="Courier New"]

TableColumnOperationIndexActual RowsEst Rowsdiff

[BOM]BOMIDIndex Spool (Eager Spool)311,69790,394,96090,083,263

[CRALTNUMBERS]CREATIONIDIndex Spool (Eager Spool)147,98940,412,55840,264,569

[MATCHNAME]CREATIONIDIndex Spool (Eager Spool)811,51639,993,03639,181,520

[BOM]ITEMIDIndex Spool (Eager Spool)185,47019,798,58519,613,115

[CRALTTITLES]CREATIONIDIndex Spool (Eager Spool)155,4971,639,8011,484,304

[/font]

there appears to be inconsistency in the way you store "item" across the various tables.

Not sure if this down to your real tables or just the way you have...

Hi

have been at work ...so sorry for delay

I have had to go back thro your various posts in an attempt to get all the details of your tables...the script below...

just to clarify....you say "voucherPRETSRET doesnt contain any data but needs to be checked"...but there is a PURCHASE RETURN in the sample data for voucher table.....???

maybe sensible to test with...

will also need details of table/data for item_batch_stock IBS