Forum Replies Created

Viewing 15 posts - 316 through 330 (of 1,473 total)

  • RE: Enterprise Manager substitute for SQL 2005+

    GSquared (12/16/2009)

    Navigate the tree view in the Object Explorer to the proc you want to look at, right-click it, and select Modify.

    I can't. I have too many SP's.

    Posted...

    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 16, 2009 at 9:53 am

    #1093154

  • RE: TSQL error: 'Invalid length parameter passed to the substring function.'

    Apologies in advance if this is already known, I didn't read through the whole thread. The issue is likely arising because one of your strings is < 72 characters,...

    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 16, 2009 at 8:02 am

    #1093013

  • RE: Get logical/physical model of a database

    Heh, yeah, had a few minutes to kill.

    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 12, 2009 at 4:10 pm

    #1091599

  • RE: Get logical/physical model of a database

    You can also just use notepad.

    +---------------------------+

    | Employees |

    +---------------------------+

    | EmployeeID int ...

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

    #1091440

  • RE: Can anyone verify this please??

    SQL-939141 (12/11/2009)

    Wow - click on the error and it takes you there - FAB!

    We need a 'handy tip of the day'!

    This would have saved me hours by now.

    I guess 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 11, 2009 at 7:23 am

    #1091172

  • RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

    Lynn Pettis (12/10/2009)

    What you are told will never change has a funny way of changing.

    Never Say Never!

    (Hehe, sorry, couldn't resist, but hopefully both the people that get that joke...

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

    #1090994

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

    Jeff Moden (12/10/2009)

    Heh... try hell! I did cheat! I just got caught. :blush:

    I mean, if you were gonna cheat, you could have at least done nickname as well....

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

    #1090992

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

    Jeff Moden (12/10/2009)

    Ahg....my apologies. I forgot I was in a 2k forum. I'll see if I can flip it to 2k code tonight.

    Way to try and cheat Jeff....

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

    #1090909

  • RE: Common Table Expressions

    BaldingLoopMan (12/9/2009)

    not sure what ur saying about the selecting for a cte because u can sdo that w/ the #tables as well.

    I like the #tables in development because i can...

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

    #1089854

  • RE: To cursor, or not?

    Here's a short article on CTE's you could read when you want to start investigating them.

    http://www.sqlservercentral.com/articles/T-SQL/68651/

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

    #1089843

  • RE: Common Table Expressions

    BaldingLoopMan (12/9/2009)

    All very useful info guys. Once again it appears the geniuses at sql server have designed a new way to do the same thing but w/ different syntax. Sure...

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

    #1089840

  • RE: Identify the row / value that caused a conversion / out-of-range error?

    Dear Tally Table. How I love thee, let me count the ways...

    SELECT *

    FROM YourTable

    WHERE pseudodatecolumn NOT IN (

    select CAST(YEAR(dateadd(d,n,'19910101 00:00:00')) as char(4)) +

    RIGHT('0' + CAST(MONTH(dateadd(d,n,'19910101...

    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 9:40 pm

    #1089635

  • RE: Optimize Insert

    Can you post the current query you are using? We may need more, but that'd be a good place to start.

    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 9:02 pm

    #1089626

  • RE: Common Table Expressions

    niall.baird (12/8/2009)

    I *can* read Garadin. That is why I was questioning the above statement. Seems to me that defining a #table would be more use, as you can use...

    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 8:52 pm

    #1089624

  • RE: Common Table Expressions

    niall.baird (12/8/2009)

    Seriously? You can only use a CTE in the statement immediately following?

    When I read the article, the impression I got was that you could define a CTE at...

    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 7:02 pm

    #1089614

Viewing 15 posts - 316 through 330 (of 1,473 total)