Excellent job posting ddl and sample data. However I don't understand at all how you came up with the desired output.

RCDAWebmaster (6/21/2013)

---

so does that code not update the fields in the DB table if the parameter sent to the stored procedure coming from the web form is blank? if so,...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

RCDAWebmaster (6/21/2013)

---

The reason I wanted to use dynamic SQL was to avoid making and running up to 14 seperate updates depending on which fields were completed on the web form....

Luis Cazares (6/21/2013)

---

Sean,

there's no need for the ISNULL as NULL > '' won't return true. 🙂

where...

Or maybe this?

where ISNULL(firstname, '') > ''

This will exclude NULL and empty strings.

There are so many reasons this is a bad and so few reasons it is a good idea. Usually devs will have elevated privileges to the dev server that are...

dudyone (6/21/2013)

---

I am having trouble where it starts with:

AND jomast.fcompany LIKE 'AT&T*', 'Centerpoint*', 'Cingular*', 'Dynis*', 'Global*', 'Sabre*', 'US*', 'Verizon*'

and down.

It does not Like the (Like) statement. I have tried everything.

The...

It is NOT an error with SQL. It is a logic error in your code that violates business rules. The...

RCDAWebmaster (6/21/2013)

---

I'm moving the code from front end to backend as stored procedure. I'm building these strings but they will not be vulnerable to SQL injection because the are parameterized....

Mile Higher Than Sea Level (6/21/2013)

---

Yes it is an integer.

What I am attempting to return is a True / False (meta data) - not the actual records.

THANKS!! A function...

it.web (6/21/2013)

---

I'm writing a stored procedure to update an employee in the employee table. Each employee in the table has 17 fields. The data is coming from a web form...

PiMané (6/21/2013)

---

Hi,

That's what I'm doing for some cases, just like I say "rather than writing code after every update statement checking @@ROWCOUNT?".

But since I'm using SQL Data Compare some scripts...

Pretty tough to tell what you are trying to do here but it seems like all the VBA is doing is running a query and seeing how many rows it...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...