your update query is written wrong. It should be:

update T2 set col1 = T1.col2

from table2 T2

JOIN table1 T1 on T1.col1 = T2.col2

also, as others have stated, if your real data...

To answer your question with a question: Why would you want to do this?

You can compile a .net application for 32 bit or 64 bit or both environments. The...

Koen (da-zero) (1/6/2011)

---

p.s.: sometimes it's pretty funny. In Belgium we have subtitles under the movies. The translation is usually a cleaned-up version of the original text. Hilarious when I was...

Now wait a second... I resemble that remark.

I think GSquared has a valid point. How *can* we determine the validity of a comparison between...

what is the difference between Watermellon and Tuna I ask you???

On the one hand they are both edible items, originating from life forms and bring forth nourishment. On the other...

I would use separate databases that would give you more flexibility in terms of optimizing and scalability.

I'd consider keeping the static data and application settings in the same database though.

You have several issues with that trigger. The inserted table is known only to the trigger - plus you have multiple commands in the your dynamic SQL statement, you need...

I do not see where the test3 table is being properly joined to the other two.

First thing I would recommend is to re-write the query using standard join syntax.

A view might be appropriate, it would depend upon the size/complexity of the base query.

If I needed to perform multiple queries against this data set then I would want it...

sounds like a homework assignment.

Parthi had it pretty close:

try this:

Select

Student.LastName,

Student.FirstName,

StudentClassroom.SCRID,

sum(Case When attendance.present = 1 THEN 1 Else 0 END) as Attendance

from Student

join

StudentClassroom

On Student.SID=StudentClassroom.SID

Join attendance

on attendance.SCRID=StudentClassroom.SCRID

group by Student.LastName,

Student.FirstName,

StudentClassroom.SCRID

First let me say that I do not use the built in log shipping methods. I create my own so that my procedures and audits are consistent from SQL version...

What method are you using to keep them "in sync" ? You can set up an agent job on one or both of the servers to audit the state...

ASDL (12/14/2010)

---

What do you mean "most if not all of the columns and the order nor the exact number is important"? When I do SELECT * FROM a table I...

I am not sure what method you are using to export the data, but one way is change the dates to an empty string when they are null.

something like:

select ...