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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- dfs8463
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
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"...- dfs8463
- Thread
- Replies: 7
- Forum: Visual Basic (Classic)
