trvlbabie (2/16/2016)

---

When I add the line: SUBSTRING(String, 10, 5)

It is giving me the following error: SQL API: [SQLExecDirectW], SQL RETURN: [-1], SQL STATE: [42000], SQL NATIVE ERROR:...

Just another option.

SELECT

StartTime = DATEADD(HH,-6,CAST(CAST(GETDATE() AS date) AS datetime)), -- 6PM yesterday

EndTime = DATEADD(HH,6,CAST(CAST(GETDATE() AS date) AS datetime)); -- 6AM today

You have several options. You can play with substring and charindex if the first items have variable lengths, or you could split the whole string and take the part you...

For this particular case, there's a simpler solution using common date routines[/url]

SELECT

StartTime = DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), -.25), -- 6PM yesterday

EndTime =...

ChrisM@Work (2/16/2016)

---

SQLRNNR (2/16/2016)

---

jasona.work (2/16/2016)

---

I'm leaning towards the Palpatine / Vader ticket myself...

Or if they don't make it, Bill and Opus...

(I refuse...

ripas (2/16/2016)

---

Hello,

I am trying to run one stored procedure and it failed to run. And I got this error message when I was trying to execute. How could I solve...

Wayne

My suggestion is something that should be tested really carefully. It involves a technique called Quirky Update which is very fast but unreliable when not done properly. All the information...

Lynn Pettis (2/16/2016)

---

The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants of the...

Hugo Kornelis (2/16/2016)

---

GilaMonster (2/16/2016)

---

Likewise. With a side of terrified that one of the buffoons...

Eve

SSIS won't work with temp tables. I'm not sure if table variables are an option or will cause the same error. The safest way is to create perm tables in...

:sick:Oracle:sick:

Eirikur,

Any reason for using FLOOR on an integer division?

If you're not using any calculations or functions in your join conditions, and you don't have an implicit conversion going on, you're probably reading the whole table or most of...