create a view

MyView

Select OrderNumber, Orderline, Company, SizeScale, n ,

 Case   when n = 1 then OrderedUnit1

        when n = 2 then OrderedUnit2

        else OrderedUnit3 end As OrderedUnits

From

 tmpOrderDetailSize  S

 cross join...

insert into  OrderDetail ( OrderNumber, Orderline, Company, SizeScale, BucketNumber, OrderedUnit)

Select OrderNumber, Orderline, Company, SizeScale, n,

 Case   when n = 1 then OrderedUnit1

        when n = 2 then OrderedUnit2

        else OrderedUnit3...

Query Analyzer <> MS Access

Sorry

>>>Our chief Network Admin belives a NAS connected directly to our sql cluster boxes would be as fast as a local drive ( as good or better than to a...

SELECT     [Customer Change No], [PIA Material No], 

CASE WHEN [Adj Due Date] IS NULL THEN  [Due date] ELSE [Adj Due Date] END  AS Expr1

FROM         dbo.[tblPPAP Notification Detail]

hth

Yukon has besides SQLMail, SQLiMail ( smtp client) so you may be able to get your stuff out of OUTLOOK but again still in beta and you never know how...

Gregory,

It has been my experience that since Outlook 2002 on SQL mail is in BAD SHAPE. The only fair solutions so far has been either xp_smtp or CDO with 2003...

Steve,

I just posted a sample in which you get the dates and how many were consecutives. This is not a final query becuse the actual output was really not specified....

Assuming that you have a temp table with consecutive ids this may get you started :

Create table dtes( dte datetime , did int)

insert into dtes(dte, did) values('3/1/2005',  1)

insert into dtes(dte,...

Paula,

AFAIR the status column in sysindexes holds the information of IGNORE_DUP_KEY. at least it used to be like that in the early sybase days:

status & 1 = 1 ----> index...

If transactional Replication is not possible and log shipping is too slow you will have to either

1.try a third party solution like NSI Double-Take (the Software way)

or

2. use...

Are you Flushing the CACHE between the two batches?

menaning

dbcc dropcleanbuffers

dbcc freeproccache

How are you testing this ?

Can you Comment out the Last part ... SET XACT_ABORT ON till the end ?

SELECT COUNT(*) FROM HCD

      WHERE    HolidayDate BETWEEN @StartDate AND @EndDate

I has been my experience that a "Calendar table" is BY FAR the most flexible solution with the minimum MAINTENANCE! The Calculation of holidays...

If as you mention these are considered a unit of work the single sp approach is correct in my opinion because

 - Single Round Trip

 - Logical Grouping (From The App Point of...