It can depend upon the situation. If you have two or more applications using substantially the same dataset - I'd consider that fair enough. If you mean one...

Glad you got it sorted - and appologies for the abysmal typing btw

lrosales (9/10/2008)

---

Y'all

🙂

I need an extra set of eyes looking into this procedure I am attempting to create. can someone see what I am Missing. keep getting an error on...

rbarryyoung (8/1/2008)

---

Off-hand, it sounds like it is having to expand the...

Have you had a look at the query plan to see ohw your queries are being executed by the optimiser? Generally, my personal preference is to use DT's rather...

Bill of Materials (BOM) is the hierarchical structure of how a product is put together.

So, if you have you finished product WidgetA

Which is made up of two PartAs and 1...

I did mean Sarbannes/Oxley. It came up in some articles I was reading about database design so I was thinking how it may apply to the schema I am designing....

If you have Visual Studio DB Pro edition, you can download the free powertools add on which gives you the facility to compare two databases and generate scripts to deploy...

It’s all about the right tool for the job and what is acceptable performance wise. Sure there are other ways of accomplishing the same thing. If the WHILE...

Basically - cursors are evil.

Never, ever, use one unless it's absolutely 100% unavoidable. It is in the vast majority of cases, one way or another.

Thanks to those who has a look at this one - just in case anyone's wondering I've sussed it (ish).

Basically - looks as if it may have been some kind...

Branching or Looping? Perish the thought :w00t:

Very straightforward update:

DECLARE @tblHolding TABLE

(

OutcomeIDINT,

Event_DateDATETIME,

EVENT_TIMEDATETIME,

CustomerIDNVARCHAR(40),

RecordPenetrated BIT

)

INSERT @tblHolding

SELECT

vwNonContactOutcomesNew.OutcomeID,

vwNonContactOutcomesNew.Event_Date,

vwNonContactOutcomesNew.Event_Time,

vwNonContactOutcomesNew.CustomerID,

vwNonContactOutcomesNew.RecordPenetrated

FROM

vwNonContactOutcomesNew

UPDATE dbo.CustomerFact

SET

OutcomeID = HoldingTable.OutcomeID,

LastContactDate = HoldingTable.Event_Date,

LastContactTime = HoldingTable.Event_Time,

RecordPenetrated = HoldingTable.RecordPenetrated

FROM

dbo.CustomerFact

INNER JOIN

@tblHolding AS HoldingTable

ON dbo.CustomerFact.PhoenixCustomerID = HoldingTable.CustomerID

You can download 2005 DTS designer from

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Actually attempting to do matches and searches on the content of the files themselves is - realistically - infeasible. What you'd be looking for would probably be setting up...

mxwebb (7/16/2008)

---

What I am trying to do is:

Go to directory that has a bunch of Flat files.

I need to pull the data from each file and insert it into SQL...