Glad to be of assistance. Thanks for your reply

As promised on 10/24 finally found some free time. Now this code is not the fastest, and more than likely could be improved, but it does what I think...

Assuming that your question is a serious need for assistance. Try this code

CREATE TABLE Atable(Id INT IDENTITY(1,1),EmailAdd VARCHAR(100))

INSERT INTO Atable

SELECT 'myaddress.gamail.com'

GO 10 --Add 10 records

--Check that EmailAdd column...

I strongly suggest that you read this item by Jeff Moden

Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

By Jeff Moden, 2010/12/01

http://www.sqlservercentral.com/articles/IsNumeric/71512/

Jeff lists numerous reasons, with examples, of why ISNUMERIC "fails"...

scott mcnitt (10/27/2011)

---

Thanks, bitbucket (Ron). I guess I had assumed that they would be really good at all the standard management things (backups, watching logs and alerts, keeping the trains...

Blew that one as did someone before me.

Learned a lot by reading your references - thanks for those.

I hope you have a job(s) to periodically back up your DB and log files.

If so.

1. Who is going to check those jobs and modify the backup path...

1. Did you use table variables in your post only to illustrate the data and these are NOT used in your actually code? (Yes used in my production...

Using BOL (Books On Line) for a reference. Think about using a single column whose data type is varbinary.

Read this article by Jeff Moden, and its sample T-SQL .. it may be the answer to your question

http://www.sqlservercentral.com/articles/T-SQL/68467/

Your request is rather vague, but I think you might want to look at this posting.

http://www.sqlservercentral.com/Forums/Search1-0-2.aspx?SessionID=3vw2y455mzk1vp45dszjevzz&SortBy=2&SortOrder=1

If my assumption is incorrect come on back with a more definitive question.

Rather surprised that as of this posting only 44 percent of those answering had answered correctly.

Getting close to midnight for me, and my brain is getting tired. But and it is a big but, you can retrieve all the column names for a table...

A lot of reading of the T-SQL but a GOOD question ...

Is this what you require?

CREATE TABLE #T(

[NationalIDNumber] [nvarchar](15) NULL,

[ContactID] [int] NULL,

[ManagerID] [int] NULL)

INSERT INTO #T

SELECT 'GOT',NULL,NULL UNION ALL

SELECT NULL,1,NULL UNION ALL

SELECT NULL,NULL,2 UNION ALL

SELECT NULL,NULL,NULL

SELECT COUNT(*) AS 'All rows',COUNT(ContactID) as...