Search results for query: *

Thanks! You are correct. I found another insert in fact and when updated everything is working perfectly.

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

Sorry to bother. I answered my own question. Use an Inner Join: SELECT facstaff.FirstName, facstaff.LastName , Department.DivisionCode, Department.DeptCode FROM facstaff INNER JOIN Department ON Department.DeptCode = facstaff.Dept WHERE Department.DivisionCode = 'NS' ORDER BY LastName,FirstName

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

Hmmmm. Unfortunately the list of Recipients is not a query that I can pull from a database, it is rather dependant on business rules. But maybe I can loop through the comma delimited elements in the vTo variable. Will give it a try...

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

Perfect!!!!! Now how does it work? 1. What is happening with the 'qt'? How is that a part of the solution? 2. What is the difference between a case expression and case statement? I must have done something wrong for you to call my attention to this point. Thank you VERY much for your help...

We are getting closer. I am now getting a result set without Syntax errors when I give the @CurrTab and @CheckTab fixed values. I implemented the Case Statement as follows: SELECT *, Case When (SELECT Tabs.TabOrder FROM Tabs WHERE TabID=@CheckTab)<=(SELECT Tabs.TabOrder FROM Tabs WHERE...

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

Perfect!!! Works like a Charm!

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

Same issue. No error but no results

Same result: The Statements executes without error, but the results incorrectly show no results DECLARE @ProjID int DECLARE @ProjStatus varchar(10) DECLARE @StartDate1 smalldatetime DECLARE @StartDate2 smalldatetime DECLARE @EndDate1 smalldatetime DECLARE @EndDate2 smalldatetime DECLARE...

The statement is executed without error, but the results are wrong: If I search on a valid ProjectID only, there are no records in the results grid. Same thing if I search for a valid list of StatusID's. Could this have to do with the StartDate/EndDates (which are smalldatetime)?

I am trying to integrate this solution into the full code of the stored procedure and getting an error declaring the @ProjID variable. Am I implementing the Exec() style inappropriately?: DECLARE @ProjID int DECLARE @ProjStatus varchar(10) DECLARE @StartDate1 smalldatetime DECLARE @StartDate2...

Thank you! I am now getting the correct query results. What is the significance of the EXEC() statement? Why can't one run the SQL Statement with the string handling directly?

Yes, the StatusID is an &quot;int&quot;. Still getting data type error: Server: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value ' + RTRIM(LTRIM(@ProjStat)) + ' to a column of data type smallint.

Visio Enterprise used to be able to Round-Trip Engineer SQL Server DB until the MS Genious' decided to discontinue it. Sorry.

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