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 derfloh 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 free47

  1. free47

    Sharepoint Survey

    Yes, you want to create a branch and if they click a certain answer then you would branch to the type of comment/question you would want to ask after that.
  2. free47

    Create a stored procedure with a select inside

    That worked perfectly! how is it always the easiest part of the query gives me a hard time! THANKS!
  3. free47

    Create a stored procedure with a select inside

    I am saving a password in VarBinary in my database. Now I am trying to authentic if the username and password typed in was correct. I am trying to do it in the where clause and take the password the user enters and check it against the binary saved password. It won’t let me do a sub select...
  4. free47

    SP Counting Advanced

    Borislav, thanks again, you really are the SQL expert!!! Thanks for helping others learn! :-)
  5. free47

    SP Counting Advanced

    I am looking at this example query and dont see how it would fit into my query. SELECT LastName, FirstName FROM (SELECT * FROM Employee WHERE State = "NY") AS EmployeeDerivedTable WHERE LastName = "Smith" ORDER BY FirstName This is my query before i put in the derived table...
  6. free47

    SP Counting Advanced

    I am trying to make a stored proc that will count the number of times each company comes up but keep the number of times the company comes up. Here is an example of my data set. Company | ID | Topic | Details 1 25 RD TBD 1 25 RD TBD 2...
  7. free47

    SP Counting

    I am trying to make a stored proc that will count the number of times each company comes up. Here is an example of my data set. Company | ID 1 25 1 25 2 26 3 27 3 27 3 27 I want the final result of the query to...
  8. free47

    Stored Proc Help

    Thanks, now it works perfectly! This wasn't an easy SP and i think i just got frustrated looking at it after a while...
  9. free47

    Stored Proc Help

    Thanks, i tried it both ways and it keeps giving me the same two errors: Msg 8155, Level 16, State 2, Procedure rpt_summaryDataNew, Line 7 No column was specified for column 3 of 'source'. Msg 207, Level 16, State 1, Procedure rpt_summaryDataNew, Line 29 Invalid column name 'topic'. This is...
  10. free47

    Stored Proc Help

    I am trying to update this stored procedure that is using a pivot table, but for some reason I can’t get it to display like I need. It should add up when customer escalated = 1 but needs to count separate and not be in a case statement as it then doesn’t count the topic correctly. When I put it...
See more

Part and Inventory Search

Back
Top