I don't drive to work, but spend over an Hour on the tube (if there are no delays) and in this heat it getting a bit unberable...

the SQL server 2005 Bible is an excellent book, it has helped me out many times..

http://www.amazon.com/Server-2005-Bible-Paul-Nielsen/dp/0764542567/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1215168314&sr=8-1

Have you tried creating an ODBC connection to SQL and then linking to this via

Data --> Import External Data --> New Database Query

You can write your queries there and...

This is something that should probably be left up to your front-end application.

There is an excellent article on this site about splitting delimitted strings.

http://www.sqlservercentral.com/articles/TSQL/62867/

The article deals with csv but would be easy to change to '|'

As stated and as in the link, it depends on how much storage space you have on your server,...

adnan.korkmaz (7/3/2008)

So, isn't some similar scanning occur...

Thanks for the feedback,

For future reference to obtain the...

Rather than use a recursive query , why don't you use another inner-join

SELECT ci.StmtNum, s.Stmt, s.Count_Range,sc.CharNum, c.Characteristic

FROM tblClientImport...

Have to agree with this, there are a lot better examples of SQL puzzles that can be...

Your first query would have thrown an error since the second ')' was in the wrong place.

also try removing the space after 's. '

What is the error message you are getting with Query 1 ?

try writing query 1 like this

Update DIRXMLUSER

SET JOBTITLE = (SELECT SHEET1$.[JOB TITLE] FROM SHEET1$ S

...

Both of them are going to be in demand in the future, it really depends on the size of the organisation you work for. Quite often the same dba...

It is only procedures with 'SP_' prefix that cause the performance impact of scanning the system databases first.

'SP' should be fiine.

SQL Server BoL is a good start.

There are also plenty of books available from Amazon or your local book-store on pretty much every aspect of SQL -- take your pick..