Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 5,109 total)

  • RE: Website Work

    I didn't even realise that WordPress ran on SQL Server, I always though it only worked with MySQL only. Is it a custom build?

    Thom~

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

  • RE: Proposed: Closing old forums

    I don't see SSRS In anyjof this Steve. There's still quite a few questions on the subject. I certainly, however, wouldn't say it needs a different forum for each version....

    Thom~

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

  • RE: SSRS Export to Excel with tabs ( How to Sort Tabs in Specific Order)

    Sounds like you don't have an order on your Group. Set one in the Sorting pane in the Properties window. As an example:

    Thom~

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

  • RE: Conditionally HIGHLIGHT a cell font (color=RED, BOLD) based on it's contents

    If you right click the text box and select expression you're setting the expression for the value of the textbox, not its properties. You need to be in the properties...

    Thom~

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

  • RE: Conditionally HIGHLIGHT a cell font (color=RED, BOLD) based on it's contents

    Put an expression in the relevant properties of the text box. Use an IIF to check the value and return the appropriate value(s).

    Thom~

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

  • RE: Using FORMAT() for Dates

    Eirikur Eiriksson - Thursday, May 24, 2018 5:43 AM

    Jeff Moden - Thursday, May 24, 2018 5:21 AM

    Thom~

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

  • RE: Using FORMAT() for Dates

    Got to admit, I was really excited when FORMAT was introduced into SQL Server. I can never remember all the different style codes for dates when using

    Thom~

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

  • RE: connecting two microsoft sql server management studio in lan

    Management Studio is an application; you're trying to connect to Microsoft SQL Server; it's an important distinction you need to learn (You don't call the World Wide Web "FireFox" or...

    Thom~

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

  • RE: Need help with derived column expression

    jcelko212 32090 - Wednesday, May 23, 2018 11:27 AM

    Phil Parkin - Wednesday, May 23, 2018 11:12 AM

    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?

    Matt Miller (4) - Wednesday, May 23, 2018 11:02 AM

    Jeff Moden - Tuesday, May 22, 2018 4:14...

    Thom~

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

  • RE: Looping through 65 millions of combinations: Excel or SQL or something else?

    "Dimensions"? Is this in a cube and thus you need an MDX query, or in a table in the data engine and thus you'd need T-SQL. You've posted in a...

    Thom~

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

  • RE: lost permissions to execute stored proc

    rajasekhar.bollareddy - Wednesday, May 23, 2018 7:37 AM

    Geoff A - Wednesday, May 9, 2012 8:41 AM

    Thom~

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

  • RE: passing a variable to an execute sql task sql script

    I wouldn't do it like this. Use an expression within SSIS to create your SQL and store than value in a variable; then, instead of using the option Direct Input...

    Thom~

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

  • RE: Execution time is taking longer

    Posting your Indexes are going to be a great help the the experts here. I can see a Table Scan on DTC_BI_DM_SOH in that picture of a query...

    Thom~

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

  • RE: find char in column

    santoshghogare2008 - Wednesday, May 23, 2018 5:41 AM

    hi,
    column containing alphanumeric data. i won't data from column having first five digit is char.

    PAN_NO
    ACBMX123D6
    AZCM4567G8
    LKM238GG66
    .............
    -----------------------
    OUTPUT...

    Thom~

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

Viewing 15 posts - 1,996 through 2,010 (of 5,109 total)