Viewing 15 posts - 5,731 through 5,745 (of 14,953 total)
I think source control and versioning, of some sort, is the only way to do this kind of thing.
December 10, 2010 at 6:24 am
Calculated from what? A text file? An Excel file? Data entry through an application or web page?
December 10, 2010 at 6:22 am
I don't know of a legal way to get a free copy of Excel 2007, so can't help you there.
December 10, 2010 at 6:21 am
You need to put the complex Select on top of the CTE, before From:
SELECT DISTINCT
fpartno,
...
December 10, 2010 at 6:13 am
That's what I'm saying. I think it might. Just an idea, not a proven concept. Might be worth checking, if you can.
December 9, 2010 at 12:37 pm
I don't know if it will do that. It might not.
December 9, 2010 at 12:35 pm
Is it possible you installed 2008 R2?
December 9, 2010 at 12:33 pm
Pull up the prior version from source control and recover it from there, is, I'm assuming, out of the question. That's the only reliable means I can think of.
December 9, 2010 at 12:32 pm
"Better" is subjective, but I use SQL Server deployment into msdb.
December 9, 2010 at 12:30 pm
The only thing I can think of is that the later version of Excel has more bloat to it and is slower. That would be normal, but I can't...
December 9, 2010 at 12:29 pm
If you're inserting from a tabular source, you could cross join it to a single row of the static data.
December 9, 2010 at 11:11 am
Are the two computers significantly different in terms of hardware? How about services loaded and running? Free resources?
December 9, 2010 at 11:09 am
Move the CTE into a derived table in the From clause. See if that does what you need.
December 9, 2010 at 7:46 am
You select the articles (tables) you want to replicate, and the data relevant to them gets sent over.
December 9, 2010 at 7:44 am
What's the SQL version? Select @@version.
December 9, 2010 at 7:00 am
Viewing 15 posts - 5,731 through 5,745 (of 14,953 total)