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...

After reviewing your SQL again, I can offer up a similar solution as what I previously provided. Without knowing much more, I cannot say this would provide the most optimal...

I would love to help, but do not quite understand what your expect from this new query. What is your desired output? Also, what are the table relationships between FeeChequeStatus...

One note of caution I forgot to mention in previous post is about performance. If the tables are very large, another solution may be required.