CozyRoc (9/2/2009)

---

This confirms the problem is with the specific ODBC source. I don't think the issue is in SSIS because this same general component is successfully working with many other...

CozyRoc (9/1/2009)

---

Can you check if there is sudden memory consumption spike at this 5 minute range? Can you make a test, forwarding the data to Trash Destination, so you can...

what am I supposed to do with Trash Destination?

I agree with Royce's comments.

You haven't given us any idea on the number and size of the tables, nor how complex your sprocs and views are.

If it is a very...

unsure of exactly what you require as expected output, here is a variation of Adi's code:

select POST_DAT, RETL_KY_FIID, COUNT(AMT_1) AS TOTALTRANS,

SUM(case WHEN AUTH_TYP = '0210' THEN amt_1 ELSE 0 END)...

And the answers are:

1. Who are the professors who are teaching more than 2 subjects...

try linking profesor to exams and use a Group and...

1mwalsh1 (8/28/2009)

---

Hey gah,

I've been out of town for a few days, just got the chance to delve into your suggestions.

Looking at my data, it seems that, for...

assuming there is an Access ADP front end, what are your specific reasons...?

just being curious ..and happy...

Lynn Pettis (8/25/2009)

---

This is the only part I don't agree with and I think there...

my simple thoughts:

FAQ page...probably easier to request than implement

"How to Post Questions Properly for Faster and Tested Answers" page...in BOLD at the top of all "Post New Topic" pages....:-P

Improved search...

Hi Mike

I have altered your table structure a little ....

please run code below and see how you get on.

I am concerned that each vendor has their own table and Product...

Hi

didnt we walk down a very similar road a few weeks ago?

http://www.sqlservercentral.com/Forums/Topic751567-338-1.aspx

Hi Mike

the way you have described your data you could just run Price/(Pack*Size)

but it may not be as simple as this.

So that neither of us gets confused or misintrepts each...

Mike...not sure if there are any tutorials as such for UOM conversion...but obviously you have looked.

I use UOM conversions to allow me to sum products that are sold in differing...

Guess...???

You posted a problem,

You were given some possible solutions based on the limited information you gave,

You did not respond to request to provide more...