Steve can you put out some numbers for perspective? SSC has a lot of users and traffic, compared to many of us small biz guys we usually deal with; my...

OK I just completed a proof of concept. it's kind of what you want;

Check your third party license. if they allow you to use replication for disaster recovery, you are...

it depends on the unique constraint.

instead of trying to do it on just one column, you should have asked if it can be expanded to cover more than just a...

I think I'm starting to bring this into focus 🙂

So, serve up the article dynamically via SQL query where 0001.aspx calls query such as select the article ID with the...

Are you adverse to copying the same page over and over again?

it'd be pretty simple to have some page look at it's own name, and provide the content dynamically, based...

i would do it basically the same as you were thinking;

a job running periodically that compares my local table of the last time i looked at the data.

your local table...

looks like we need a bit more info; Can we go to the web site and see what we are talking about?

i'm assuming the ArticleId is unique to the content;...

just for fun, here is some inline javascript example, where i'm getting the meta tag "Description"'s value. i'm just doing an alert(), but you could have the button to submit...

Sid whenever I've done anything like this, I've always just added a hidden input to the form of the page that contains the article Id you'd be looking for;

then...

but your @student table does not allow nulls for the lunch; that is the constraint failure;:

,LunchPeriod INT DEFAULT(4) ...

i think i had to change my data; you had one class with a null lunch:

SELECT '10-B', NULL

which i changed so it would work; i was kind of assuming...

000, 052, 020, <--those are not numbers. 0 is zero, there are no preceeding digits for real number types like integers, so you are right, you'd want to consider a...

ahh...exactly my point... a view never needs to be updated. you might think of it as self-updating.

technically, it is a saved query, that is run on demand.

if you run it...

how about selecting from the @Class table?

INSERT INTO @Student(FirstName, LastName, ClassID, LunchPeriod)

SELECT 'John', 'Smith', @ClassID, isnull(@LunchPeriod,LunchPeriod) from @Class where ClassId = @ClassID

yes it does; at a minimum, i followed your steps and got a shared lock on the table; you can check it yourself by doing as you described, and then...