Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spikeyredchick
Starting Member
5 Posts |
 Posted - 2007-01-15 : 03:24:36
|
| I have a problem that cannot be posted on this forum. The reason is that the query is reliant on quite a large dataset to make it functional and I have no way to put the textfiles out to the whole forum. My problem is that I need to make changes to the query to give it extra functionality. I have the textfiles containing the data for the tables and the DDL ready to send. Would anyone be interested in helping me with this problem on a one-to-one level. I would email the SQL etc. Thank you |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-15 : 04:09:34
|
Wouldn't many to one better than one to one ?  quote:
The reason is that the query is reliant on quite a large dataset to make it functional and I have no way to put the textfiles out to the whole forum.
Try to post a small sample of the data that can illustrate the problem. Not everyone will have time to digest large sets of data.
KH |
 |
|
|
spikeyredchick
Starting Member
5 Posts |
Posted - 2007-01-15 : 05:13:38
|
| Yes, I agree it would be better. The problem is that the query is reliant on a large dataset to return any rows. It is looking over a long date-range and at best there will only be a maximum of 10-12 rows returned from a dataset of 60k rows.Because of this the full dataset is needed - a small selection would be useless. |
|
|
|
spikeyredchick
Starting Member
5 Posts |
Posted - 2007-01-15 : 06:40:14
|
| If anybody would prefer to contact me privately, my email address is:victoriaroad33a@hotmail.co.uk |
|
|
|
|
|
|
One-toOne help