CREATE VIEW x

AS

SELECT * from linkedserver..schema.table

Works great.

Jereme Guenther (10/25/2007)

---

So what is the advantage of OUTPUT parameters over a standard result set? From my experience they are much more of a pain to deal with both...

Unless it's impossible for some external reason, your stored procedure's parameters should always be of the data type that you're attempting to manipulate within the database. So, instead of a...

This is a discussion about the editorial posted today (Friday 10/26) by Steve Jones. Scroll up & follow the link at the top of the comments.

Drew Mayo (10/26/2007)

---

Kelvin Lush (10/25/2007)

---

I see nothing wrong with this question. It is basically trying to test whether you are using the ANSI standard JOIN syntax or the older syntax...

I don't have a solution, but possibly an idea.

I live the first few years of my life in a VERY small town in Southwest Missouri called Sarcoxie. For a while...

Sorry, I just plucked it from the middle of existing code. Our system has one table that doesn't have versions and all the rest do. So the query included the...

We also did some this way:

SELECT...

FROM Table x

CROSS APPLY (SELECT TOP(1) whatever..

...

We had a similar problem and solved it, nicely, like this:

SELECT...

FROM Table1

JOIN Table2

on table2.PK = table1.Pk

and table2.AuditDate = (SELECT TOP(1) t2.AuditDate

...

They've already had several instances of "Oh, I forgot to add that WHERE thingie to the query."

We did win the support argument. We've pretty much told them, if they tank the system, our only troubleshooting method will be a restore or restart the server. No other...

AAARRRGGGGH!

I can't believe I got such a simple question wrong. Reading the question carefully really does matter. I saw amalgamate & rows and didn't see the word tables in between......

Pick any rule you want and then follow it consistently.

Personally, I'd use camel case, or bumpy case so that the column would be:

AfterGlowLightingCompany

But honestly, if you don't mind a bit...

Check to see if anyone has set collation on the columns different than the collation for the server. That would explain why only some of them are having the issue.

There's just not one right answer. The question you have to ask, in addition to the structure, how will the data be accessed?

For example, CustomerCode on your Customer table sounds...