Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 1,473 total)

  • RE: Develop web page with SQL elements

    Typically, you're talking about two different elements you're going to need to learn. You'll need your front end (which would be ASP, .NET, C#, PHP or any of a...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 18, 2008 at 10:09 am

    #886775

  • RE: Help Needed with TSQL

    It seems like I'm overlooking an easier way to do this, but here's *a* solution. I use the variables so that I don't have to recursively scan a static...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 18, 2008 at 8:59 am

    #886769

  • RE: Extreme long UPDATE action, advice needed.

    t1.patientnummer = t2.patientnummer

    Is this a 1 to 1 relationship? It's hard to imagine that an update like this could take so long with a proper join.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 18, 2008 at 8:18 am

    #886766

  • RE: TRIM is driving me nut

    And the fact that bitmaps are HUGE. Not everyone that checks these forums has a high speed connection, and regardless, it just seems so... 20 years ago, to me...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 18, 2008 at 12:24 am

    #886739

  • RE: Need help on performance and integrity

    Interesting... I swore it worked when I ran it at the office. I don't even remember adding the WITH INDEX clause to the second piece. In any case,...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 18, 2008 at 12:17 am

    #886737

  • RE: TRIM is driving me nut

    Now that the issue is resolved... Bitmaps?... Seriously? 😛

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 2:55 pm

    #886684

  • RE: Need help on performance and integrity

    OK. This will be attempt #1 at a set based solution. I'm not 100% sure at the speed of this, as the index does not fully cover the...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 2:40 pm

    #886678

  • RE: Need help on performance and integrity

    Great image. That goes a lot farther towards explaining what you are after. This seems like it'll be a very interesting query to write. I haven't the...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 1:53 pm

    #886645

  • RE: cross-referencing values

    I have CTE's down on my list of things to do some more research on, so this may be totally off base, but isn't that still going to return multiple...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 1:31 pm

    #886628

  • RE: Help needed in removing dynamic SQL

    Indeed. I'll have to wait until we decide exactly where we're going to go with it before I decide if I'm going to need dynamic SQL or not.

    ggraber

    BTW, I...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 1:21 pm

    #886619

  • RE: cross-referencing values

    You're welcome. Glad I could help.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 1:11 pm

    #886611

  • RE: Help needed in removing dynamic SQL

    I don't disagree, I just don't see the necessity for the table. Checking the column data, considering it wouldn't be manually typed in is easily done just with variable...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 12:25 pm

    #886578

  • RE: cross-referencing values

    I did, and it doesn't help me see how my solution wouldn't work, because the way I'm looking at it, you would still just do:

    FROM ptAppointments P

    LEFT JOIN coApptResources...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 10:08 am

    #886487

  • RE: cross-referencing values

    MrBaseball34 (10/17/2008)

    Garadin (10/17/2008)

    Thanks for the creation scripts. Is there any reason you can't simply do this?

    I don't see what that does for me.

    Then apparently I'm on the wrong track...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 9:25 am

    #886455

  • RE: cross-referencing values

    I should note, that I wouldn't necessarily use that as a final solution unless you had to. That should get the links right for the time being, but it'd...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 17, 2008 at 9:16 am

    #886445

Viewing 15 posts - 1,336 through 1,350 (of 1,473 total)