Viewing 10 posts - 1 through 10 (of 10 total)
Hey that's great! I created a Numbers table to handle this! Thank you for the replies, both were very helpful.
😀
~Dan
October 15, 2009 at 3:42 pm
yes. riding a dirt bike is a great way to learn how to truly master riding. i would recommend Gary Semics. He has taught many of today's supercross stars and...
February 17, 2006 at 9:18 pm
Cool! of course, you know i have to agree with them! how old are they? what kind of bikes are you looking at?
February 17, 2006 at 9:16 pm
interesting point about the card. the DB file is being stored on an SD card. if the errors start again, i will try using a different card and see...
January 5, 2006 at 7:39 am
searching 31,253 records, both queries seemed to hover around 13-16 milliseconds on our server. sometimes the LEFT() query would spike up to 186 ms and sometimes the LIKE query would...
September 29, 2005 at 1:50 pm
good point about the indexes...however, in our database (which is SQL Server 2000) these columns do not have indexes. is there a built in way to easier benchmark queries through...
September 29, 2005 at 1:39 pm
CREATE TRIGGER [UpdateIndividualTables] ON dbo.Individuals
FOR UPDATE
AS
DECLARE @AcctNumber varchar(10)
DECLARE @KamperID int
DECLARE @StaffID varchar(11)
DECLARE @Gender varchar(1)
DECLARE @FirstName varchar(30)
DECLARE @MiddleName varchar(30)
DECLARE @LastName varchar(30)
DECLARE @HAddress varchar(100)
DECLARE @HAddress2 varchar(100)
DECLARE @HCity varchar(40)
DECLARE @HState varchar(2)
DECLARE...
September 23, 2005 at 3:02 pm
thanks for the replies guys. how/where do i find out if "XACT_ABORT" is ON or OFF?
August 23, 2005 at 4:42 pm
solution (?): it looks as if when a timeout occurs, SQL Server 2000 will automatically rollback any open transaction. so when the code tried to rollback the transaction, it produced...
August 22, 2005 at 5:03 pm
ok i finally found 2 good and valid solutions.
1) http://www.sommarskog.se/arrays-in-sql.html
2)
DECLARE @Var AS VARCHAR(100)
SET @Var = '''Dan'', ''Mike'', ''Lisa'''
DECLARE @SQL AS varchar(1000)
SET @SQL = 'SELECT*
FROM ORDERS
WHERE
NAME IN ('...
April 28, 2005 at 4:35 pm
Viewing 10 posts - 1 through 10 (of 10 total)