Forum Replies Created

Viewing 15 posts - 901 through 915 (of 1,473 total)

  • RE: stored proc with paging works on 2K, breaks on 2K5

    That explains why I didn't see it with my Tally table example as well. Thanks Barry.

    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]

    December 15, 2008 at 2:28 pm

    #912810

  • RE: Appropraite Datatypes

    Lynn Pettis (12/15/2008)

    Or

    Username ...

    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]

    December 15, 2008 at 2:25 pm

    #912805

  • RE: Appropraite Datatypes

    That's really not enough information, but if I had to guess based on the field names:

    Username ...

    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]

    December 15, 2008 at 2:15 pm

    #912795

  • RE: View Definition display

    andreq1 (12/15/2008)

    I'm working in both SQL 2000 and 2005, so the situation applies to each system.

    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]

    December 15, 2008 at 1:02 pm

    #912739

  • RE: View Definitions

    We'll call this one the duplicate then.

    Please direct all replies to:

    http://www.sqlservercentral.com/Forums/Topic619897-338-1.aspx

    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]

    December 15, 2008 at 1:01 pm

    #912737

  • RE: View Definitions

    Please do not double post. First things first, what version of SQL server are you using?

    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]

    December 15, 2008 at 12:46 pm

    #912722

  • RE: problems with subquery counts

    Eeek. Function subqueries with a cross join on top: join Forms f on f.FormId = f.FormId (And one that is completely wrong, since you already joined that...

    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]

    December 15, 2008 at 10:46 am

    #912650

  • RE: Getting Count when "nothing is there"

    Aye, just explaining why Mark's method didn't work in this case for future readers.

    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]

    December 15, 2008 at 9:32 am

    #912568

  • RE: ERROR:String or binary data would be truncated.

    One of the items you are trying to insert is too long for your declared column size. Check the lengths against your field lengths.

    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]

    December 15, 2008 at 7:38 am

    #912459

  • RE: Getting Count when "nothing is there"

    It is my understanding that 6 and 23 would be returned if they had *ever* been used in that table. (for the GROUP BY ALL method)

    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]

    December 15, 2008 at 7:34 am

    #912457

  • RE: Order by clause

    This is Barry's original case method applied to your table structure.

    SELECT *

    FROM #Temp

    ORDER BY (CASE WHEN ParentID = '1' THEN 0 ELSE 1 END), ParentId

    Notice the way Chris...

    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]

    December 15, 2008 at 6:53 am

    #912429

  • RE: Sample SQL Code to do a table update from Excel

    If it's something you need to do on a regular basis, you're probably going to want to look into setting up a bulk import job. I've never done one...

    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]

    December 15, 2008 at 6:20 am

    #912407

  • RE: How to pass a table to a sql server stored procedure

    Is the dataset generated by the first stored procedure being run once, or does it get generated by the first stored procedure being run multiple times? How long are...

    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]

    December 14, 2008 at 9:43 am

    #912212

  • RE: How to pass a table to a sql server stored procedure

    IIRC, You can only pass a table in a parameter as of 2K8. That said, there are a number of other ways to accomplish what you're trying 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]

    December 14, 2008 at 9:25 am

    #912209

  • RE: Getting Count when "nothing is there"

    Heh, oops, yeah, forgot the ISNULL as I was walking out the door as I posted this. Thanks for the feedback.

    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]

    December 14, 2008 at 9:07 am

    #912207

Viewing 15 posts - 901 through 915 (of 1,473 total)