If you develop projects in VS2012, you probably get an error when you try to open them in VS2010 (I tested it a year back and as far as I...

You can run the SQL Server set-up, but install only the client tools.

Thanks for the question. I didn't know about this limitation. (because who comes up with a 116 character table name?)

My avatar is currently gone as well.

Also, the subject line of the notification mail is suddenly full of strange characters.

Lynn Pettis (8/20/2014)

---

This isn't so much a error, but an informational warning that it may take a bit to open the package and the editor may be slow.

I have had...

Come on, a little effort please. John has linked to the documentation of substring. Read...

At this point, it might be useful to show us some screenshots and maybe some table DDL so we can provide more specific assistance.

Ells (8/20/2014)

---

The lookup either feeds an insert or update OLEDB commands. With this data set I foresee a couple of million inserts on the new day, then regular small number...

Nice question, thanks.

You need to use a simple trick:

Fname:= LEFT(8,Fname + "--------")

A similar expression can be build for Qty.

Not out-of-the-box. Maybe if you hack into the CSS/HTML.

romina (8/19/2014)

---

Thanks Koen and Phil,

I haven't got too far with this. Still struggling to load the data. I am not sure what else to do. It's getting to my nerves.

Any...

ScottPletcher (8/19/2014)

---

My preference would be this (the "extra" parentheses are important to properly match the requirements):

SELECT *

FROM YourTable

WHERE (SnapshotDate > @from AND SnapshotDate < @to)

OR (SnapshotDate =...

David Burrows (8/19/2014)

---

Koen Verbeeck (8/19/2014)

---

higgim (8/18/2014)

---

Not a happy chap with some of the help being offered! Go figure 🙂

Qira (8/18/2014)

---

Dear Mr Higgam,

You're helping me sir. Thanks to you. But no...

Try this:

SELECT *

FROM Table

WHERE DATEADD(HOUR,HourKey,CONVERT(DATETIME,CONVERT(CHAR(8),SnapshotDate),112)) BETWEEN @from AND @to;

You did not provide any table DDL and sample data, so I could not test this query.