Forum Replies Created

Viewing 15 posts - 166 through 180 (of 1,473 total)

  • RE: Does sql server have something that is similar to open query but more functional?

    Do you have a small segment of one of the scripts that you have to run through openquery (Or one of the whole scripts if they're relatively short)?

    Something that's generic...

    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]

    April 8, 2010 at 3:31 pm

    #1148687

  • RE: Left join versus *=

    The *= stuff is the old style. Don't use this. It won't work in 2008 and it's just confusing.

    The reason you are filtering more out on the above...

    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]

    April 8, 2010 at 2:39 pm

    #1148655

  • RE: ids as table

    I'd go that route personally (and do). Is that TVF an inline TVF or a Multi-Line TVF?

    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]

    April 8, 2010 at 12:59 pm

    #1148585

  • RE: Recursive cross join to get all available combinaisons

    Ninja's_RGR'us (4/8/2010)

    Garadin (4/8/2010)

    Ninja's_RGR'us (4/8/2010)

    Garadin (4/8/2010)

    Chris Morris-439714 (4/8/2010)

    Ninja (Remi?)

    Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and...

    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]

    April 8, 2010 at 12:50 pm

    #1148576

  • RE: removing duplicate values and keeping original

    You've tried... the query I wrote? Or the one you wrote below that is totally different?

    If the goal is to eventually to get rid of the table, then...

    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]

    April 8, 2010 at 12:46 pm

    #1148570

  • RE: removing duplicate values and keeping original

    insert into destinationtable [Fields...]

    SELECT DISTINCT [Fields...]

    from sourcetable

    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]

    April 8, 2010 at 12:36 pm

    #1148559

  • RE: Recursive cross join to get all available combinaisons

    Ninja's_RGR'us (4/8/2010)

    Garadin (4/8/2010)

    Chris Morris-439714 (4/8/2010)

    Ninja (Remi?)

    Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a...

    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]

    April 8, 2010 at 12:28 pm

    #1148554

  • RE: Strange SQL Performance behavior

    The query hasn't changed, but the underlying data, index fragmentation, statistics accuracy etc. all has. It could also have just had a "bad" plan.

    I've had 1 particular query 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]

    April 8, 2010 at 12:23 pm

    #1148549

  • RE: Installation error: Invalid namespace

    Here's some information on what might be happening.

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e90c853b-6018-41b0-9dd1-abd2ac872f16

    http://msdn.microsoft.com/en-us/library/ms143380.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]

    April 8, 2010 at 12:08 pm

    #1148541

  • RE: Does sql server have something that is similar to open query but more functional?

    Have you tried Linked Servers?

    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]

    April 8, 2010 at 12:03 pm

    #1148536

  • RE: Recursive cross join to get all available combinaisons

    Chris Morris-439714 (4/8/2010)

    Ninja (Remi?)

    Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link table?

    It's...

    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]

    April 8, 2010 at 11:42 am

    #1148521

  • RE: Recursive cross join to get all available combinaisons

    Ninja's_RGR'us (4/8/2010)

    Chris Morris-439714 (4/8/2010)

    Ninja (Remi?)

    Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...

    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]

    April 8, 2010 at 11:37 am

    #1148516

  • RE: Date Manipulation with DATEADD/DATEDIFF

    Hanri Naude (4/8/2010)

    hi,

    You can change the first day of the week by using the @@DATEFIRST keyword.

    http://msdn.microsoft.com/en-us/library/ms181598(SQL.90).aspx

    Regards,

    Hanri

    You can change the day of the week, but as I mentioned in an earlier...

    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]

    April 8, 2010 at 9:03 am

    #1148370

  • RE: mis-appying a cross apply table value function?

    Paul White NZ (4/8/2010)

    Scalar T-SQL functions suck.

    Multi-statement T-SQL functions suck more.

    In-line T-SQL functions are awesome.

    Multi-statement functions do have their uses - but only if the logic cannot be written in...

    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]

    April 8, 2010 at 7:41 am

    #1148271

  • RE: Get Month Name

    [Edit] Ack, thought I had scrolled down all the way, apparently I was wrong.

    Since I've posted anyways, might as well mention that doing it this way automatically adjusts for language...

    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]

    April 7, 2010 at 10:49 pm

    #1148025

Viewing 15 posts - 166 through 180 (of 1,473 total)