Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by developer77

  1. developer77

    buildlistbox function

    Hello everyone, I dont' even know if I'm in the right forum. I think the language I'm working w/here is asp, not sure. I have the following line in an asp file: <% Response.write BuildListBox2("<- Select Value ->", sp_GetStudentType", DB_CONNSTR_STUDENT, "Type", "","", false) %> I also...
  2. developer77

    order by using CASE

    Thanks SQLBill and mharroff. I tried what you suggested mharroff and it worked...thanks again!!!
  3. developer77

    order by using CASE

    Hi Bill, thanks for your reply. I changed it to the following but it still won't work. I get the same error message. Does CASE statements allow you to specify more than one column? ORDER BY CASE @SortColumn WHEN 1 THEN p.LastName, p.FirstName WHEN 2 THEN...
  4. developer77

    order by using CASE

    Hi everyone, I have a stored procedure that has the following sort by section and @SortColumn is one of the passed parameters: ORDER BY CASE @SortColumn WHEN 1 THEN p.LastName WHEN 2 THEN p.Address WHEN 3 THEN p.Year ELSE NULL...
  5. developer77

    please help with case statement

    George, thanks for your help...it works!!! Sorry I misunderstood it the first time...
  6. developer77

    please help with case statement

    Hi George, Thank you for your prompt response. I think the code you provided will work but if I don't enter any parameters for degree, I want it to be able to pull all records in the degree column including null. It looks like the code you provided will either pull based on the paranter...
  7. developer77

    please help with case statement

    Hello everyone, I have the following stored procedure that passes a @degree paramter: CREATE PROCEDURE students_enrolled ( @degree = null, @ = null ) AS -- BEGIN SELECT s.FirstName, s.LastName, s.MiddleName, e.student_id...
  8. developer77

    please help with date range

    Hi Catadmin, That was what I thought the code was doing but the start and end date parameters I plugged in (@StartDateRange = 12/01/2006 and @EndDateRange= 12/10/2006) does fall between the 2nd date set in the database 11/30/2006 and 12/10/2006 but that record is not being pulled. Thanks, Sara
  9. developer77

    please help with date range

    Hi catadmin, thank you for your responses. The date sets are for different students. I think the startdate shouldn't match to anythign but just serves as a bases for the date range comparison. I would like to pull any dates between the parameter range that falls in the start and end dates in...
  10. developer77

    please help with date range

    Hello everyone, I have the following stored procedure that passes the start and end date range as parameters. I'm trying to pull all date ranges from the parameters based on the start date and end date of students enrolled. For example, I have the following start dates and end dates in the...
  11. developer77

    Crystal APS service is not starting

    Hi everyone, I was trying to run some reports off the web application today and got the following error: Communication Error Communication failed with all configured Web Component Servers because they are disabled or not currently running. If this problem continues, please contact the system...
  12. developer77

    Please help with datetime conversion

    Thank you both for your assistance.
  13. developer77

    Please help with datetime conversion

    Hello everyone, I have a stored procedure where I declare the start and end dates as datetime. @StartDate datetime = null, @EndDate datetime = null, @SortColumnID Int = null Then at the end of the stored procedure, I sorted it as follows: ORDER BY CASE @SortColumnID WHEN...
  14. developer77

    Please help with dates

    Thank you all very much for your valuable advice...
  15. developer77

    Please help with dates

    Hello everyone, I've pasted a part of my stored procedure below: -- Declare month, year DECLARE @Month int DECLARE @Year int -- Initialize SQL environment SET NOCOUNT ON SET CONCAT_NULL_YIELDS_NULL OFF -- Strip off the time part of the date. SELECT @Date = substring(convert(varchar...
See more

Part and Inventory Search

Back
Top