I found the index by going through the databases. I scripted out the rebuild and reorganize commands and both ran successfully. The table is fairly small < 1200 records.

It sounds...

There are a lot of databases on this server. Is there a system table that...

When you concatenate 2 values and one is a null you will always get null so job_number_20+char(34)

will always be null if job_number_20 is null

Try this instead of job_number_20+char(34)

CASE...

bicky1980 (11/12/2010)

---

oh dear, 1 new problem now...This works fine, however on my last field which needed to have quote qualifiers not only has the 1st quote e.g. "hello. The...

If possible fix the source table with an update statement that replaces the empty strings with NULL.

UPDATE MyTable

SET MyField = NULL

WHERE MyField = ''

You could use REPLACE in...

For returning the data you could call a stored procedure like below. This will allow you to pass parameters as well.

Uploading the data to sql server I haven't done but...

We are going to backup the vm image and ship it to the DR site but this won't be real time, it will be a periodic backup. The database files...

Thanks you for the clarification. over and out...

sqlserver.exe is using 2.8 gb and /3gb is in the boot file. It would seem this is properly configured then.

>>Monitor the server afterwards though, in most cases the extra memory...

There is a maintenance plan so backups look good. Indexes are being rebuilt as well.

>>Since this is a dedicated SQL Server, the memory allocation is fine being set as default.

So...

See if these links help.

http://www.help-sql.info/27/3/1120124.html

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/28/SSIS_3A00_-Building-Packages-Programatically.aspx

Your are right and you code does get my desired results. Simpler, faster, better...Thanks again.

Which brings me to this....

SELECT

CASE WHEN EXISTS

(

SELECT 1

FROM Parent P

INNER JOIN Child C

ON MyTable.ParentID = P.ParentID

INNER JOIN ChildCustom CC

ON MyTable.ChildID = CC.ChildID

WHERE CC.SillyFlag=...

This is a better representation, sorry about that.

So WHERE P.Parent_CD = MyTable.Parent_CD will refer one of the main tables in my SELECT.

Thanks for being willing to make suggestions when...

Thanks to those who responded, it was educational. Pursuing hierarchical processing is beyond my scope right now so I'd like to close the thread.