Search results for query: *

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.

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

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

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

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

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

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

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

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

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