Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 5,109 total)

  • Reply To: Weekly (Course) Schedule for Students

    Is this definitely SQL Server? There is no number datatype in SQL Server, and neither is there a varchar2. Yes, this can be achieved in SQL Server, but considering this...

    Thom~

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

    May 10, 2019 at 11:46 am

    #3639785

  • Reply To: Import Large Text File Keep Exact Row Order SSIS

    Do you have a column you can order my in the data that will retain the order of the file? If not, then yes, using a Script Component instead would...

    Thom~

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

    May 10, 2019 at 9:35 am

    #3639737

  • Reply To: Sum fields with a little twist

    This appears to be what your after then. I perform the conditional aggregation inside a CTE, as then you don't need to repeat the CASE expressions for the total:

    Thom~
    

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

    May 9, 2019 at 3:11 pm

    #3639156

  • Reply To: Sum fields with a little twist

    Is this what you're after? If not, can you post your expected results please (don't forget to use the Insert/Edit Code sample button)

    CREATE TABLE #temp ([Type] varchar(50),
    ...

    Thom~

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

    May 9, 2019 at 2:33 pm

    #3639128

  • Reply To: indexing view

    Andrey wrote:

    perhaps SQL synonyms could help, but i'm not sure and it needs testing

    That would give you the error:

    Synonyms are invalid in a schemabound object or a constraint expression.

    Here's...

    Thom~

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

    May 9, 2019 at 1:59 pm

    #3639072

  • Reply To: indexing view

    I think the OP is saying that want to create an index on a view, but that the view will be returning data from other databases. Simply put, you can't....

    Thom~

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

    May 9, 2019 at 1:24 pm

    #3639029

  • Reply To: Delimited Identifiers in code interpreted as BBCode

    Jeff Moden wrote:

    I'm hoping that's not actually a bad thing. 😉

    Being able to turn the software off that's trying to keep your work device "safe" doesn't seem "safe". 😉 It's like...

    Thom~

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

    May 9, 2019 at 10:15 am

    #3638889

  • Reply To: SSIS Script task varaible

    Double post of: https://www.sqlservercentral.com/forums/topic/ssis-script-task-varaible

    Thom~

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

    May 8, 2019 at 8:58 pm

    #3638649

  • Reply To: Are the posted questions getting worse?

    Jonathan AC Roberts wrote:

    It's the Alt key that allows block selection.

    No one saw my brain fart... No one... ... 🙂

    Thom~

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

    May 8, 2019 at 11:17 am

    #3638233

  • Reply To: Are the posted questions getting worse?

    Brandie Tarvin wrote:

    Wow. So apparently I learn something new every day with SQL Server. Yesterday, I accidentally learned that if you highlight a section of code in a SSMS query window...

    • This reply was modified 7 years, 1 months ago by Thom A. Reason: No one

    Thom~

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

    May 8, 2019 at 10:24 am

    #3638216

  • Reply To: Delimited Identifiers in code interpreted as BBCode

    Jeff Moden wrote:

    It WAS working for me before on both places it is no longer working.  I've not made any security level changes in FireFox or Chrome, either.

    Maybe a DNS issue?...

    Thom~

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

    May 8, 2019 at 8:23 am

    #3638148

  • Reply To: Can i create a table from my parameters?

    You could by switching to a Stored Procedure. SSRS, when using syntax like WHERE [Column Name] IN (@Parameter) injects the values into the query instead, replacing the value of @Parameter...

    Thom~

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

    May 7, 2019 at 5:49 pm

    #3637286

  • Reply To: Delimited Identifiers in code interpreted as BBCode

    It worked fine on Windows 10 Edge and Firefox at work, and fine on Ubuntu Firefox at home. Sounds like the problem might be your end, Jeff. Considering that the...

    Thom~

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

    May 7, 2019 at 5:15 pm

    #3637273

  • Reply To: Are the posted questions getting worse?

    Steve Jones - SSC Editor wrote:

      The multi-tabbed item is cool. I have that with ConEmu and use it all the time.

    I've got in the habit of using CSSH at home lately, as I...

    Thom~

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

    May 7, 2019 at 4:15 pm

    #3637247

  • Reply To: Dos and Don'ts of Dynamic SQL

    Jeff Moden wrote:

    On a different note, I'm really happy that they fixed the "code wrapping" and indentation issues on this forum but, unless they limit the vertical height of the code...

    Thom~

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

    May 7, 2019 at 2:45 pm

    #3637190

    • Viewing 15 posts - 1,006 through 1,020 (of 5,109 total)