chaturvedi.garima (4/30/2010)

---

Hi!!!

The variable is initialized in a stored procedure with the value present in a table.

It is disappearing at later point of time.The data type of variable is Char.

Tried to...

show us the function dbo.GetNextID()

we canhelp you turn it into an inline tablevalue function which can be used for multiple rows;

your syntax for usage would change only slightly:

INSERT INTO destination_table

...

I can think of two ways to do this;

first, lets think it thru: you can find a group of chips that have been salted, right?

--chips that had salt

select distinct chips...

gotcha;

I worked around the issue by combining the two triggers into one.

my logic is on insert, the external id is ALWAYS the Identity ID; you can change it later.

this does...

George Murphy (4/30/2010)

---

Thanks for your help. (mssqlserver 2005) I have a table called tier1 and a column named class nvarchar(150) it needs to have a default value set on that...

instead of using SCOPE_IDENTITY, it's usually recommended to use the OUTPUT clause to get the values inserted;

the advantage is similar to how you have to construct a TRIGGER: often times...

i think it's due to the query; do a select * from sysusers in any database. there's no Builtin\Administrators in that list.

the query is not showing implicit users who have...

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...