Hey that's great! I created a Numbers table to handle this! Thank you for the replies, both were very helpful.

😀

~Dan

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

Cool! of course, you know i have to agree with them! how old are they? what kind of bikes are you looking at?

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

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

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

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

thanks for the replies guys. how/where do i find out if "XACT_ABORT" is ON or OFF?

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

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