Looks to me like you need to add additional space to your system.

michael.albert (3/22/2012)

---

i am lucky i work in an environment that really doesn't run 24/7 (education) - i typically work 40 hours (though i sit at my desk during lunch due...

Well, you would have gotten tested code if you took the time to read and follow the instructions in the first article I reference in my signature block below regarding...

Are you trying to use this? From the small fragment provided you are not going to get very good answers, just shots in the dark.

When you run the SSIS package in BIDS, is this on the server itself or on a separate PC (workstation)?

Let's start by having you read the two articles I reference below in the 5th line of my signature block regarding Cross Tabs and Pivots.

Chrissy321 (3/21/2012)

---

Thank you both.

Someone around here has something in their signature that says something like don't use code you don't understand. I don't understand the split function although I bet...

ColdCoffee (3/21/2012)

---

Lynn, as we know the exact positions of the hyphen, i dont really think we would need...

ColdCoffee (3/21/2012)

---

Lynn, as we know the exact positions of the hyphen, i dont really think we would need...

I'd say it depends on how the CASE function is being used. In this case it is being used on the right side of the equality condition and will...

Dumb question, is the SQL Browser service running on the server?

Here is another way to do it:

CREATE TABLE #Test (TestColumn varchar (24))

INSERT INTO #Test

SELECT '123-3456-789-987-65' UNION

SELECT '223-13446-789-987-65' UNION

SELECT '323-16-789-987-65' UNION

SELECT '423-45454516-789-987-65'

select * from #Test;

select

t.TestColumn,

...

If you look at the part I made bold, the query timed out. With that I would say you need a longer timeout period for this to work. ...

How about giving this a try:

SELECT

t.ProductionDate,

t.Shift,

t.LineNumber,

t.Cart,

t.CavityPosition,

t.ProgramNumber,

...

First, if you look at the code below again, you will find a logic error:

IF @now BETWEEN '06:40:00' AND '14:39:00'

SELECT ProductionDate, Shift, LineNumber, Cart, CavityPosition, ProgramNumber, PartNumber,Cavity

FROM tblTransactiondetail WHERE Shift...