Hi all,

First i'm sorry that i didn't provide a clear requirement.

I provided the specific value of B, 0, in order to keep the problem simple. However, in fact it must...

Paul White (1/9/2010)

---

If I understand the original English description of the requirement correctly, this appears correct:

DECLARE @data TABLE

(

ACHAR(2) NOT NULL,

BINT NOT NULL,

CINT NOT NULL,

VCHAR(2) NOT NULL

);

INSERT@data

VALUES('a1',...

Any other solution, please?:-)

Lynn Pettis (1/8/2010)

---

Tested, and looks like the same as above.

create table dbo.TestTable (

A char(2),

B int,

C int,

...

CREATE TABLE ViewA

(

A CHAR(2)

, B INT

, C INT

, V CHAR(2)

);

INSERT INTO ViewA

SELECT

'a1',...