Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 1,473 total)

  • RE: Need help on performance and integrity

    If anyone does do any testing of these methods, please post the results to this thread. I'm curious as to the outcome of this. Otherwise, I'll try...

    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]

    November 6, 2008 at 8:18 am

    #894920

  • RE: inner join issue

    No problem, glad we could help.

    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]

    November 6, 2008 at 8:12 am

    #894915

  • RE: inner join issue

    I'm referring to basic data cleansing. For example

    The first query will show you that Michael Jordan has a name Mismatch with Mike Jordan based on DOB and Zip 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]

    November 6, 2008 at 8:02 am

    #894897

  • RE: inner join issue

    Do you not have any unique identification field for the patients? Usually in cases such as these, you would have a unique identifier such as PatientID, or PatientNumber 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]

    November 6, 2008 at 6:01 am

    #894792

  • RE: Updating table in queue

    If you're asking how to ensure that updates coming from different sources go through one at a time, you can use transactions. That said, I don't believe you need...

    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]

    November 6, 2008 at 5:49 am

    #894783

  • RE: Which PK Generation system variable is reliable?

    In case anyone else is wondering after reading this (I was and decided to look it up rather than ask), here's how triggers that perform inserts affect these:

    From BOL:

    SCOPE_IDENTITY 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]

    November 5, 2008 at 7:10 pm

    #894615

  • RE: A strange T-SQL challenge

    Take a look at the PIVOT command.

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

    November 5, 2008 at 1:40 pm

    #894510

  • RE: Instead of Update Trigger on a View

    Yeah, I was 90% sure it wasn't before, and now I'm almost positive it's not. It made no sense that it would be, I just couldn't understand how 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]

    November 5, 2008 at 1:37 pm

    #894506

  • RE: wrong in this query ?

    Lack of Quotes.

    select * from universal where name = 'drill size ''9X10'''

    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]

    November 5, 2008 at 12:37 pm

    #894477

  • RE: Trigger that uses a Parameter with Inserted/Deleted

    I'm fairly sure you can't do what you're trying to do because executing your dynamic sql will open a new connection under which the virtual inserted/deleted tables do not exist....

    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]

    November 5, 2008 at 10:01 am

    #894377

  • RE: Update a record through EXISTS

    I want to update a record, if the record count of another table equal to 1. How can i achieve this.

    ...

    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]

    November 5, 2008 at 5:51 am

    #894171

  • RE: SQL Server Books Online -- Displays Nothing

    Getting back to this, the problem is now resolved. I'm still not sure what the issue was precisely, but today, to fix some other issues I was having, I...

    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]

    November 4, 2008 at 3:46 pm

    #893941

  • RE: What is wrong with this statement?

    ramadesai108,

    How many rows in your final result set? 45 minutes seems like an awfully long time. Also, what is that case calculation supposed to show? ...

    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]

    November 4, 2008 at 2:15 pm

    #893895

  • RE: compressing / collapsing numbers

    Cursory attempt to stop the thread from falling into the gutter = failure. 😉

    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]

    November 4, 2008 at 1:36 pm

    #893873

  • RE: What is wrong with this statement?

    This is integer arithmetic. ItmRecvdYR1 - ItmRecvdYR2 is less than ItmRecvdYR1, ie (10 - 5) / 5 = 0.

    By multiplying one of the values in this part of...

    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]

    November 4, 2008 at 1:34 pm

    #893872

Viewing 15 posts - 1,156 through 1,170 (of 1,473 total)