Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 5,109 total)

  • RE: Reporting service Edition for 2017

    sqlfriends - Wednesday, November 8, 2017 5:08 PM

    After reading this page https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services

    , I realized for install SSRS edition, there is a...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Reporting service Edition for 2017

    sqlfriends - Wednesday, November 8, 2017 3:01 PM

    We install two reporting services servers. Only reporting service on the server, one is used...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Reporting service Edition for 2017

    sqlfriends - Wednesday, November 8, 2017 2:49 PM

    Does that mean SSRS 2017 edition is decided by the edition of the SQL server...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Reporting service Edition for 2017

    Sue_H - Wednesday, November 8, 2017 2:20 PM

    sqlfriends - Wednesday, November 8, 2017 12:57 PM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: load data into 3 separate tables using tsql .

    vsamantha35 - Wednesday, November 8, 2017 12:52 PM

    oh ok . may be below info can help or answer your question.

    SELECT ...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: load data into 3 separate tables using tsql .

    You mention, in your post the "first" record/row. How do we determine row "1" from your data? (The answer is not the first row inserted).

    Thanks.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Deny delete for some users

    Granting a user permission to do something when they have a deny permission will not work. DENY > GRANT. For that tio work, you would need to REVOKE the user's...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: need help

    jyoti.raghuvanshi - Wednesday, November 8, 2017 10:00 AM

    Sorry about the ambiguity. The DDL for the tables are as follows:
    create table employee(empid...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Deny delete for some users

    How are your users connecting to the SQL database? Do the users connect via Intergrated Security through the application, or does that application have its own Login that fulfils the...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Column Length declaration

    Like John said, assign it to the size it should be. Databases grow, Tables, grow, but columns should not. You should know how large a field is going to be...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, November 8, 2017 8:03 AM

    Or the ones who will put every column on a single line with...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, November 8, 2017 7:51 AM

    I like the alias = expression method, makes it easier when switching from/to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, November 8, 2017 7:13 AM

    I would never
    , start a statement
    , with  a semicolon
    ;

    I hope that somebody will...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Hide empty columns

    Do you mean hide the entire column if every value in the column has a value of NULL? Not to be showed when there's any value in there would be...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Database Corruption

    d_gomes2 - Wednesday, November 8, 2017 3:40 AM

    Hi Tom,
    The server are exact the same as Hardware, OS and SW.
    Thank you

    And none of...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 2,626 through 2,640 (of 5,109 total)