Viewing 15 posts - 6,361 through 6,375 (of 9,643 total)
Please post the DDL, some test data, requirements, and the desired results. I can almost guarantee you that we can eliminate the existing cursors.
Yes the cursors are...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 10:45 pm
halifaxdal (1/7/2009)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 1:53 pm
You don't need to use openrowset. You just use Bob's solution with the EXEC.
What are you doing with data after you retrieve it from the remote server? Does...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 1:14 pm
Great glad I could help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 12:42 pm
Michael Earl (1/7/2009)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 12:15 pm
You just need to go into your linked server properties and enable RPC and you should be all set.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 12:14 pm
Michael Earl (1/7/2009)
Steve Jones - Editor (1/7/2009)
New Hampshire's a state? I thought it was a big college campus/ski resortAll I know is they have drive through liquor stores.
Now don't get...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 12:06 pm
Steve Jones - Editor (1/7/2009)
New Hampshire's a state? I thought it was a big college campus/ski resort
Well, it has 2 Senators like every other state and has to deal with...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 11:46 am
You can create a linked server using that user and then use 4 part naming to execute the sp.
linkedserver.database.schema.storedprocedure.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 11:35 am
GSquared (1/7/2009)
As written,...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 11:30 am
I'd agree with Steve, especially now that the ReportViewer control is available and you can write reports within your applications. ActiveReports is pretty good.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 11:11 am
Are you sure that This.UserName is returning the name in the format you need?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 11:05 am
Grant Fritchey (1/7/2009)
No, I blame MA on the idiots that keep electing the Kennedy's to office over and over again.
I guess you can't argue with that. The worst part...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 11:02 am
You definitely want to use a database role to grant permissions and then put your login/user in the role.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 11:00 am
Grant Fritchey (1/7/2009)
Jack Corbett (1/7/2009)
Michael Earl (1/7/2009)
Thanks Jack.No problem. Just seemed to notice a correlation. I suppose I could be way off, maybe there are other factors involved.
He...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 7, 2009 at 10:53 am
Viewing 15 posts - 6,361 through 6,375 (of 9,643 total)