Forum Replies Created

Viewing 15 posts - 2,011 through 2,025 (of 2,894 total)

  • RE: Triggers vs Cursors

    MuraliKrishnan1980 (3/7/2012)

    Friends,

    I have a staging DB where there are around 100 History tables. These History tables are used to store History values of the updated records for the Main Tables....

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 7, 2012 at 5:21 am

    #1455901

  • RE: How to get the Manager by Manager in SQL

    --> IF "Senthil" ID Passes means, no record should display

    What about:

    INSERT INTO #ReportingToPerson VALUES (4, 'Karthik', 3)

    INSERT INTO #ReportingToPerson VALUES (5, 'Sanmugam', 3)

    ?

    Why they shouldn't be returned?

    What make them...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 7, 2012 at 5:15 am

    #1455900

  • RE: Moving average for the last 4 records

    Would me more than happy to help if you could provide some DDL and data setup for your question. Please refer to the link at the bottom of my signature.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 7, 2012 at 4:49 am

    #1455886

  • RE: Select columns dynamically

    Jeff Moden (3/6/2012)

    ...

    That's precisely what I was going to tell Eugene... the use of sp_ExecuteSQL doesn't necessarily mean that it prevents SQL Injection when someone uses it incorrectly. If...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 7, 2012 at 4:20 am

    #1455868

  • RE: What causes parameter sniffing to start?

    GilaMonster (3/7/2012)

    paul.goldstraw (3/7/2012)

    However, I don't consider this, or any of the other solutions online to be true solutions. A real solution would be code that just works. Whether this...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 7, 2012 at 4:13 am

    #1455864

  • RE: What causes parameter sniffing to start?

    paul.goldstraw (3/6/2012)

    ...Dynamic SQL is not an option as the industry I work in is quite security conscious, so I am not allowed to code for that

    ...

    Are you allowed to use...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 3:08 pm

    #1455623

  • RE: Multiple count() in a single SQL

    siva 20997 (3/6/2012)

    I accept that the first method is best

    Can we leave it at that

    No one argued with that :hehe:

    But I still advise you to read Jeff Moden's articles about...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 9:47 am

    #1455439

  • RE: Best approach to let users create and manage their own tables and data

    Eric M Russell (3/6/2012)

    Eugene Elutin (3/6/2012)

    I would go with Eric M Russell's suggestion:

    Kill the project!

    Give your users MS Access if they want to abe able to create tables themselves.

    Unless...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 9:43 am

    #1455438

  • RE: Multiple count() in a single SQL

    siva 20997 (3/6/2012)

    Line by Line code in Applications software is not thought of as good practice. It must be done in logical For next Loops etc and broken down niceley

    What...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 9:30 am

    #1455426

  • RE: Best approach to let users create and manage their own tables and data

    I would go with Eric M Russell's suggestion:

    Kill the project!

    Give your users MS Access if they want to abe able to create tables themselves.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 9:02 am

    #1455407

  • RE: Average date difference between two columns

    not much given...

    Select AVG(Datediff (day, StartDate, Lastattended)) as AverageTuitionDuration

    From PersonalFinance as PF

    Inner join PersonalProfiles as PP

    on PF.ContactID = PP.ID

    Where StartDate < Lastattended

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 8:54 am

    #1455397

  • RE: Multiple count() in a single SQL

    siva 20997 (3/6/2012)

    I agree that my code is little bit heavier on execution

    but there are a few reasons

    1) I come from a windows programming background and making the execution plan...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 8:51 am

    #1455394

  • RE: Select columns dynamically

    jcb (3/6/2012)

    Eugene Elutin (3/6/2012)

    I have a gut feeling that this requirement comes from not very well thought out design.

    Me too...

    I cannot see why would you want to do what...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 8:24 am

    #1455357

  • RE: Select columns dynamically

    I have a gut feeling that this requirement comes from not very well thought out design.

    I cannot see why would you want to do what OP has asked for. Even...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 7:50 am

    #1455326

  • RE: Sql Server & MS Access database size

    zeeshandar (3/6/2012)

    Q#1: How can I find the size of my sql server database?

    Q#2: I have MS Access database of size 80 MB. If I move access db data to sql...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    March 6, 2012 at 7:41 am

    #1455309

Viewing 15 posts - 2,011 through 2,025 (of 2,894 total)