Forum Replies Created

Viewing 15 posts - 4,696 through 4,710 (of 5,111 total)

  • RE: ssrs report using a varchar(max) column

    Is the above HTML being returned in one field (as in you have one row and column returned). If so, then inserting a new page will be impossible.

    If each letter...

  • RE: SQL Server 2016 and Raspberry Pi

    Windows 10 IoT Core doesn't support SQL Server natively, no.

    It does appear someone is writing an article about it here[/url] however their latest post doesn't have the answer yet...

  • RE: User permission to grant access

    Robin35 (12/9/2016)


    Thom A (12/9/2016)


    Correct me if I'm wrong, but are you instead saying that this particular login should always be assigned specific permissions whenever you create any and all databases...

  • RE: sp_send_dbmail

    SQL itself isn't great for creating a dataset and putting it into an attachment to email. You could put it into an inline html table, which the msdn page on...

  • RE: User permission to grant access

    Correct me if I'm wrong, but are you instead saying that this particular login should always be assigned specific permissions whenever you create any and all databases on an instance,...

  • RE: User permission to grant access

    Robin35 (12/9/2016)


    Hello,

    i'm trying to create a login and assign permission to login so that it should be able to assign any kind of permissions on any databases on that instance.

    I'm...

  • RE: Output on conditional date logic

    TheSQLGuru (12/9/2016)


    Note the other code given seems to provide the wrong date for 101.

    Noticed this after I posted, note the edit 😉

  • RE: Output on conditional date logic

    Try to keep your code, when posting, in IFCode tags, it makes it much more readable for other users.

    I've also changed your date formatting, as for me '11/20/2016' would mean...

  • RE: Help with query to find duplicate fields from one column and return relevant information

    OP psoted this in a different topic i was subscribed to, seems to be related to this topic, rather than the one he posted in:

    v.razaghzadeh (12/9/2016)


    Hi

    Thank you so much...

  • RE: tempdb errors

    kevaburg (12/9/2016)


    Saurabh.D (12/9/2016)


    This will work

    EXEC xp_ReadErrorLog 0, 1, Null, Null, '2012-05-16 00:00:00', '2019-12-31 23:59:59'

    ExtendedStoredProc xp_ReadErrorLog has Start_Date & End_Date options

    When I understand the procedure...

  • RE: Help with query to find duplicate fields from one column and return relevant information

    As Ed said, I think I understand what you're after, but the DDL and sample data is the key here. Well done though on posted your code you have, and...

  • RE: Query Tunning

    Didn't even notice that. The query still doesn't have any fields returned from [font="System"]wtprod.epmbuildrule[/font] or [font="System"]wtprod.epmreferencelink[/font], so they can still be taken out of your CROSS JOIN.

    I still can't...

  • RE: Query Tunning

    Looking at your query plan, the join you have to PK_WTPart is your big cost, with just under an estimated 4 Million rows at around 9kb each. That's about 34...

  • RE: order of ssrs 2008 parameters

    There are buttons on you Report Data pane to do this. They look like Up and Down Arrows.

  • RE: MCSA 2012 or 2016?

    Luis Cazares (12/8/2016)


    Thom A (12/8/2016)


    Repeat of post http://www.sqlservercentral.com/Forums/Topic1841367-2799-1.aspx under different account?

    Try to keep one topic per questions 🙂 😎

    You linked to this thread.

    Doh!!! :pinch:

Viewing 15 posts - 4,696 through 4,710 (of 5,111 total)