Search results for query: *

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

You might also look into Active Reports from Data Dynamics. I have used the standard edition to create and distribute PDF reports via the web. It did require some tricky asp and html because you have to save the pdf to disk on the server and then have the browser download the file. MSRP is...

It sounds like the query that DTS is calling to transfer the data is doing a group by on one or more of the nvarchar(4000) fields. I assume that you are trying to summarize the data as you are moving it. I would try moving the data to an intermediate table on the destination server without...

Hi cash0, SQL Server can only update fields of type text, ntext and image with approximately 120kb at a time. I'm guessing that you are using an ntext field, which holds unicode strings and each character is two bytes, so you are limited to approximately 64k characters. What you need to do is...

This will do what you want. Just change the values of the @RecordId and @NewValue variables. If you want to make it even easier, create a stored procedure. DECLARE @RecordId int, DECLARE @NewValue decimal(9,4) SET @RecordId = 123 SET @NewValue = 15 UPDATE tblA SET...

I think your problem is with Windows, not with SQL Server. You say the server name is CRM and yous loginid is CRM/Sam005. Is the windows CRM/Sam005 account defined as a local user on the server or is it a domain user defined on a domain controller? If it is a local user, then you will not be...