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.

My employer strongly discourages...

Thnaks All. I was able to reach a suitable solution using the CASE WHEN EXISTS syntax!

John Rowan (10/27/2010)

---

Thanks Gus, your correct.

Chrissy321, You mentioned that you can't put the flag at the parent level because application/security reasons. Rarely have I seen where outside factors like...

GSquared (10/27/2010)

---

Your solution will work if the hierarchy only has two levels. To be precise, it will work if a child can't have...