Forum Replies Created

Viewing 15 posts - 406 through 420 (of 3,221 total)

  • RE: NULLIF 1

    Danny Ocean (6/28/2012)

    Hi,

    Very badly represent the question. given option are not correct. your are showing only 3 values (columns) in option but after execute the query, you will find the...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 28, 2012 at 9:04 am

    #1506675

  • RE: Presenting rows of data horizontally

    smitausa (6/27/2012)

    I have two fields in a SQL Server 2008 view.

    ID and SubID. There are up to 24 subIDs for any ID.

    In other words, there can be up...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 27, 2012 at 12:10 pm

    #1506311

  • RE: Index defaults 2

    Nice question .. learned something

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 26, 2012 at 9:24 pm

    #1505944

  • RE: NULLIF 1

    SQLRNNR (6/26/2012)

    Straightforward question

    Thanks ... but read the previous entries and see the opposite feelings. I was beaten from pillow to post ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 26, 2012 at 12:29 pm

    #1505775

  • RE: Are the posted questions getting worse?

    Any one interested in convincing this OP that for a development / design / implementation contract as a consultant they would help him/her solve their problem.

    http://www.sqlservercentral.com/Forums/Topic1321325-391-1.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 26, 2012 at 10:09 am

    #1505683

  • RE: Are the posted questions getting worse?

    Any one know if those spreading Colorado wild fires are threatening Steve's home or the horses? Any one hear from Steve on twitter or whatever?

    http://news.yahoo.com/colorado-fire-near-pikes-peak-forces-11-000-014551591.html

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 25, 2012 at 4:22 pm

    #1505314

  • RE: COALESCE

    bhuvneshk (6/25/2012)

    Hi Regina,

    Please try to search the syntax on BOL or do little Google for that before posting it to this forum.

    As many of other useful queries remain ananswered due...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 25, 2012 at 10:47 am

    #1505175

  • RE: Sum DISTINCT fields only

    Is this what you are attempting?

    CREATE TABLE #T(Col1 INT)

    INSERT INTO #T

    SELECT 1 UNION ALL

    SELECT 1 UNION ALL

    SELECT 2 UNION ALL

    SELECT 3 UNION ALL

    SELECT 4 UNION ALL

    SELECT 1

    SELECT SUM(DISTINCT(Col1)) AS 'Sum...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 23, 2012 at 6:40 am

    #1504742

  • RE: Restricting updates?

    Koen Verbeeck (6/22/2012)

    Hugo, thanks for the very lengthy and detailed explanation. I already figured out how it worked, but I found the original explanation "there isn't a WHERE clause" a...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 22, 2012 at 5:29 am

    #1504437

  • RE: Number on concurrent users on SQL 2012 Developer Edition

    The same as the Enterprise edition - practically depends on the server (number of cores, I/O, etc)

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 20, 2012 at 7:06 am

    #1503382

  • RE: Download report having more than 256 columns in SSRS 2008 R2 to Excel?

    sql server developer (6/18/2012)

    Hi Ron,

    First of all thanks for the reply! The link you have sent shows the number of columns in Excel 2007. But even in SSRS 2008 R2...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 19, 2012 at 5:57 am

    #1502750

  • RE: Download report having more than 256 columns in SSRS 2008 R2 to Excel?

    sql server developer (6/18/2012)

    Hi Ron,

    First of all thanks for the reply! The link you have sent shows the number of columns in Excel 2007. But even in SSRS 2008 R2...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 19, 2012 at 5:51 am

    #1502745

  • RE: Download report having more than 256 columns in SSRS 2008 R2 to Excel?

    From

    http://msdn.microsoft.com/en-us/library/aa730921(v=office.12).aspx#Office2007excelPerf_BigGridIncreasedLimitsExcel

    The "Big Grid" and Increased Limits in Excel 2007

    The Excel 2007 "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million, and the number...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 18, 2012 at 8:06 pm

    #1502552

  • RE: Any good Web Instructions for SSIS? I'd love to learn...

    To start might I suggest using what is available here on SSC, in the left margin of the home page, or for that matter in the left margin of a...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 18, 2012 at 4:51 pm

    #1502504

  • RE: need to replace

    I have no doubt that the problem is completely understood by yourself, having the table and its contents available to view. But we do not have that knowledge, so...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    June 17, 2012 at 3:35 pm

    #1502048

Viewing 15 posts - 406 through 420 (of 3,221 total)