Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 4,814 total)

  • RE: Dangers of using MYSQL...What are they?

    If only I had some evidence for that... Unfortunately, the truth is that it was NEVER going to be easy, so the concern about "making it easy" wasn't...

  • RE: Dangers of using MYSQL...What are they?

    I agree, although their position isn't surprising when you consider that such advocacy being listened to would result in more jobs for the O-S community.

    Steve

    (aka smunson)

    :):):)

    jgrubb (10/27/2008)


    Amen about the talent...

  • RE: Vb.net and Sql Select From Group

    As rbarryyoung posted, we need more detail on how your data is structured. I look at your "datagrid", and can't determine if the column headings are part of...

  • RE: Need help on performance and integrity

    I continue to think that a complete statement of the problem coming from the OP has yet to occur. There is no written description of the EXACT process...

  • RE: convert a varchar(4000) to a int !?

    Jeff,

    Thanks for acknowledging. The only reason I chose to use a loop is because I just didn't have time to go look up the technique that selects from...

  • RE: using 32-bit ODBC driver on 64-bit system

    Holy OLE_DB, Batman! Looks like I'm way off here. I'd been led to believe by other sources in the past that this wasn't realistic... Mucho...

  • RE: Dynamical Fields/Values Insert into chart

    I'm not sure this is realistic. The nature of a chart is such that it has to expect the specific fields it was designed to look at. ...

  • RE: convert a varchar(4000) to a int !?

    It's good to have a working solution, but the performance of a WHILE loop construct for splitting strings could have problems with performance when dealing with a large number of...

  • RE: Dynamic query error

    I'm pretty sure there's a typo in the previously supplied solution...

    Considering your scenario, I AM ASSUMING THAT YOU ARE SURE THAT YOUR QUERY WILL RETURN ONLY ONE VALUE, you can...

  • RE: using 32-bit ODBC driver on 64-bit system

    I would have thought that installing SQL 32-bit on a 64-bit OS wouldn't have worked at all, but regardless of that, you can't expect a 32-bit ODBC driver to work...

  • RE: Get Missing Data with Tally Table

    I just realized my code will do an infinite loop if you add a new currency pair and don't have a rate for the first date in the range. ...

  • RE: Get Missing Data with Tally Table

    Here's a solution that should work on SQL 2000, but if table vars are 2005 only, just convert them to temp tables:

    --===== Create the test rates table

    DECLARE @MyTestRates TABLE (

    FromCurr...

  • RE: Problem in function

    I'm not sure I see why you need to bother calling a function to execute a stored procedure. It's just another level of abstraction. Why not...

  • RE: SQL 2005 Query to get time difference between two adjacent rows

    You don't need a WHILE loop or anything of that nature. Here's a set-based solution you can use with any given input table:

    DECLARE @LoginTable TABLE (

    UserID int,

    StartTime DateTime,

    StopTime...

  • RE: Split a date-range into periods

    Glad you have a working solution, but I feel the need to point out that with this new "split" table, the meaning of the value in the UNITS field has...

Viewing 15 posts - 4,516 through 4,530 (of 4,814 total)