Search results for query: *

Hi all, I have a setup where I have my server application in one domain, and the user account names are duplicated on 2 trusted domains (domain1 and domain2). When a user logs in to the application, I can see that the LookupAccountName win32 function is called to find the user acccount on the...

Hi there, I hope someone can help me here as this is driving me nuts...! Ok - I have an application which calls stored procedures from two machines: 1. Windows 2003, SQL 2005 2. Windows 2003, SQL 2000 If I call the stored procedure on server1, everything works ok. If the same stored proc is...

Hi all, I am trying to assign a variable the result of a query in a stored procedure. At the moment, the line is: select @reqid = (select o_reqid from swpro.staffo where o_casenum = @caseref) The SP should then insert the variable into a concatenated string and wriet this string to another...

Hello all, Hopefully someone can help me out here! I have a table which includes the following fields: Client_Ref, Client_Name, Partner_Ref Each client is either an end user or a partner. If they are an end user, their partner_ref references the client who deals with them by their...

Hello all! I have a very simple statement on a report which reads: =Sum(IIf([Current_Category]="A" & [Response_Met]=1,1,0)) This is to provide a count of those records in a table where the category is A and the response time has been met (=1). Perhaps I have overlooked something, or...

Help! I have a table which contains updates to support calls. I need a select query which will select the latest update to a support call - this will entail selecting only those records where the problem_id for each call is the highest. For example: Call_number Problem_id 1-1-1...

Hi all! In need of some more help.... I need to be able to join the contents of 3 different fields into one new field, as I'm trying to create call numbers, which are made up from the amalgamation of region_number, client_no and ref_no. (The rather deficient storing of this information...

Afternoon all! I'm trying to use the COUNT function to display the number of records in a group footer on a report where values in one of the fields = 1. In short, does anyone know how to specify criteria in a group footer using COUNT? I've looked briefly at using DCOUNT, but this gave a...

Hi all! Can anyone tell me why this simple join query is returning 0 rows? All I am trying to do is create a new table holding the required response times held in one table for various support calls held in another. The statement is: SELECT slaclienttable.*, [slatimes].[INITIAL_RESPONSE] INTO...