Forum Replies Created

Viewing 15 posts - 91 through 105 (of 1,473 total)

  • RE: Left Outer Join question

    Check out ISNULL or COALESCE in BOL. Should give you what you need here.

    Try something like ISNULL(E.Name, F.Name) Name in your select.

    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 24, 2010 at 9:12 am

    #1171620

  • RE: Newbie needs help with joining multiple tables

    Yes, you can do that. I'd switch to using the new join syntax and not the old ANSI style stuff though. That would make that query look closer...

    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 23, 2010 at 10:09 am

    #1171300

  • RE: Can we write a SELECT query without using the keyword FROM

    Yeah, doing things like that is no problem.

    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 21, 2010 at 10:58 pm

    #1171183

  • RE: Interesting problem for the "Running Total/Quirky Update" method of removing cursors

    I'm still a little unclear on your requirements. Can you provide the results you are trying to get?

    This is a guess and might be the whole thing you're trying...

    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 21, 2010 at 3:54 pm

    #1171133

  • RE: spliting nested string

    If you're really getting into the thousands of splits in a string, you're probably well into CLR territory.

    WHAT?!?! SOMEBODY was gonna say it.

    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 21, 2010 at 3:31 pm

    #1171128

  • RE: SQL Function Issue.Getting Strange Result

    You could also explore DDL Triggers to update the function when the table was updated. In general though, don't use SELECT *.

    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 21, 2010 at 3:26 pm

    #1171123

  • RE: Can you do a calculated test field with data from two tables?

    Yep, that's the gist of it.

    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 21, 2010 at 3:19 pm

    #1171119

  • RE: CREATE or ALTER PROCEDURE not detecting invalid object names.

    The concept Lowell is explaining is often referred to as Deferred Name Resolution.

    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 21, 2010 at 2:23 pm

    #1171100

  • RE: Can you do a calculated test field with data from two tables?

    As elutin points out, you have options, but if you definitively want a calculated field that accesses data from another table, you have to create a function and then call...

    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 21, 2010 at 2:12 pm

    #1171091

  • RE: Can we write a SELECT query without using the keyword FROM

    You can turn use this to turn SQL into the most expensive calculator ever 😀

    SELECT 5000/34.2

    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 21, 2010 at 2:07 pm

    #1171089

  • RE: Invalid length parameter passed to the LEFT or SUBSTRING function.

    karthikeyan-444867 (5/20/2010)

    Welcome to Microsoft SQL Server version 2005 and higher query optimiser.

    IT MAY HAPPEN! As optimiser may deside to evaluate devision result before applying WHERE filter (or JOIN) and return...

    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 21, 2010 at 7:54 am

    #1170835

  • RE: Replace Function Doesn't Seem to Work

    Did it look like REPLACE(yourstring,'Odd Little Squares','') ? Cuz that's not gonna work at all! =).

    Replacing things like that without knowing what they are can be a pain, 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]

    May 17, 2010 at 8:57 pm

    #1168561

  • RE: Missing numbers in a series

    To know that much about SQL Server... AND be able to write C# code. Way to make the rest of us look like schmucks ;-).

    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 6, 2010 at 7:58 pm

    #1163742

  • RE: Help with Query

    CirquedeSQLeil (5/6/2010)

    Please provide a sample of what you have tried thus far.

    I was thinking the same thing... but it may just be the language barrier. Aside from the request...

    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 6, 2010 at 3:57 pm

    #1163675

  • RE: inserting Commas

    Wow. I had no idea windows XP had been around that long. Apparently it came out in 2001 though. I only started using XP on my home...

    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 6, 2010 at 3:54 pm

    #1163674

Viewing 15 posts - 91 through 105 (of 1,473 total)