OK, bringing som ehumour to the forum...

A couple days ago, in the QOD thread, a forum user remarked that really what the question was about was purely semantics. Brian...

There are transaction log viewer utility applications out there that allow you to see thi ssort of information. Lumigent's Log Explorer is one such tool.

You think we could see the code?

Not that this thread isn't too belabored already, but I just wanted to point out that in most cases, it is much more efficient to have a normalized solution than...

OK, you cannot reference a MS Access Form field value in SQL Server Query Analyzer. Are you executing this string exactly?:

Exec UpdateInfo '3526'

Not quite sure what you are referring to with :how a table is read in code". Do you mean table/index hints? or the ADODB.Connection/Command objects' inherent CursorType, CursorLocation...

Do a quick MsgBox(Forms!frmEmployee!txtEmpID) when you execute this function to ensure that there is a correct value in the field at runtime. If there is, then MsgBox out the SQL...

You didn't copy my code quite right. You left out the quotes, which indicate that the @sql variable is a string:

...

SET @sql = 'SELECT *...

Are you trying to insert a UNICODE character into a VARCHAR field?

If you post your code, we'll be able to see the error more clearly...

quote:

---

Set @EmpID = '1%'

Select * from tblEmployee where EmpID = @EmpID

This will return all Employee ID's that begin with a 1, but...

stax68,

the problem is that your code will aggregate the COUNT(DataID) will not return a count of all questionnaire records, but just the count of the questionnaires in the group keyed...

quote:

---

SELECT account_id, bill_contact, bill_address,bill_method = Case

When 'CC' Then (SELECT CC_Number, CC_TYPE, CC_Exp FROM credit_card)

FROM account

WHen 'ZZ' Then Do something else

End as 'The...

This is not what the poster is asking for. They are requesting that in the same query, return both scalar and non-scalar aggregates, ie count of all and also...

quote:

---

another way is just to do a select

left(getdate(),12) - does return it as a varchar though

---

June 19, 2003 at 6:38 am