Viewing 15 posts - 1,711 through 1,725 (of 5,502 total)
David Fulton-420388 (3/30/2011)
The db that we are migrating into is 2005. The old db, the one that I'm trying to get the information from is...
March 30, 2011 at 2:25 pm
There's an unclosed code block (BEGIN without END).
Strong hint: Proper indention helps a lot... 😉
March 30, 2011 at 2:15 pm
David Fulton-420388 (3/30/2011)
Hi Lutz,I'm executing it with Query Analyzer.
Thanks.
Dave
Errmmm - Query Analyzer?
You're not using SQL Server 2005 or beyond then? (that's what I assumed based on the forum you posted...
March 30, 2011 at 2:10 pm
David Fulton-420388 (3/30/2011)
Lutz and ColdCoffee,Thank you for replying.
Unfortunately, Lutz's query returns this:
"[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error"
Thank you.
Dave
Please provide more details about how you're using the query....
March 30, 2011 at 2:02 pm
Something like this?
SELECT t.name AS table_name,
c.name AS column_name,
y.name AS column_type,
...
March 30, 2011 at 1:44 pm
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...
March 30, 2011 at 12:31 pm
samsql (3/29/2011)
...About the upload it gets uploaded from the text file one by one(here the data gets update or insert).
...
If you're talking about a row by row approach then: OUCH!
Get...
March 30, 2011 at 6:20 am
Alvin Ramard (3/29/2011)
...Sorry folks, I was hibernating 😎
I hope you're feeling better now. What type of medicine did you take to cure the disease? 😀
March 29, 2011 at 4:31 pm
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...
March 29, 2011 at 3:50 pm
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,...
March 29, 2011 at 2:47 pm
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,...
March 29, 2011 at 2:35 pm
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 ...
March 29, 2011 at 1:47 pm
You need to define the submissionbatch you want to return if there is more than one. You could either use MIN(),MAX(),SUM() or any other aggregation you like.
But then you'd need...
March 29, 2011 at 1:17 pm
Here's a script to query the data per SQL instance:
EXECUTE sp_msforeachdb 'USE ? SELECT DB_NAME(); SELECT *
FROM sys.extended_properties'
March 29, 2011 at 1:12 pm
Viewing 15 posts - 1,711 through 1,725 (of 5,502 total)