Also when I ran it under Business management studio, the package worked.

It did not work when I ran it in the job.

I have the same problem but I ran it as SSIS package.

It kept saying it did not recognize the connection on the input file //server/filename.

Jeff

Why don't you post your 'perfect' answer?

As a woman in IT, I can say that the hours are not conducive to having a family. I am a single mum so I certainly cannot do extensive overtime...

Totally agreed. I used to work at a company with a lot of smart people. I was so happy to go to work...

I think it may contribute to some companies trying to cut budget and make employees to wear different hats. In the past, I worked in a company that had...

Imagine this.. You work in a medium sized company, using MSSQL2005 and nothing else.

They are very tight on budget, try to be productive, focused and specialised, unlike government orgs and...

The data in that table remains the same. That meant the data in the production table did not come over to test. All tables have the same permission.

This table exists in both test and production.

What puzzled me is it happened to this one table only.

The backup is a full backup and the recovery mode of the test database is simple.

My old company used to outsource to HCL. After a couple months, every developer in the company refused to work with them. Every time they sent us the codes,...

matt, do you mind to share your cv template? 😛

I assume participant is the same as member according to the data that you provided.

UPDATE p

SET OriginalStart = m.Startdate

FROM Participant p

INNER JOIN Member m ON p.Participant = m.Member

WHERE p.Spanstart between...

Try this

DECLARE @ticket_count Integer

OPEN TicketUpdate

FETCH FIRST FROM TicketUpdate INTO @BT_ID,@ST_ID,@PRODUCT_CODE,

@PRODUCT_MAJOR,@PRODUCT_MINOR,@QUANTITY_ORDERED,@DATE_ENTERED,@DATE_UPDATED,@ORDER_NUMBER,@ORDER_DATE,@SOURCE_CODE,@LAST_TICKET_NUMBER

WHILE (@@FETCH_STATUS = 0)

BEGIN

set @ticket_count = 1

While (@ticket_count <= @quantity_ordered)

BEGIN

BEGIN TRANSACTION

insert into TicketTable (SEQN,ID,ACTIVITY_TYPE,DESCRIPTION,PRODUCT_CODE,TRANSACTION_DATE,SOURCE_CODE,F_1,F_4,F_5)

values (@NEXT_SEQN,@BT_ID,'TICKET','Ticket',@PRODUCT_MAJOR,@ORDER_DATE,@SOURCE_CODE,@PRODUCT_CODE,1,@ORDER_NUMBER)

COMMIT TRANSACTION

SET @ticket_count = @ticket_count + 1

END

FETCH...

So if the page count is less than 100, even the fragment in percent is high, I don't have to worry about it?