If I understand the question, the thing you're looking for is a snapshot. That's an immediate copy of the entire database.

Well, that depends. If you have the keys needed to find the right row or rows in the child table and all the columns you want are in the child...

If a PK looks like this:

Col1

,Col2

,Col3

Then in order to reference that as a foreign key, the code would look something like this:

ALTER TABLE [schema].[tablename]

CONSTRAINT [MyFKName] FOREIGN KEY

(Col1

,Col2

,Col3)

REFERENCES [schema].[parenttable]

(Col1

,Col2

,Col3)

The names of...

From the sounds of things, you should also check some of the basic operations in the code like access order and/or join order. You need to make sure that the...

If I do the entire design from scratch, how much of the fee do I get?

Seriously though. We're here because we enjoy the technical challenges and each others company. Ask...

Depending on what kind of data you're trying to get back, yeah. Generally I've seen either a derived table or a correlated sub-query within the ON clause work extremely well...

Yeah, if you want to equate data set or result set with derived table, then they're the same. Generally though, most people refer to a derived table as a subquery...

According to Itzik Ben-Gan, a subquery is any of the scalar, multivalued or table expression queries written into an outer queries. He then goes on to refer to the scalar...

He means it sounds like homework.

I'd suggest using a subqery with a TOP and ORDER BY.

If you're trying add these values to a CTE, wouldn't you use UNION? Probably in a second CTE.

There was absolute agreement on the OUTER JOIN being an issue. The question was, did placing filters on the INNER JOIN make a difference? Several people anecdotally believe(d) so (myself...

mtassin (7/11/2008)

Grant Fritchey (7/11/2008)

You know, either way works for...

Generally, I've just passed all the fields back to the proc and updated them. Depending the app & the business needs, it usually doesn't matter if FieldX is updated from...

The time differences on those are pretty trivial. The same number of scans and the same number of reads usually tell you most of what you need to know.

You'll have to store the symbol and it's associated currency in a table in order to select on it. Otherwise you could create an enormous CASE statement, but the first...