Viewing 15 posts - 12,451 through 12,465 (of 18,923 total)
No need for a temp table here.... especially if only 1 row at the time is retrieved.
October 24, 2005 at 7:14 am
k, Go back one step. What problem are you trying to solve using this sp?
October 24, 2005 at 7:09 am
Ok, why using dynamic field names??
Did you read the link?
October 24, 2005 at 6:54 am
The Curse and Blessings of Dynamic SQL
Why are you using dynamic sql for this???
October 24, 2005 at 6:50 am
Is the query using some access function?
October 24, 2005 at 6:47 am
Please post scripts only (don't see the pics unless you update them on a webserver server).
Are you...
October 24, 2005 at 6:43 am
[Stupid question alert]
Is EM set to show System Objects?
[/Stupid question alert]
October 24, 2005 at 6:36 am
Just present it as money on the application side and you're done... you might also want to use decimal(9,2) on the server to keep that data and divide those numbers...
October 22, 2005 at 6:38 am
No you pretty much had the solution... Please provide the table(s) definition, sample data and the required output and we'll figure it out.
October 22, 2005 at 6:36 am
Wrong solution... should be ahndled by the app and calling the correct code.
October 22, 2005 at 6:16 am
Sorry, the link wasn't has obvious as I thaught it would be. I can't be certain that this will solve your problem but since the guy hasn't requested more...
October 21, 2005 at 1:20 pm
Can't help you much there... I'll let the dts gurus take this one.
October 21, 2005 at 1:08 pm
Search the forums for the word paging... there was a link posted for a similar problem a few days ago that would surely help you.
October 21, 2005 at 12:59 pm
Check the permission when run automatically... the user is most likely different causing something to be inaccessible.
October 21, 2005 at 12:57 pm
Viewing 15 posts - 12,451 through 12,465 (of 18,923 total)