Forum Replies Created

Viewing 15 posts - 721 through 735 (of 2,894 total)

  • RE: Adding comma separator to INT datatype

    ...

    The only thing is the European format. which it does the decimal point instead of the comma to separate thousands.

    ...

    Who told you that? It's not European format. We don't 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]

    January 31, 2013 at 3:07 am

    #1582841

  • RE: Adding comma separator to INT datatype

    johnnycash (1/30/2013)

    Hello to all gurus here!

    Please excuse the dumbness of this question, but if I have an INT value of 999999 and want to display it formatted with the thousand...

    _____________________________________________
    "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]

    January 30, 2013 at 11:00 am

    #1582675

  • RE: on delete trigger

    Sean Lange (1/29/2013)

    Or you could use and INSTEAD OF trigger and not have to worry about the transaction.

    ...

    I do agree - it looks cleaner and easier!

    _____________________________________________
    "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]

    January 29, 2013 at 9:14 am

    #1582203

  • RE: DateValue Function missing in SQL Server 2012 Express

    You are welcome Forum Newbie 😉

    Such a strange nick name you have... :hehe:

    _____________________________________________
    "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]

    January 29, 2013 at 4:51 am

    #1582029

  • RE: on delete trigger

    That is the case where table variable will be quite handy as it can keep data in rollback!

    Here I've setup small sample for you. Hope you can follow the idea...

    create...

    _____________________________________________
    "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]

    January 29, 2013 at 3:46 am

    #1581982

  • RE: DateValue Function missing in SQL Server 2012 Express

    DateValue is not SQL Server T-SQL function. It is a DAX one. You need SSAS in order to use it.

    _____________________________________________
    "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]

    January 29, 2013 at 3:14 am

    #1581973

  • RE: Need to optimize query

    attempt of catch-all query detected!

    I would suggest dynamic sql.

    Something to read:

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    _____________________________________________
    "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]

    January 29, 2013 at 2:40 am

    #1581956

  • RE: Query processor ran out of internal resources and could not produce a query plan.

    ...

    I wonder if his fix isn't to restart the production server every night at 4 am....

    I would call it anything but fix;-)

    _____________________________________________
    "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]

    January 29, 2013 at 1:59 am

    #1581939

  • RE: Query processor ran out of internal resources and could not produce a query plan.

    Don't blame me :hehe:

    http://support.microsoft.com/kb/2003681

    _____________________________________________
    "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]

    January 28, 2013 at 10:21 am

    #1581717

  • RE: SQL design discussion - help required

    I cannot see any picture... :crying:

    _____________________________________________
    "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]

    January 28, 2013 at 10:03 am

    #1581705

  • RE: Query processor ran out of internal resources and could not produce a query plan.

    Try to get generated sql string out of stored proc, then execute it and post the query plan. Wihtout seeing it it's hard to guess what could be wrong with...

    _____________________________________________
    "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]

    January 28, 2013 at 10:01 am

    #1581704

  • RE: SQL design discussion - help required

    Cannot see sample of XML or "output" in your post...

    _____________________________________________
    "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]

    January 28, 2013 at 9:39 am

    #1581693

  • RE: Query processor ran out of internal resources and could not produce a query plan.

    Have you actually found which particular query in your stored proc is slow? Is the one which uses dynamic sql?

    Can you please post DDL of fn_parse_multi_params_to_table?

    _____________________________________________
    "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]

    January 28, 2013 at 9:36 am

    #1581692

  • RE: Order of JOIN in multiple table joins

    purushottam2 (1/28/2013)

    Yes, Because in one of my query, i am joining with 3 tables. And table 1 have the 1 million record, 2 Lakh and table3 have 10 thousands.

    I am...

    _____________________________________________
    "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]

    January 28, 2013 at 9:31 am

    #1581687

  • RE: Any chance of success?

    ...

    Have we got any chance of success?

    It pretty much depends on your company criteria of "success" ...

    Hopes die last!

    :hehe:

    _____________________________________________
    "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]

    January 28, 2013 at 8:44 am

    #1581666

Viewing 15 posts - 721 through 735 (of 2,894 total)