Absolutely views are not recompied at run time,

Try this.

Create a table (myTable)

Create view myView as

SELECT * FROM myTable

Modify the table structure

SELECT * FROM myView

You won't see the additional columns until...

it looks like an opportunity to dip your toe is the SSIS water 😀

Thanks Eugene, That was really helpful.

Just because I am anal about these things 😉

How would you write the select statement if the data was in a #temptable with a column...

Never mind,

the following query gives me the desired result and runs in 11 seconds

select caseno from cpcases

except

select caseno from caseExceptions

I would still be interested in the answer to the...

out of interest then; if I was selling books (ISBN, Author, Pages), wine (bottle size, ABV,Vinyard,grape,acidity) and shirts (material,collar type, sleeve length), how would you recommend storing the attributes...

This is an indication that your data is poorly structured.

you are using a text field to represent a binary value (Pass/fail)

I would suggest the introduction of a lookup table

declare @TestStatus...

another thing, if you are going to create a new table and manually insert the records into it, dont forget to turn identity insert on; otherwise you will potentially destroy...

also, if you are running on an old server with I/O bottlenecks, are you running SQL2008. An earlier versin may affect the answer.

Its not an area I am familiar...

@Dwain: you said you used ID to control the sequence. I explained in my first post that I thought that was dangerous because it is a field you...

create table test.elogen

(

ID int identity(1,1),

RouteID int,

Routename nvarchar(20),

Origin nvarchar(1),

Destination nvarchar(1)

)

insert into test.elogen values (1,'ReturnTrip','A','B')

insert into test.elogen values (1,'ReturnTrip','B','C')

insert into test.elogen values (1,'ReturnTrip','C','B')

insert into test.elogen values (1,'ReturnTrip','B','A')

insert into test.elogen values (2,'ReturnTrip','A','B')

insert...

The cost of the hardware and DB licences is normally a small fraction of the price of keeping your systems running. Implementing good practices for automation: backups, sheduled jobs,...

It is Called Adjency List model and it is very common in Relational databases

Organisation hierachy, BOMs and Menu structures are three uses for it. Intil SQL2005 came along it...

Can anyone beat this? its from the NHS clinical data set upload for patient details

<personGenderCodeCurrent>M</personGenderCodeCurrent>

I had to do this about 10 years ago with an Access (95!) based EPOS system in 10 retail outlets and IBM DB2 system at head office.

We were sending transaction...

It doesn't matter how many times you post the #new DML, it still won't be right :w00t:

this is the tree structure in your #Original table

1

--2

--3

--4

5

--6

--7

--8

Each sub menu is one level...