Forum Replies Created

Viewing 15 posts - 106 through 120 (of 1,473 total)

  • RE: Missing numbers in a series

    It's threads like this that remind me on a regular basis how much I still need to learn about SQL Server :hehe:.

    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]

    May 5, 2010 at 11:56 pm

    #1162965

  • RE: inserting Commas

    Jeff Moden (5/5/2010)

    Here's what I get on my 8 year old desktop box for performance results...

    ...

    I...

    You...

    ...

    So how's Windows 98 holding up nowadays?

    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]

    May 5, 2010 at 11:49 pm

    #1162962

  • RE: Daily,Weekly,Monthly Report using TSQL

    Can you confirm the version of SQL you're running?

    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]

    May 5, 2010 at 11:34 pm

    #1162957

  • RE: Calculate values for TallyDuration

    This is usually referred to as a "Running Total". See the link in my signature for a wonderful article on how to solve this issue.

    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]

    May 5, 2010 at 4:38 pm

    #1162867

  • RE: Insert Column Default Values

    rajn.knit07 (5/5/2010)

    Hello,

    You have to write cursor here to update your lunchperiod data in class table from student table. First of all insert what ever data you have in class table....

    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]

    May 5, 2010 at 7:40 am

    #1162432

  • RE: Label/Value Pair

    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]

    May 4, 2010 at 4:58 pm

    #1162164

  • RE: price to pay: IMPLICIT conversion INT to DECIMAL(9,0)?

    If/When you do come back to it, it shouldn't be too hard to write some code that will script it all out for you. No real need to do...

    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]

    May 4, 2010 at 4:55 pm

    #1162163

  • RE: Updating a single record from Multiple

    Peter Brinkhaus (5/4/2010)

    kramaswamy (5/4/2010)

    Was really hoping for some better way of doing it :/

    I'm not sure what you are hoping for, but maybe this one will do:

    Very nice. I'm...

    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]

    May 4, 2010 at 1:22 pm

    #1162053

  • RE: Dynamic SQL To Update Table With CASE

    Danny Sheridan (5/4/2010)

    Thanks, Jeff! I appreciate the kind words and the welcome aboard.

    Jeffrey Williams-493691 (4/30/2010)

    I have to agree with the others, good start on posting. I did want...

    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]

    May 4, 2010 at 11:55 am

    #1162006

  • RE: Updating a single record from Multiple

    There quite possibly is, but I'm still not quite clear on what you're doing.

    What are your expected results from this:

    DECLARE @test-2 TABLE

    (

    ...

    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]

    May 4, 2010 at 11:45 am

    #1161996

  • RE: Label/Value Pair

    Here's an example that does parse the list instead of using dynamic SQL. Note the way that I supplied sample data and create table statements. In the future,...

    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]

    May 4, 2010 at 11:33 am

    #1161990

  • RE: Function Name??

    CASE

    ie.

    SELECT CASE WHEN Yourvalue IN ('Yes','No','Maybe') THEN YourValue ELSE 'Invalid' END as Result

    From YourTable

    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]

    May 4, 2010 at 11:10 am

    #1161972

  • RE: Label/Value Pair

    Depending on the answers to my above two questions, this might be able to be handled with a lookup table and some dynamic SQL.

    IE:

    1,2,3,4,5

    and a lookup table such as:

    Value ...

    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]

    May 4, 2010 at 11:08 am

    #1161967

  • RE: Label/Value Pair

    Is it really as simple as every table having CR and the number, or could you have a situation where say:

    11 ties to CR34

    or

    12 ties to TM12

    etc.

    Also, are all your...

    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]

    May 4, 2010 at 11:03 am

    #1161962

  • RE: Join Two columns of different tables

    You could rownumber both tables and join on that. As others have hinted at though, there's not much sense in doing so. Please describe your goals with this.

    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]

    May 4, 2010 at 7:11 am

    #1161764

Viewing 15 posts - 106 through 120 (of 1,473 total)