I forgive thee....:D

Works like a charm, thanks very much!

Raymond

Yes it has... as I started with, the SP that imports data from that file...

Thanks to all for the overwhelming response! What a great site and forum this is.

As for using the script wizard: it doesn't script master system sp's. I never realized this...

From: http://www.webtropy.com/articles/SQL.asp?SQL=sp_MS_marksystemobject

-- FOR INTERNAL USE ONLY ... DO NOT DOCUMENT --

-- This procedure sets a bit in sysobjects. This bit has no meaning, various

--groups (starfigther, davinci, replication) use it...

Hi Jeffrey (and others)

Thanks! Exactly what I needed!

I stumbled across

http://msdn.microsoft.com/en-us/library/ms187760.aspx

that handles synonyms, it was not perfect at all, but better than nothing.... of course your solution is better.

Of...

Hi there,

Thanks for your input.... however being a newbie about where (or where not) to place SP's I'm not quite getting it. I understand that when you put a SP...

Super! Your example (values from just one row) was right what I needed.

Thanks!

Ray

I can't avoid using Excel sheets to import data - all my (potential) customers work this way.

Anyway I solved the problem (I added the solution to this forum but somehow...

I already tried TEXT (in Excel) as well. My big friend Excel tells me that all numbers will be treated as text, and be written as they were entered. Great,...

Hi,

I did change the column with telephone numbers to 'Special'|'Telephonenumbers' in Excel. It still gets imported as a float in SQL2005, with leading zeroes omitted and phonenumbers with a dash...

Hi there,

Solution 1) does the trick; as a stored procedure the error doesn't occur.

Thanks to everyone for the help,

Ray

Nope... it's SQL2005.... SQL Server 9.0.1399 (free Express Edition) to be exact.

The behaviour is pretty strange: the first time I run the query I get the message. After that,...

Hi,

Thanks for your reply.

When I try your solution in the Server Manager Studio I get a popup with this message:

query:

SELECT name,Count(*) OVER (Partition BY 1) AS [Count] FROM customers

message:

The...

Maybe this helps: use WITH (NOLOCK).

I had some locking issues, and after I started using this they never showed up again.

Example:

SELECT c.*,t.* FROM customers WITH (NOLOCK)

INNER JOIN tickets t WITH...

Hi again,

In addition to the discussion..... a lookup table for male/female was just an example.

A reason for me to use lookup tables is that users can fill their own...