Are you saying that...

bvinay57 (4/15/2009)

---

Hi

select NULLIF( STATE, 'null') AS state FROM T1 i have used this it is giving empty string in null values but i want to replace the string with 'all'

can...

venki (4/15/2009)

---

Thanks for your reply Chris.

I am sorry to bother you. The problem is fixed now. There is a duplicate data for that column where user is trying change...

Why? Now the stored procedure doesn't work - it will insert a row whether it's required or not.

krayknot (4/15/2009)

---

now the...

Hello

Can you please provide a table creation script and some sample data in an easily-cunsumable format? This will show you roughly how to do it:

CREATE TABLE #sample (id INT, Ecode1...

What's the name of the primary key column?

How are new values for the PK generated?

The Access application may be attempting to change the value in the PK column on the...

Use ISNULL() or COALESCE() as suggested.

Either will work...

@puyinc (4/15/2009)

---

No, there is not unique id, maybe I didn't explained my self very good.

What I wanted to do is to return the values of the Meal column in the...

Here's an unpivot method, for the record:

DROP TABLE #sample

--

CREATE TABLE #sample (id INT, Ecode1 VARCHAR(5), Ecode2 VARCHAR(5), Ecode3 VARCHAR(5), Ecode4 VARCHAR(5), Ecode5 VARCHAR(5))

--

INSERT INTO #sample (id,...

A very simple solution is possible using UNPIVOT, but it relies upon an ID column...

Does the table have an ID...

andrew.rendall (4/14/2009)

---

I generally use a "find and keep" approach - I find the initial records (T records as they have more information to select on) and keep them in a...

Does the table have an ID column?

Are your results from running Steve's code?

You're welcome.

Did you mean storing your intermediate result in a temp table, or using it as source for your id's? There might be some mileage in this approach:

DROP TABLE...