Viewing 15 posts - 1,696 through 1,710 (of 2,452 total)
rs80 (4/16/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 16, 2013 at 1:21 pm
eseosaoregie (4/16/2013)
Hi guys,Just to let you know that running the script within SSIS as mentioned above got the query time down to 45 secs.
thanks
I make that 32x quicker .....pretty impressive...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 16, 2013 at 12:25 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 16, 2013 at 12:15 pm
glad to hear you are making some progress.
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 15, 2013 at 1:46 pm
maddhi.srikanthreddy (4/15/2013)
YTD--Year To Till Date.
QTD--Quarterly To Till Date.
MTD--Monthly To Till Date.
Please suggest me a query for retrieving values for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 15, 2013 at 11:40 am
maybe be useful
SELECT Datename (WEEKDAY, GETDATE())
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 15, 2013 at 9:38 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2013 at 3:35 pm
for the benefit of others who may in the future read your post...would you care to share your solution.
many thanks
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2013 at 2:18 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2013 at 12:21 pm
Maybe something along these lines will help
;WITH cte AS
(
SELECT itemid ,
location ,
ROW_NUMBER()OVER( PARTITION BY...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 13, 2013 at 2:47 pm
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]
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 13, 2013 at 5:49 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 12, 2013 at 7:26 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 11, 2013 at 1:54 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 10, 2013 at 11:25 pm
will also need details of table/data for item_batch_stock IBS
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 10, 2013 at 8:50 am
Viewing 15 posts - 1,696 through 1,710 (of 2,452 total)