Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: Need Help on Query

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

    😀

    ~Dan

  • RE: Does anybody ever look into this forum?

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

  • RE: Does anybody ever look into this forum?

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

  • RE: SQL Mobile 2005

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

  • RE: whats faster?

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

  • RE: whats faster?

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

  • RE: Trigger Question

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

  • RE: Transaction Error

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

  • RE: Transaction Error

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

  • RE: The Stored Proc n00b

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

Viewing 10 posts - 1 through 10 (of 10 total)