Posted by: Charles Maitland | Friday 24 February, 2006

Copy and Paste SQL Server 2005 to Excel

We have just found a really strange effect.

In SQL Server 2005 we ran this query to get a quick dump of cost centres for another application:

Select Distinct CostCentreCode,CostCentreName

fromdbo.DimAccounts

The results were reported as 5021 rows. I Selected all these copied them and pasted them into Excel.

Imagine our surprise when in Excel only 3673 rows appeared!

I have no idea why. I can only think it may be a limit in the clipboard buffer.

This is potentially a vey dangerous situation. If it was not for my collegues sharp eyes it could have gone undetected till go live.

Does anyone have any ideas why this happens?

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories