Forum Replies Created

Viewing 15 posts - 901 through 915 (of 2,462 total)

  • RE: Are the posted questions getting worse?

    Anyone want to take a stab at this. Essentially the OP needs a csv splitter that handles text qualifiers; Eirikur Eiriksson's RFC-4180 compliant splitter from this article: This article[/url] would...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 25, 2016 at 10:31 am

    #1867763

  • RE: Processing strings.

    Are you really on SQL Server 2008? If you were using SQL 2012 this article would get you 90% there:

    http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/%5B/url%5D

    I'm going to play around with a couple ideas and...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 25, 2016 at 9:25 am

    #1867754

  • RE: sql and stored procedure

    John Mitchell-245523 (3/24/2016)

    Those somewhat contrived requirements make this sound like a homework assignment. Why can't you create any temp tables or new procedures?

    John

    This is actually a common business requirement....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 24, 2016 at 9:50 am

    #1867497

  • RE: Dynamic Lag Function

    Provided that the rank_pos is sequential and there are no gaps you use LEAD like this:

    SELECT t.Score, Rank_pos = ISNULL(t.Rank_pos,X.Rank_pos+1)

    FROM

    (

    SELECT score, Rank_pos, xx = LEAD(Score,1,1) OVER...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 24, 2016 at 9:37 am

    #1867491

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/24/2016)

    <headdesk>

    One of my coworkers just came up with the worst joke ever.

    Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't join a table!

    Will...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 24, 2016 at 8:38 am

    #1867458

  • RE: Split without delimiter based on postion into multiple columns

    I was curious and looked at the thread.

    ChrisM@home (10/22/2012)

    yuvipoy (10/22/2012)

    Ok, thanks. Can you give an example of how the data from this output table would be used please?

    ChrisM as...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 24, 2016 at 8:28 am

    #1867447

  • RE: indexes-non clustered

    db8 (3/23/2016)

    preparing T-SQL ,

    they told me we can sort by using ,with index clause.

    don't know what exactly use of this with index clause I will confirm on this...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2016 at 10:43 pm

    #1867311

  • RE: FOR XML Path

    ringovski (3/23/2016)

    Thanks Orlando and Alan for the replies.

    Is dbo.splitcsv a reserved table or function somewhere as i am unable to find it within the DB?

    It's a custom, user-created function which...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2016 at 8:42 pm

    #1867299

  • RE: FOR XML Path

    Let's reformat the code to make it more readable:

    SUBSTRING

    (

    (

    SELECT ', ' + gen_Firstname + ' ' + gen_Lastname

    FROM...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2016 at 7:35 pm

    #1867288

  • RE: Talking baseball

    Ray K (3/23/2016)

    Steve Jones - SSC Editor (3/23/2016)

    Who believes it?

    http://espn.go.com/mlb/story/_/id/15051882/alex-rodriguez-new-york-yankees-retire-2017-season

    Interesting.

    I won't say whether or not I believe it, but whether or not he actually does, that's his prerogative. ...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2016 at 6:08 pm

    #1867282

  • RE: Are the posted questions getting worse?

    ChrisM@Work (3/23/2016)

    How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

    The idea of presenting...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2016 at 1:56 pm

    #1867230

  • RE: Counting

    This is my "get numbers" or "fntally" function which has served me well.

    I started with what I've learned from Jeff Moden including the 0 or 1 start functionality. Then added...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2016 at 12:20 pm

    #1867196

  • RE: Avoid Blank Values in a column

    Stephanie Giovannini (3/23/2016)

    David McKinney (3/23/2016)

    A slight variation (although I've not got SQL installed to test it.)

    CONSTRAINT ck_xxx CHECK ('' not in (c1,c2,c3,c4,c5))

    Would you kindly check and let me...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2016 at 11:26 am

    #1867180

  • RE: Which indexes out of MISSING INDEXes report are most important to implement?

    Grant Fritchey (3/23/2016)

    Happy to help out. I'm rewriting the execution plans book. It should be done soon I hope.

    I finished your execution plan book while I was on vacation last...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 23, 2016 at 11:18 am

    #1867179

  • RE: how to export and import table single table in databe

    There's a bunch of ways. Easiest would be:

    In SQL Server Management Studio right-click the table then navigate to "export" and walk through use the wizard. The most common format/output is...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    March 22, 2016 at 11:07 pm

    #1866988

Viewing 15 posts - 901 through 915 (of 2,462 total)