At the risk of sounding like an academic, are you sure you are using the right tool to solve the problem?  Or phrased differently, are you using a hammer to turn...

Thanks all for the opportunity to spend time in the community.  I learn more from every post I answer.

So, just out of curiosity, what...

G'day,

This is one of the rare cases where a cross join makes sense.  Be careful if you use this solution in a real production situation.  Performance may demand a slightly...

I have used SqlDIFF by AdeptSql for a few years now.  I have used all of the other tools mentioned so far, and like SqlDiff in terms of feature set...

G'day,

Your best bet may be avoiding the problem rather than solving it.  Simply place two buttons on the search form - "Quick Search" which does the full text currently implemented,...

Hi Brian,

You will get a better answer if you post DDL for the table, as well as some sample data and expected results.  Without that, a simple method might be...

G'day all,

The following code assumes a particular pattern for the string.  Specifically, a space before the ';' as our example shows.  A bit of tweaking will make this a more...

G'Day,

This might work...

CREATE TABLE ApptFields (

ColumnName VARCHAR(25),

IsAvailable INT

)

GO

INSERT INTO ApptFields (ColumnName, IsAvailable)

SELECT 'Referral', 1 UNION ALL

SELECT 'Balance', 1 UNION ALL

SELECT 'Remark', 0 UNION ALL

SELECT 'Home', 0 UNION ALL

SELECT 'DOB',...

Another thought that will save you some work...  Or maybe make your life harder. 

This sort of table is typically used for path traversal...

G'Day,

Here is an example that uses coalesce and does not use cursors.  This is an example to show you might approach the problem.  It is not a proper production grade...

G'day,

create table Family (

ID   int,

Name   varchar(200),

charges  int,

payments  int,

balance  int

)

go

create table Billing (

ID   int,

Name   varchar(200),

charge   int,

payment  int

)

go

UPDATE Family

   SET FAMILY.CHARGES = B.Charge

  FROM (SELECT ID,SUM(CHARGE) Charge FROM BILLING GROUP BY ID) B

 WHERE FAMILY.ID...

Wonderful thoughts Steve,

But don't quit your day job yet in hopes of making a living as a poet... 

Happy holidays all

Wayne