Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 5,109 total)

  • Reply To: Update trigger and concurrency issue

    Seggerman-675349 wrote:

    thanks guys the fix was to pass in Updatedt=Updatedt the trigger itself was provided as required by the DBA wacky but that's the way they do things so I...

    Thom~

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

    April 12, 2019 at 9:31 pm

    #3177250

  • Reply To: t-sql 2012 replace part of value in a field with a different value

    Can you post some sample data and the results you expect please? Make sure you're posting the data as formatted text (like you should be when pasting code). You can...

    Thom~

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

    April 12, 2019 at 7:48 pm

    #3169902

  • Reply To: Splitting Rows Into Columns

    OK, well, here's the FULLY dynamic answer. This'll handle additional columns to your table, and additional dates. It's ugly, but it works. Is this a good idea, certainly not, but...

    • This reply was modified 7 years, 2 months ago by Thom A.

    Thom~

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

    April 12, 2019 at 6:47 pm

    #3166695

  • Reply To: Splitting Rows Into Columns

    I'm guessing you're wanting something a bit more dynamic here?

    Thom~

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

    April 12, 2019 at 4:06 pm

    #3162141

  • Reply To: Creating and Joining CTEs in SQL

    Lynn Pettis wrote:

    The problem is that people are taught to do this as a crutch to insure that the previous statement is terminated by a semicolon instead of being taught to...

    Thom~

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

    April 12, 2019 at 3:19 pm

    #3160302

  • Reply To: Creating and Joining CTEs in SQL

    Eric wrote:

    Ok I have changed the code.  I added a things in the original code just because I was desperate. I tried changing the code closer to the original way...

    Thom~

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

    April 12, 2019 at 3:12 pm

    #3160166

  • Reply To: Creating and Joining CTEs in SQL

    There a few problems here, and each time I look at it I find another.

    Firstly you are using the ‘’ characters, where you should be using ' for literal strings....

    Thom~

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

    April 12, 2019 at 3:12 pm

    #3160154

  • Reply To: Creating and Joining CTEs in SQL

    Binned this answer

    • This reply was modified 7 years, 2 months ago by Thom A. Reason: Yeah, more errors than I first though
    • This reply was modified 7 years, 2 months ago by Thom A. Reason: Binned

    Thom~

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

    April 12, 2019 at 2:59 pm

    #3159730

  • Reply To: Creating and Joining CTEs in SQL

    This is one reason why I dislike people being taught that a CTE "starts" with a semi-colon (;), because it doesn't. ; is a statement terminator, not a statement "beginningator"...

    Thom~

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

    April 12, 2019 at 2:55 pm

    #3159503

  • Reply To: Derived colum expression with strings removing 0

    I assume Branch_key is some kind of numerical data type? Numerical data types don't store leading zeros. Assuming that Branch_key should have 6 characters (as you're casting to a (DT_STR,6,1252)...

    Thom~

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

    April 12, 2019 at 2:36 pm

    #3158468

  • Reply To: Update trigger and concurrency issue

    That trigger is flawed, it assumes one row will only be affected. If inserted or deleted contain more than 1 row, what do you suppose these 2 statements will do?

    Thom~

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

    April 12, 2019 at 2:02 pm

    #3157265

  • Reply To:

    CanuckBuck wrote:

    Because of the problems I've experienced editing my post previously I'm concerned that I may loose it again, leading to more confusion.

    The edit button is in the top...

    Thom~

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

    April 12, 2019 at 1:51 pm

    #3157036

  • Reply To: Is there any way to flag or report a user/post?

    yemeradil15 has made a couple of spam topics today Steve; if anyone can remove.

    Thom~

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

    April 12, 2019 at 11:13 am

    #3151658

  • Reply To: Making report run for different users in a single subscription.

    The simple answer is, you can't (not out of the box). What you are looking for is a Data Driven Subscription, and that is an Enterprise feature.

    That's not to say,...

    Thom~

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

    April 12, 2019 at 11:07 am

    #3151458

  • Reply To: SQL Server

    SQL Server developer is the full version of SQL Server Enterprise, but is allowed only the development work (using it in a production environment is against the terms of the...

    Thom~

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

    April 12, 2019 at 10:25 am

    #3150763

Viewing 15 posts - 1,126 through 1,140 (of 5,109 total)