But with all the spare time she would have, 3x the money probably won't...

On a slightly different subject:

Is there any specific reason to go from SQL 2000 to 2005 less then a month before the end of the mainstream support of 2005?

By now...

David Fulton-420388 (3/30/2011)

---

Now I feel rather silly.

The db that we are migrating into is 2005. The old db, the one that I'm trying to get the information from is...

There's an unclosed code block (BEGIN without END).

Strong hint: Proper indention helps a lot... 😉

Errmmm - Query Analyzer?

You're not using SQL Server 2005 or beyond then? (that's what I assumed based on the forum you posted...

Please provide more details about how you're using the query....

:blush:

😀

Something like this?

SELECT t.name AS table_name,

c.name AS column_name,

y.name AS column_type,

...

Unfortunately, based on the original table DDL you provided the code won't run.

Please provide the DDL for all related tables as well as sample data and values for the parameter...

If you're talking about a row by row approach then: OUCH!

Get...

I hope you're feeling better now. What type of medicine did you take to cure the disease? 😀

You could start with the following query returning all tables and related columns in a database:

SELECT

t.name AS table_name,

c.name AS column_name

FROM sys.tables t

INNER JOIN sys.columns c

ON...

Step 1: verify the data make sense in terms of describing the business scenario.

Example: Do you have rows in your import table with "Company A", "Company A Inc.", "Company A,...

I'm neither Gail nor Jeff nor do I consider myself a "biggie" but here's what I think might be the issue:

Most of the high counters are related to SQL Plans,...

Here's the CTE solution using MIN(SubmissionBatchID).

Side note: I also change the way to query for the year 2009 to make it SARGable...

;WITH cte AS

(

SELECT submissionID, MIN(SubmissionBatchID)

FROM tblsubmissionHistory

GROUP BY submissionID

)

SELECT ...