Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 5,502 total)

  • RE: Loop Thru a Table

    subrata.bauri-1051938 (5/29/2011)

    I have a Temporary Table which has no of records (Rows) Now I want to go these Temp Table thru row by row. Is it Possible in SQL ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 30, 2011 at 1:38 am

    #1331527

  • RE: Query Help

    Here's a rather meaningless example of an unpivoted table based on your equally vague original table def. As you may notice, there are no rows with NULL values allowed. This...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 3:25 pm

    #1331478

  • RE: Value of backing up trans log dumps to tape...?

    First a thought on your current strategy in general:

    If you store your hourly trans dumps on the same server, do you mean you're using the same physical drive(s) as used...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 12:39 pm

    #1331466

  • RE: Query Help

    Why not using a unpivoted versiion of the table and store the type of date in a separate column instead of adding a column per type? I there's a need...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 12:07 pm

    #1331463

  • RE: HTML Report using SQL

    Did you try to email it as an attached html file?

    It seems like it's an issue with the embedded html data of sp_send_dbmail.

    At least we exluded the query being a...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 12:04 pm

    #1331461

  • RE: Query Help

    I'm curious what business case you're trying to implement.

    Would you please provide more details? What is the purpose of the trigger?

    At a first glance it sounds like a "semi-optimal" table...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 10:53 am

    #1331450

  • RE: HTML Report using SQL

    I copied your result into a html file and it looked just fine. Based on the data I cannot verify the result you see.

    What do you use to view the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 10:48 am

    #1331448

  • RE: HTML Report using SQL

    Please remove the xml sample since it obviously contains personal information (you crrectly obfuscated it in your original screenshot).

    I don't think it's the output of the original statement except the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 4:19 am

    #1331416

  • RE: How to get rid of <NULL> as result from a 'AS name'

    Replace

    Select SubGroupType from dbo.subgroup

    with

    Select ISNULL(SubGroupType,0) from dbo.subgroup

    I hope it's a rather small database and performance is not important...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 4:06 am

    #1331415

  • RE: How to get rid of <NULL> as result from a 'AS name'

    T oanswer your original question: use ISNULL(NAME2,'0').

    Please note that you should use consistent data types (not an integer to replace a varchar value).

    But the much more important issue you should...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 3:45 am

    #1331411

  • RE: Database refuses to auto-increment?? SQL Server Management Studio Express

    set identity_insert <tablename> on basically means you're providing the identity value within your INSERT statement (making sure there are no duplicate or NULL values).

    With set identity_insert <tablename> off you don't...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 3:17 am

    #1331405

  • RE: HTML Report using SQL

    I've seen the html tag before. No reason to repost it. 😉

    I don't think you had "the same" output with and without the html tag...

    My question was: what is the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 3:12 am

    #1331404

  • RE: "...cannot be renamed because the object participates in enforced dependencies"

    check sys.sql_expression_dependencies.

    Also, Aaron Bertrands blog is a good reference.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 2:50 am

    #1331400

  • RE: Challenge to deal with XML file using ssis? ANy one can give the better solution

    Is this some sort of homework?

    If not, why do you have to use SSIS?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 2:36 am

    #1331399

  • RE: sql server error 18456, login failed for USER 'NTAUTHORITY\SYSTEM'. [SQL STATE 28000]

    I guess this link should help you to get started.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    May 29, 2011 at 2:34 am

    #1331398

Viewing 15 posts - 1,471 through 1,485 (of 5,502 total)