What if I needed to use Wildcards in my OR conditions:

SELECT firstname, lastname from Teacher_data_main

WHERE

(Firstname like 'F%'

or

Firstname like 'B%'

or

Firstname like 'C%')

AND

Schoolnum = 371

Thanks!

CSDunn

Thanks for this input. I have seen this technique before, but I will document it this time.

CSDunn

Exactly. In this case, I took the records I intended to delete, and inserted them into a 'backup' table. Also, I worked through the senario working with the data in...

Thanks for your help! I had not used Delete in this way before, and so I took a look at BOL after performing the Delete.

CSDunn

I was looking for and  idea  make a report in a client application work, but I have come up with another idea that will incorporate two cross-tab SQL Server reports that...

IDENTITYCOL...That's what I was thinking of, and I was not able to find this in BOL. I was able to find it in the MS Press book 70-229.

Thanks for your...

Thanks for the link to further details on how to set this up. As it turns out, security on the objects in the Access database were not being enforced. I...

Thanks for your help!

CSDunn

Thanks for the resource!

CSDunn

'WITH VALUES'  is what I was looking for! I had seen it before, but I could not locate this in BOL.

Thanks for your help!

CSDunn

Thanks! As it turns out, I had tried setting the fields equal, but was using a 'DateEntered' field that was set up as a default of GETDATE() on the table...

Never mind, I got it:

"TestScore" = 100 * SUM(CAST(TS.Score AS INT))/COUNT(TS.Score)

quote:

---

I believe that select into is a non-logged operation.

---

I think SELECT INTO...

quote:

---

When you use "(" in the FROM clause, you HAVE to ALIAS the inline view!!

---