Search results for query: *

I am trying to execute a SQL Job with a cursor, and it fails when I add the usertypes.usertype field and @utypeXYZ variable. The error message is: "Cursor fetch: The number of variables declared in the INTO list must match that of selected columns." Here is the snippet of code I am...

Assuming 3 tables: Division (DivCode, DivName) Department (DeptCode, DivCode, DeptName) Professor (FName, LName, DeptCode) How do I write a query to return a listing or professors by Division? So far I can only write queries that return Departments based on Division or Professors based on...

I have Windows XP Prof and Outlook 2000, both with any all patches available from MS. I also have Norton Antivirus 2002 Edition with LiveUpdate fully updated. Symptoms: 1. I have noticed that whenever Outlook is invoked it pegs my CPU to 96+ percent in task manager. 2. When Outlook loads, it...

I need to send an email to multiple recipients using the JMail component. The list varies based on numerous business rules, so it is more effective to dynamically build this list of recipients and store them in one variable. If X Then vTo = getemail(staffid1)&&quot...

I am creating a wizard and have a tabs table to dynamically build navigation. I need to return a recordset with an Active/Inactive Value for each record (tab) to render the tab in the appropriate format. I have 2 queries, one to return the records, and a second to determine Active/Inactive...

Hello, I have some ASP background, but now am trying to work in Cold Fusion. From this query I am getting a recordset that contains the field .KeepPrivate <cfquery name=&quot;student&quot; datasource=&quot;#request.mygordon#&quot;> SELECT * FROM student WHERE id = '#gordon_id#' </cfquery>...

I am new to SQL Server. I have a form that allows the user to select one or more status values for a project search (The user can search for all projects that are 1> Cancelled 3> Deferred 2> Closed). These selections are passed to my search stored procedure currently as a varchar comma...

I am trying to generate an online report where the user can select ASP or XL output. When the HTML Output is selected, the ASP executes without issue and is rendered. When the &quot;XL&quot; value is passed, this line of code inserts the response.ContentType statement that I was expecting...

I need to be able to audit changes made on a form. Changes to each field must be reflected in the audit trail. Rather than writing a seperate SP for each of the 30+ fields, I would like to know if the Update statement could be written dynamically by passing parameters to a stored procedure...

I guess one should never go on vacation! A week ago I wrote the following stored procedure and it successfully returned the new/updated record: CREATE PROCEDURE proc_SetProjAssignment @ProjID int, @ITStaff varchar(50), @EstManHours smallint AS /* Search for existing records with...

I guess one should never go on vacation! A week ago I wrote the following stored procedure and it successfully returned the new/updated record: CREATE PROCEDURE proc_SetProjAssignment @ProjID int, @ITStaff varchar(50), @EstManHours smallint AS /* Search for existing records with both Staff ID...

I am a javascript newbie and have what hopefully is an easy question: I am working on a web app with the following: ProjResc.asp calls iProjstaff.asp through an iFrame. Either ProjResc.asp or iProjStaff can call Projassignment.asp which is a pop-up form that updates a database. When I do a...

I need to get an output that combines values from 2 tables based on StaffID and ProjectID. From the Timesheet table I need the total number of hours a staff spent on a project. From the Assignment table I need to show the estimated hours per staff. From the Staff table, I need to show the...

Does anyone know how to query data from one database to a another in real time? For example: Database 1 has a table called People and a field called PersonID Database 2 has a table called Employees and a field called EmployeeID I want to build an SQL Statement something like this: SELECT...