itpcpro (11/9/2011)

---

Thanks John, Yeah that would be jobs that run before 7am... So 6:59:59 would be the ending point and I have another job that would pickup at 7:00:00 and...

itpcpro (11/9/2011)

---

This does work if I run the job at 7am.. But what if I run the job at 10am or 1pm... I still only want the jobs that ran...

I realize this statement has a lot of date functions, but it will return a datetime for the day before at 5 pm.

DATEADD(hh, 17, DATEADD(dd, DATEDIFF(dd, 0, GETDATE())-1, 0))

I have seen this used many times as well. It basically satisifies the syntax requirement of the "JOIN" clause without any joining fields. Produces same result as a "cross join".

applebyte (11/9/2011)

---

thanks for the reply. Adding the single quotes allowed the 'parse' check to be successful but when the code was executed, a syntax error occured.

--

Msg 102,...

it appears this is a case of needing to "embed" the single quotes within a quoted string. Anytime a sql statement is embedded in a "string" all items normally single-quoted...

In your example, use "NOT LIKE" instead of "<>".

Does this correct the issue?

Well, I suppose it would be preference. I would say in your situation that the import/export wizard may be a faster method to get the data copied. If you are...

Breakwaterpc (11/8/2011)

---

However, one more issue with these tables. I know need to update part of a string that i placed in several different columns in the Subjects table....

Breakwaterpc (11/8/2011)

---

For some reason, i'm getting all twisted up and bumfuzzled here.

First off, where is this variable "NewValue" getting used once it's cast? Doesn't appear anywhere in the...

Also, when you concatenate the data together, do you require any separators such as a Space or Period?

Here is a sample to get you started.....

USE CIVIL

GO

UPDATE r

SET comments =...

Just for reference, this SQL has the correction to the syntax error you received. Parantheses were missing around the select statement in the SET.

DECLARE @CountValue INT

set @CountValue= ( SELECT COUNT(ProductID)

FROM...

LOLCatLady (11/2/2011)

---

Hi, I'm new here and hoping someone could give me direction on how to make this code work.

The INNER JOIN below with the select is pulling the correct data,...

Based on your query, all three...

Where I work, I started this same type of operation based on suggestions of other people while our tables were smaller. After a while, I realized this was not the...