Having been in the position you describe, wish I had heard your talk before my hair turned grey. Nice clear description of the position many are thrust into, with...

Jeff Moden (4/11/2011)

---

Apparently so. I'll send it out when I get home tonight....

Pink123 (4/11/2011)

---

I found the mistake it was the wrong table name ,but this is giving me the rownumber as 1 and showing 1 record .

How do I get the actual...

It would help those who want to help you, if you would post the table definition, some sample data and required results from the sample data.

To do so, please click...

A snippet of code from Jeff Modens article, which can be accessed by clicking on the first link in my signature bloxk

SELECT 'SELECT ' +...

Jeff Moden (4/10/2011)

---

bitbucket-25253 (4/10/2011)

---

Jeff Moden (4/9/2011)

---

Shifting gears real hard, I'm finally done not only testing a fix to the Tally Table delimited string splitter performance problem, but I've also finished...

Jeff Moden (4/9/2011)

---

Shifting gears real hard, I'm finally done not only testing a fix to the Tally Table delimited string splitter performance problem, but I've also finished the article on...

Requesting a favor from the denizens of the thread. A fellow member of my user group (ONSIG) is striving to present at meetings such as SQL SAT's and has...

2 + 2...

Read this article on SSC

Sorting Months By Number (SQL Spackle)

By Jeff Moden, 2010/11/15

Here is the link to the article:

http://www.sqlservercentral.com/articles/T-SQL/71511/

Now, now ... as one who will have his 39th...

Dominic Gagné (4/8/2011)

---

Is there any way I can call a storedProc with parameters on a linked server and put the resulting recordset on a local temporary table, like I need...

OPENROWSET - does NOT accept variables for its arguments.

Thus you will have to use dynamic sql statements to do what you seem to need to do.

Use this link:

http://technet.microsoft.com/en-us/library/ms190312(SQL.90).aspx

Scroll down to...

Here we go again .... the answer is based on

NCHAR(n) and based on that the supposed answer is correct

However (Question text set to Bold and character size altered ...

Thanks for your reply. Now in the spirit of being a community, to help others, would you mind posting your code, so that others may learn how to solve...