Forum Replies Created

Viewing 15 posts - 4,006 through 4,020 (of 5,685 total)

  • RE: OPENXML issue

    Hey Lutz and Magoo?

    I'll admit my XQuery is very weak. One of the things that's always confused me is this part:

    FROM

    @XML.nodes ('/ROOT/Customer') as cust(cn)

    cross apply

    ...

    February 15, 2011 at 4:51 pm

    #1287386

  • RE: Redundant Indexes

    LutzM (2/15/2011)

    GilaMonster (2/15/2011)

    In your example index 1 is redundant (the columns match exactly a left-based subset of another index), index 2 is not.

    Wouldn't index 1 be used if a query...

    February 15, 2011 at 3:58 pm

    #1287359

  • RE: Are the posted questions getting worse?

    LutzM (2/15/2011)

    Dave Ballantyne (2/15/2011)

    Big meeting on friday to best decide how to handover all my knowledge to co-workers.

    First big change i need to do today is was told to make...

    February 15, 2011 at 3:14 pm

    #1287342

  • RE: Check IF column value exists in both and update column

    Triality (2/15/2011)

    I am creating an SSIS package that pulls data from a flat file. One of the columns in the flat file is "SalesID".

    In the database there...

    February 15, 2011 at 3:10 pm

    #1287341

  • RE: Return rows if total occurances exceeds 2 (combined with inner join)

    Right idea, but you need to look at the process a little differently.

    First, you need to determine all the multiple userid's in user_artist_owned, so we start with a query like...

    February 15, 2011 at 2:59 pm

    #1287335

  • RE: Seeking advice on updating a table

    If you never have record edits, this is... one approach.

    I've seen this method disseminated before as a quick and dirty way to perform that task.

    My alternatives will depend on the...

    February 15, 2011 at 2:51 pm

    #1287334

  • RE: Sending data here, there and everywhere

    tfifield (2/15/2011)

    Craig Farrell (2/14/2011)

    Service Broker isn't used much because its complexity is threefold.

    Craig,

    Do you know of a decent tutorial on it? I've been meaning to get into Service Broker...

    February 15, 2011 at 2:43 pm

    #1287328

  • RE: How to execute SSIS package stored in SQL Server ?

    SQL Guy 1 (2/15/2011)

    My version is 2008. Maybe this question sounds trivial, but I need to find a way to execute SSIS which is saved in SQL Server msdb,...

    February 15, 2011 at 10:00 am

    #1287166

  • RE: Proc runs slow only during business hours?

    Steve-3_5_7_9 (2/15/2011)

    Thanks. I don't know what I'm talking about. I thought I experienced this but after looking through my notes, I cannot find anything; so just disregard me.

    I...

    February 15, 2011 at 9:56 am

    #1287164

  • RE: ##Tables in concurrent environment

    Jeff Moden (2/14/2011)

    The reason for DATALENGTH in the function posted on this thread is so that you can use a space as a delimiter. It's only important if you...

    February 14, 2011 at 4:28 pm

    #1286796

  • RE: TSQL Brain Teaser (for me at least)

    As a silly question, since you're not getting results, can you double check something?

    select Name

    from [dbo].[Persons]

    where Gender IN ('Male', 'Female')

    Does this return anything?

    The code itself looks fine offhand.

    February 14, 2011 at 4:22 pm

    #1286794

  • RE: How To Work with Files based on file name patterns

    Makes perfect sense.

    I can't post images inline here so I'll try to explain this as descriptively as possible.

    The general idea here is loop the loop.

    First, get your table of prefixes...

    February 14, 2011 at 4:19 pm

    #1286792

  • RE: ##Tables in concurrent environment

    Jeff Moden (2/14/2011)

    wolfkillj (2/14/2011)

    Jeff Moden (2/14/2011)

    Ok... the following function will pretty much blow the doors off of other splitter functions including some of my old ones.

    WOW!!! That crash you...

    February 14, 2011 at 4:02 pm

    #1286787

  • RE: Sending data here, there and everywhere

    Service Broker isn't used much because its complexity is threefold.

    1) If you've never worked with a messaging service you have to learn a bunch of new terminology.

    2) You pretty much...

    February 14, 2011 at 3:26 pm

    #1286779

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (2/14/2011)

    GilaMonster (2/14/2011)

    Grant Fritchey (2/14/2011)

    Now I feel much better. I lose my job to Gail or I lose my job to Gail. Isn't there a third option that doesn't...

    February 14, 2011 at 1:11 pm

    #1286712

Viewing 15 posts - 4,006 through 4,020 (of 5,685 total)