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!

Search results for query: *

  1. dfs8463

    Selecting BETWEEN Dates

    Hi John Thank you for replying The trnDate column is datetime, and there are never any NULL values. I tried again, leaving the code as is for reference, and, wonder of wonders, it seems to have worked now. To clarify, the code that took forever is now working in a flash, with NO changes made...
  2. dfs8463

    Selecting BETWEEN Dates

    Hi I have a problem selecting records from a transaction table for a specific period. The query goes like this: DECLARE @d1 datetime ,@d2 datetime SET @d1 = '1/Jan/2012' SET @d2 = '11/Jan/2012' SELECT DISTINCT BuyerName FROM TransactionsList WITH (nolock) WHERE trnDate BETWEEN...
  3. dfs8463

    VB6 and SQL Server

    Parameter sniffing was the culprit!
  4. dfs8463

    VB6 and SQL Server

    Hi George Still there? Merry Christmas. The query problem re-occurred :( Again, the SP runs smoothly (and fast) in a query window but NOT via VB (6 and .NET)! sp_who2 does not show anyone in the BlkBy column. My deadlock detector shows nothing of interest. As it's holiday season, usage in...
  5. dfs8463

    VB6 and SQL Server

    Thanks George I keep forgetting the sp_who2 'utility' as my clients would be panicking at the time! I normally have an SQL Deadlock Detector running, but it never shows anything at that moment. And I don't really run any big updates. May I remind you that when I bring up a regular SQL Server...
  6. dfs8463

    VB6 and SQL Server

    Hi Excuse the late reply. The connection string is: Provider=SQLNCLI.1;Password=pass123;Persist Security Info=True;User ID=user001;Initial Catalog=myData;Data Source=192.2.99.99; Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MYPC;Use Encryption for...
  7. dfs8463

    VB6 and SQL Server

    Why does "DECLARE @rtnRecs int;EXEC ss_GetStatementData @sAccountNr = '1234ABC', @iValidRecords = @rtnRecs OUTPUT" run in 50ms in a query window and get a timeout (command timeout set to 120) in VB6? The query goes through around 900k records and returns 100. VB6 statement is "rs.open sql"...

Part and Inventory Search

Back
Top