Recent content by billchris

Another option depends on the permissions of your users. If they don't have sysadmin or db_owner permissions, you can DENY SELECT permission on the table and then write a stored procedure to do selecting on that table. You can log whatever you want in the stored procedure. “I apologize for...

CREATE PROCECURE GetQuestions @QuestionCount int AS SET ROWCOUNT = @QuestionCount SELECT ID, Question, Answer FROM RefresherQuestions WHERE (((RefresherQuestions.[Plant Section ID])=2)) ORDER BY RND(ID) GO You will have to prompt your user before calling the stored procedure...

SELECT ISNULL ( ( SELECT MIN(A.CODE) FROM TABLE_A A, TABLE_B B WHERE A.VALUE >= B.VALUE ), ( SELECT MAX(A.CODE) FROM TABLE_A A, TABLE_B B WHERE A.VALUE < B.VALUE ( ) “I apologize...

I would try placing a second, unbound, checkbox on the form. Make the bound checkbox invisible. Then use the visible checkbox to display the opposite of the bound checkbox and to update the bound checkbox behind the scenes. I might get hairy to keep track of the events, but then it might be...

The view that you are selecting from, INFORMATION_SCHEMA.constraint_column_usage, only displays records from tables for which the current user has permissions. Check to make sure the user that you are connecting with has permission to use/see the tables in question. “I apologize for this...

That would be something like this: SELECT t1.id, <other t1 fields>, <t2 fields>, <t3 fields> FROM table1 t1 inner join table2 t2 ON t1.id = t2.id inner join table3 t3 ON t1.id = t3.id WHERE t2.<conditionField> = <table2 condition> and t1.<conditionField1>...

It's been my experience that as soon as the client application connection is lost to SQL Server, the database automatically stops and rolls back any active transactions created by that connection. Am I missing something? I can think of one scenario where your problem might occur. Let's say...

Matt, You can use DateAdd to add seconds to 0 and convert the result to a string in the format hh:mm:ss. select Convert(nchar(8), DateAdd(s,Avg(length),0),8) as 'avg call length' from callHistory This will work as long as the avg call length is less than 13 hours, because format...

Ok, is this more what you are looking for? SELECT t1.id, <other t1 fields>, <t2 fields> FROM table1 t1 inner join table2 t2 ON t1.id = t2.id WHERE t2.<conditionField> = <table2 condition> and t1.<conditionField1> = <table1 condition 1> and...

sivi, I usually jump into these questions without enough information and end up answering the wrong question based on invalid assumptions. So, this time I'm going to try something different and clarify. You have an audit table that looks something like this, correct? Audit --------...

cash0, Thanks for the reply. I should have mentioned that I had never tested that code, I just derived it from Microsoft's documentation. I apologize for that. <Sarcasm> I can't believe their documentation was wrong!!! </Sarcasm> I'm glad it was some help, though. --Bill “I apologize...

Check out DCOM on MSDN at http://msdn.microsoft.com/library/en-us/dndcom/html/msdn_dcomtec.asp?frame=true. “I apologize for this long letter. I didn't have the time to make it any shorter” --Blaise Pascal

gazal, First off, you need to modify your table structure a bit. Right now you have these three entities,Login_DetailsParent_Menu_MasterChild_Menu_MasterWhat you need is this,Login_DetailsMenu_MasterRoleLogin_RoleMenu_RoleThe Login_Details table can remain the same, but here are the fields for...

The Sql statement that you are executing does not return any records. That's why the rs cannot be closed, it was never open. If Sql Server does not return anything to ADO, it doesn't need to open a recordset, so it won't. You should use a Command Object or the Connection.Execute method to...

Maybe, try this SELECT t1.id, <other fields> FROM table1 t1 inner join table2 t2 ON t1.id = t2.id WHERE t1.fieldx = <some condition> UNION ALL SELECT t2.id, <other fields> FROM table2 t2 inner join table1 t1 ON t2.id = t1.id WHERE...