-- Heres one way

create table #TableOne (partNo int identity, TotalQty int)

Insert into #TableOne (TotalQty)

select 10 union

Select 500 union

select 333

Create table #TableTwo (SalesNo int identity, PartNo int, StartAvailable int)

Insert into...

this is an insert into.

Where the results of your select will be entered to the table on the insert. You did not indicate where the information for the city and...

I would handle failover situations differently than keeping data in sync across dev/qa/acceptance.

You should look at failover clustering or log shipping for this.

But as far as getting production data over...

I guess to me the question would be why?

Is it worth the time and money to create something to keep data in "sync".

Is it static data the application needs? or...

You can generate csv or xls from Sql Server DTS

Lots of info and tutorials on sqldts.com

Hey Mark,

Check the owner that the maintenance jobs are running under.

This message usually indicates that the owner of the job is either Invalid, pasword has expired, or user is...

Have you checked available disk space on the drive that tempdb is stored on?

Seems like there is no space.

tempdb does not need to be backed up.

Not exactly sure what you mean by Score., But have you looked at functions Soundex, and Difference?

They return a value based off comparison, but not a score per say.

I have not worked with...

Just grasping at straws, but perhaps you could extend notification services to do something like this?

What value?

The value of the last record inserted, the first, are you including a where clause?

Similar to Mkeast suggestion

If i wanted the last record inserted.

CREATE PROCEDURE sp_web_getPKIDFromNamedValue

(

  @Table varchar(50),

  @FieldName...

what exactly are you asking?

what do you mean by value?

you want the stored procedure to return to you the name of the column(s) that is the primary key for the...

Create a number table with numbers 1 thru whatever

then perform a left join

Select *

From MyTable

right Join numbers on mytable.pk = number

where mytable.pk is null

  and number < (select max(mytable.pk)...

I would not recommend you do it the way you are trying, You Should not create a looping structure. Plus you should always create your triggers to accept datasets, you...

look at the datepart function.

datepart(hh,mydate)

will give you an integer of the hour.

no, since the column is already variable, increasing the variable size should be instantaneous, if it was a fixed char, and increasing the char length, it would take foreeeevvvvveeeerrrrr. Do...