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!

Search results for query: *

  • Users: WayneGretzky
  • Order by date
  1. WayneGretzky

    Query not returning correct results

    the kind of output I expect to see is like this for example: 2006-01-05 16:47:22.000 error mmm 8668762739 2006-01-05 16:53:23.000 error mmm 8668762739 2006-01-05 17:15:26.000 error sss 8668762739 there is a unique id for each of those by the way...such as: 10000...
  2. WayneGretzky

    Query not returning correct results

    >>>To add, nowhere do you eliminate AMM and OK But I shouldn't have to, the sub select speficially looks for crc = 'error' and nothign else
  3. WayneGretzky

    Query not returning correct results

    The purpose of seeking results where there are 2 records with the same phone number that have crc = error is to notify our network guys of an error. They don't want to be notified if there is only one error record for a specific phone number.
  4. WayneGretzky

    Query not returning correct results

    ...does the same thing: select h.calldatetime, h.crc, h.projname, h.phonenum from dbo.history h WHERE ProjName IN ('sss' , 'mmm') AND (SELECT Count(*) FROM history WHERE CRC = 'ERROR' and phonenum = h.phonenum HAVING Count(*) > 2) > 2 AND (CallDateTime between dateadd(mi, -130, GetDate()) and...
  5. WayneGretzky

    SQL Authentification Settings not sticking for SQL Job

    In any SQL Server 2005 job I create on my server, if I specify SQL Authentfication to run that job, put the information in, then click OK to close, it never sticks. I open back up the job and it resorts back to the Windows Authentification Setting again. Is this a bug? Bad install? What?
  6. WayneGretzky

    No SQL Server Agent

    I just did a reinstall of SQL Server 2005 after backing up a database. I restored the database. I noticed I had to drop one of my users who still existed in sysusers because I needed to recreate that user in the new fresh install of SQL Server 2005. Ok, so I did that. If I logon to my...
  7. WayneGretzky

    Reader returning null values

    disregard, it was a problem with my stored procedure.
  8. WayneGretzky

    Reader returning null values

    I'm trying to figure out why the Variable CustomerName is null. I need to verify if my syntax for all in this Sub is formed well: Sub SendEmail_ElBalazo() Dim mailObj As New MailMessage Conn.Open() Dim myvalue As Integer = 1 Dim cmd As SqlCommand = New...
  9. WayneGretzky

    Share out a Stored Procedure output parameter with other subs

    latest code is here: www.photopizzaz.biz/allcode.txt remember, I can't pull out NewCateringOrderID = New SqlParameter("@NewCateringOrderID", SqlDbType.BigInt) from my InsertOrder() or it throws an error saying I haven't declared NewCateringOrderID
  10. WayneGretzky

    The connection was not closed. The connection's current state is open.

    thanks, I actually had 2 opens for Conn prior to posting this and I was updating the wrong file so I didn't see the changes I made which actually fixed it.
  11. WayneGretzky

    The connection was not closed. The connection's current state is open.

    I'm not sure why I am still getting this connection error www.photopizzaz.biz/allcode.txt
  12. WayneGretzky

    Share out a Stored Procedure output parameter with other subs

    Here's my latest code from my code-behind page: Public Class catering_form Inherits System.Web.UI.Page some code... Dim NewCateringOrderID As SqlParameter ...some more code Public Sub InsertOrder() Conn.Open() cmd = New SqlCommand("Add_NewOrder", Conn)...
  13. WayneGretzky

    Share out a Stored Procedure output parameter with other subs

    ok, but now I get this error: Exception Details: System.FormatException: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Source Error: Line 292: Dim cmd As SqlCommand = New SqlCommand("sp_Get_OrderDetails", Conn) Line 293...
  14. WayneGretzky

    Share out a Stored Procedure output parameter with other subs

    how can I make the value for the output parameter below available to all my subs in my code behind class? This is in one of my Subs but I want to share it out: Dim NewCateringOrderID As New SqlParameter("@NewCateringOrderID", SqlDbType.BigInt) NewCateringOrderID.Direction =...
  15. WayneGretzky

    Date Problem, not pulling correct dates

    I think I found it, I had 2 extra ) in an OR statement in my query. Thanks though for replying.
  16. WayneGretzky

    Date Problem, not pulling correct dates

    the portion of my query was working fine, nothing has changed except that I went from 30 to 20 for the dateadd function. Now when my query runs, I get CallDateTime that is not between the current time and 20 minutes prior, I get CallDateTime that is even from a month ago which is not right...
  17. WayneGretzky

    Subquery returned more than 1 value. This is not permitted when the su

    Thanks, worked great. Can you possibly explain to me why I had to do it that way instead of reference the single fieldname?
  18. WayneGretzky

    Subquery returned more than 1 value. This is not permitted when the su

    ...where CRC = 'error') > 1)) OR ((CRC = 'NOCPA') OR (CRC NOT IN ('AMM' , 'OK'))) AND CallDateTime between dateadd(mi, -20, GetDate()) and Getdate() /*checks for any records within the last 30 minutes of the current server's time*/ AND PhoneNum LIKE...
  19. WayneGretzky

    Cannot connect to Database in Server Management Studio

    I currently can't connecto to my database in SQL Server 2005 (enterprise) but as soon as I try to use any functions, I get cryptic errors found below. I am about to pull my hair out. Everything was working fine for around 4 days and now everything just blows up. I've tried using both sql...
  20. WayneGretzky

    Problem with connecting to login in SQL Server 2005

    ...I am wondering if just VS can't handle it in debug mode or what the real problem is here: <appSettings> <add key="Econn" value="Server=****;uid=testit;pwd=***;database=integration_services_en;"/> </appSettings> ERROR: Cannot open database "integration_services_en" requested by the...

Part and Inventory Search

Back
Top