Forum Replies Created

Viewing 15 posts - 4,531 through 4,545 (of 5,109 total)

  • RE: Not Excited by Linux

    I'm actually not surprised that those that responded to the poll aren't excited by SQL Server on Linux. Most of the users on SSC have probably been in bed with...

    Thom~

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

  • RE: Add T&C Page to SSRS report

    Is this not a duplicate of your post here: http://www.sqlservercentral.com/Forums/Topic1848831-2799-1.aspx

    Unless you have clear control of your page breaks, this isn't going to be possible with SSRS.

    If this is your...

    Thom~

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

  • RE: Installing SQL Server 2012 Express failed on Windows 10 Home

    Out of interest, what OS are you using, Your logs say "OS version: Future Windows Version"???

    Thom~

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

  • RE: Requirements to export data into an .xlsx file

    To export from SQL Server to Excel, you'll need to use the ACE 32bit drivers (The JET drivers are the older drivers and are no longer supported).

    It's the Microsoft...

    Thom~

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

  • RE: SSIS- File reading and processing

    As John said, if you want links on how to do this, you have a variety of Search Engines to choose from for aid. For example: Google, Bing, Yahoo.

    Other than...

    Thom~

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

  • RE: Using Parameter to Define Columns in Query

    You could achieve this by using expression for the visibility of the columns. So you have every column in your design view, however, your speed column might only be displayed...

    Thom~

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

  • RE: SSIS- File reading and processing

    OK, so what is your question? Note my use of a question mark to show I am asking one.

    You haven't asked anything, just told us what you want to do.

    Thom~

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

  • RE: Header to Many rows

    ringovski (1/10/2017)


    Insert statements;

    INSERT INTO [dbo].[VehicleAnalysisVCR]

    ([VCRRecType]

    ,[VCRCustNo]

    ...

    Thom~

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

  • RE: Using Parameter to Define Columns in Query

    I'm afraid I'm a not quite sure I understand how your data looks from your description. This is a bit of a stab in the dark, as I don't have...

    Thom~

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

  • RE: How to write a string to a file in SQL.

    ben.brugman (1/10/2017)


    Eirikur Eiriksson (1/10/2017)

    You will have to elaborate further on the requirements, UTF-8 is unicode hence multi byte!

    😎

    Oops, my bad, I want an 8 bit character set and not a...

    Thom~

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

  • RE: Hi ,how to code the below procedure with loop.

    skmoh2 (1/10/2017)


    Thanks Luis for this.i have done this scenario with SQL and is working fine.But i have to implement it using procedure/function with LOOP .As may be tomorrow there will...

    Thom~

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

  • RE: Hi ,how to code the below procedure with loop.

    Luis Cazares (1/10/2017)


    Here's a guess on what his columns really are.

    Pegging

    SKU

    QTY

    RDD ...

    Thom~

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

  • RE: Hi ,how to code the below procedure with loop.

    Welcome to SSC, however, have you actually asked a question in your above post?

    Also, can you supply DDL and DLM statements for your tables. At first glance you have more...

    Thom~

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

  • RE: SSIS- File reading and processing

    You've outlined what you want to do, which is great, but you haven't asked a question, apart from stating you want suggestions. Suggestions on what? How to receive the files,...

    Thom~

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

  • RE: Fetch the last run time

    R.P.Rozema (1/10/2017)


    The feature to look for is CDC (Change Data Capture). Introduced in SQL server 2012, it required an enterprise license, but in newer versions it is available in other...

    Thom~

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

Viewing 15 posts - 4,531 through 4,545 (of 5,109 total)