Forum Replies Created

Viewing 15 posts - 331 through 345 (of 1,473 total)

  • RE: Missing entries report

    Lowell (12/8/2009)

    i am completely spoiled by 2005 i swear.

    I feel like one of the only holdouts nowadays. I've lost count of the number of times I've had 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 8, 2009 at 3:49 pm

    #1089580

  • RE: Get Last Name, First name and Middle Name from Full Name

    To answer your question, you can get the first substring after the comma by doing something like this:

    CASE WHEN CHARINDEX(' ',full_name,CHARINDEX(',',full_name)+1) > 0

    THEN LTRIM(SUBSTRING(full_name,CHARINDEX(',',full_name)+1,CHARINDEX(' ',full_name,CHARINDEX(',',full_name)+1)))

    ELSE RIGHT(full_name,DATALENGTH(full_name)-CHARINDEX(',',full_name))

    END

    This uses the third (optional)...

    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 8, 2009 at 3:35 pm

    #1089575

  • RE: Get Last Name, First name and Middle Name from Full Name

    Can you please provide the results you expect based on that sample data?

    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 8, 2009 at 2:11 pm

    #1089514

  • RE: Issue with recreation of SQL Tables with rows 1 & 2 inserted.

    Heh, cool deal. So, I must be missing something here (and the lack of code blocks totally hoses my display so the code is hard to follow, but what...

    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 4, 2009 at 8:34 am

    #1087792

  • RE: Issue with recreation of SQL Tables with rows 1 & 2 inserted.

    How about this?

    http://www.sqlservercentral.com/articles/SQLCLR/68842/

    Also, could you wrap that really long line in a code block so that it doesn't hose the formatting of the page?

    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 4, 2009 at 8:27 am

    #1087783

  • RE: Stored Procedures that converts a table's column data type from char to nchar and varchar to nvarchar

    SSMS doesn't show line breaks. In reality, they probably don't serve a lot of purpose in that script, I just did it out of habit.

    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 3, 2009 at 2:10 pm

    #1087377

  • RE: Database Backed up on 2008, restore on 2000?

    I can't get the term 'That guy' out of my head right now. I think you'd probably find a warning against this in chapter one of 'Beginning Database Administration...

    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 3, 2009 at 2:01 pm

    #1087373

  • RE: Database Backed up on 2008, restore on 2000?

    Yeah, I think I should have googled first, asked the question afterwards. The database is restoring fine on another 2008 server, and a quick google informs me that 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]

    December 3, 2009 at 11:22 am

    #1087276

  • RE: Exporting to Excel Using a CLR Stored Procedure

    This could potentially be a massive time saver for me. Thanks so much for writing this article and sharing this code.

    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 2, 2009 at 4:54 pm

    #1086829

  • RE: Stored procedure ignores DENY INSERT

    I think it depends on how much you have to deal with permissions. In most of my environments, permissions have been either 'all' or 'nothing' on the database itself,...

    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 2, 2009 at 12:27 pm

    #1086709

  • RE: Stored procedure ignores DENY INSERT

    Edited out the example of said evil. I don't think it is commonly known and I don't want to help it become so.

    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 2, 2009 at 10:42 am

    #1086673

  • RE: Unable to display text field data

    Man, I've used that script 2 times in 2 days! Look out Lowell, I'm creepin into your territory! :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]

    December 2, 2009 at 9:10 am

    #1086598

  • RE: Unable to display text field data

    SSMS can be picky on what it displays. However, just because it is not displaying it doesn't mean that something else pulling the data will not. If you...

    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 2, 2009 at 9:08 am

    #1086595

  • RE: Unable to display text field data

    What application is doing the display? QA? SSMS? Crystal? Something else?

    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 2, 2009 at 8:54 am

    #1086580

  • RE: Stored procedure ignores DENY INSERT

    Hrm, and now that I think about it, if I am right, I'm gonna go edit that back out of my post, don't want to give anyone any ideas :-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]

    December 2, 2009 at 8:49 am

    #1086573

Viewing 15 posts - 331 through 345 (of 1,473 total)