Forum Replies Created
Viewing 15 posts - 2,341 through 2,355 (of 2,452 total)
-
RE: SSIS data import reduced to a crawl
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...________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: SSIS data import reduced to a crawl
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...________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: SSIS data import reduced to a crawl
what am I supposed to do with Trash Destination?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Transfer SQL Server 2005 DB Objects to MS Access
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Query Help
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)...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Need help for creating couple SQL queries
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: UOM Conversion
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: What is the best front-end software to use
Elliott W (8/27/2009)
What I can go onto saying is pretty much anything BUT Access..CEWII
assuming there is an Access ADP front end, what are your specific reasons...?
just being curious ..and happy...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Improving Site Navigation
Lynn Pettis (8/25/2009)
SQLBOT (8/25/2009)
... and also an ability for the OP to mark the thread as answered. ...This is the only part I don't agree with and I think there...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Improving Site Navigation
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: UOM Conversion
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Join problem
Hi
didnt we walk down a very similar road a few weeks ago?
http://www.sqlservercentral.com/Forums/Topic751567-338-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: UOM Conversion
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: UOM Conversion
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Many to Many Check
Half Bubble (8/21/2009)
You have to guess
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Viewing 15 posts - 2,341 through 2,355 (of 2,452 total)