Forum Replies Created

Viewing 15 posts - 856 through 870 (of 5,109 total)

  • Reply To: Msg 102, Level 15, State 1, Line 6 Incorrect syntax near ')'.

    The problem is very likely in your dynamic SQL. I wouldn't be surprised if it's because you aren't properly quoting and parametrising your queries (as the error is on line...

    • This reply was modified 6 years, 11 months ago by Thom A. Reason: Wasn't as long as ago as I thought

    Thom~

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

    July 3, 2019 at 2:37 pm

    #3659788

  • Reply To: What's the fastest way to define a dataset in one SP and then use it in another?

    At a total guess, perhaps, rather than having SP1 run and pass the data to SP2, why not have SP2 run SP1 and get the data from it? You could...

    Thom~

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

    July 3, 2019 at 10:21 am

    #3659674

  • Reply To: Are the posted questions getting worse?

    Well today's a write off. Got into the office, and the system is down because the rebuild I had to do at the end of the day failed. Therefore I...

    Thom~

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

    July 3, 2019 at 9:51 am

    #3659659

  • Reply To: Are the posted questions getting worse?

    Steve Jones - SSC Editor wrote:

    I hate to duplicate all GH issues here, but I can perhaps add a list to the status update of the front end items that might let you know...

    Thom~

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

    July 2, 2019 at 4:10 pm

    #3659390

  • Reply To: SSIS version

    sqlfriend wrote:

    Also you are correct about the project that is opened later by a user that uses 14 version and the project script component does not work any more, we...

    Thom~

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

    July 2, 2019 at 3:45 pm

    #3659367

  • Reply To: Katma Install Error

    Erland Sommarskog wrote:

    Triplicate post. Answer posted in the thread https://www.sqlservercentral.com/forums/topic/katma-install-error-2  

    The user is clearly a spammer; they have a link at the bottom of their post trying to advertise a product.

    Thom~

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

    July 2, 2019 at 2:11 pm

    #3659311

  • Reply To: Are the posted questions getting worse?

    below86 wrote:

    Here is another issue that needs to be addressed(see attached screen shot).  In Jeff's response it makes it look like 'below86 wrote:' but what it shown is what 'Thom...

    Thom~

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

    July 2, 2019 at 1:58 pm

    #3659302

  • Reply To: Import of .dtsx files

    JaybeeSQL wrote:

    Forget it people, I've got someone to do it manually.  No offence taken.

    Glad you got there in the end. If you didn't, it would be worth file having the...

    Thom~

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

    July 2, 2019 at 1:22 pm

    #3659275

  • Reply To: SSIS version

    The DTS version here is the version of SQL Server Integration Services Designer within Visual Studio. I'm using VS 2017 and have version 14.0.3002.92, which is a couple of versions...

    Thom~

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

    July 2, 2019 at 9:03 am

    #3659217

  • Reply To: Executing Flat file query

    This seems like a bad idea; having a bunch of files with (unsanitised?) SQL to be run is a big security hole. Who will have access to put these scripts...

    Thom~

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

    July 2, 2019 at 7:49 am

    #3659206

  • Reply To: Are the posted questions getting worse?

    below86 wrote:

    I come to this site only a few times a day anymore.  Mainly to see what others are complaining about.  The new look is just that visually unappealing to...

    Thom~

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

    July 1, 2019 at 2:20 pm

    #3658902

  • Reply To: io performance

    Few questions: You say that the instance is running on a VM. Are any other VMs running on the VM host? If so, are they using the same storage pool(s)...

    Thom~

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

    July 1, 2019 at 10:37 am

    #3658849

  • Reply To: SQL CAST Float

    BrownCoat42 wrote:

    You need to enclose the math operation.

    You actually don't, the expressions with the mathematical expression in the parentheses is the same and both queries will run:

    Thom~
    

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

    July 1, 2019 at 7:54 am

    #3658807

  • Reply To: Query is not giving correct output of Column (Small_Bale_Weight)

    Thom A wrote:

    If you're asking how that value was calculated, that's a totally different question.

    If we look at why it has a value of 200 we need to look at the...

    Thom~

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

    June 30, 2019 at 11:54 am

    #3658717

  • Reply To: Query is not giving correct output of Column (Small_Bale_Weight)

    akhterhussain80 wrote:

    in small bale weight column where 200 is coming ,there will come 0 and Mix Rummage weight will be 200..

    From your expression ISNULL(SUM(i.weight),0)Small_Bale_weight in your CTE cte. You return...

    • This reply was modified 6 years, 11 months ago by Thom A.

    Thom~

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

    June 30, 2019 at 10:53 am

    #3658711

    • Viewing 15 posts - 856 through 870 (of 5,109 total)