Forum Replies Created

Viewing 15 posts - 9,601 through 9,615 (of 26,489 total)

  • RE: Data Comparison

    bpowers (9/13/2012)

    The goal is to find out which permissions one group has that another group does not, or vise verse.

    If so, then why not:

    Group ID ...

    September 13, 2012 at 10:38 am

    #1537337

  • RE: How is DDL migrated in an Availability Group?

    Yes, yes, and yes.

    September 13, 2012 at 10:35 am

    #1537334

  • RE: GO Part 2

    Sean Lange (9/13/2012)

    honza.mf (9/13/2012)

    Sean Lange (9/13/2012)

    Good question.

    For everybody who seems to be hung on the verbiage I can only say "GET OVER IT". English is not the native tongue of...

    September 13, 2012 at 9:56 am

    #1537309

  • RE: Need Help --Data flow script transformation component / T-SQL / CLR Function ????

    Hate to say it, but I have no idea what is being asked here either.

    September 13, 2012 at 9:18 am

    #1537283

  • RE: Date Range in my SQL report

    D-SQL (9/13/2012)

    Ill try this out. I copy pasted the script not the one you updated they are both the same except the where clause. The reason they needed dbo.tblLoan.Expected_Close =...

    September 13, 2012 at 9:07 am

    #1537275

  • RE: UniqueIdentifier as a Primary Key

    Jeff Moden (9/12/2012)

    alanspeckman (9/12/2012)

    What prompted me to question this was my coworker said it was a best practice when showing me a database design. I remembered Paul's video from...

    September 13, 2012 at 9:04 am

    #1537270

  • RE: NOT IN query very expensive, 100% CPU

    scogeb (9/13/2012)

    Jeff Moden (9/12/2012)

    Have you tried the NOT IN without the DISTINCT?

    Also, what's with all the LTRIM/RTRIM stuff? Data should be properly stored without leading spaces and trailing spaces...

    September 13, 2012 at 8:39 am

    #1537252

  • RE: column to calculate the balance stock dynamically

    rc_stone_1 (9/13/2012)

    Actually, I am using 2012; ...

    May I suggest that you post your question in a more appropriate forum in the future? You did post this in...

    September 13, 2012 at 8:25 am

    #1537237

  • RE: Data drive space issue

    SQLCrazyCertified (9/13/2012)

    Lynn Pettis (9/13/2012)

    Sounds to me that you need to add disks to your server so you have more space. Another alternative is to look at archiving old data...

    September 13, 2012 at 8:20 am

    #1537235

  • RE: Blank the data in row from Position 50-74

    Rakesh.Chaudhary (9/13/2012)

    Thanks to all for the replies. The solution given by Lynn and Chris was Perfect....

    All the work was Chris's, all I did was offer a slight change...

    September 13, 2012 at 8:12 am

    #1537230

  • RE: Data drive space issue

    Sounds to me that you need to add disks to your server so you have more space. Another alternative is to look at archiving old data from your database(s)...

    September 13, 2012 at 8:11 am

    #1537228

  • RE: Requeired Date format : 13 Sep, 2012

    Skanda (9/13/2012)

    Hi,

    am using below statement in a select statement,

    " e.expiration_date" is a date fromat column,

    i want the date should be displayed in 13 Sep, 2012 fromat.

    case when ( rtrim(e.expiration_date)is...

    September 13, 2012 at 7:55 am

    #1537213

  • RE: Date Range in my SQL report

    Is this what you are trying to accomplish?

    SELECT

    -- TOP (100) PERCENT << Totally unnecessary

    ob1.Name AS Agent,

    COUNT(ln.Object_ID) AS LoanCount,...

    September 13, 2012 at 7:42 am

    #1537197

  • RE: Blank the data in row from Position 50-74

    ChrisM@Work (9/13/2012)

    STUFF() is perfect for this:

    SELECT

    Data,

    ChangedData = STUFF(Data,50,25,SPACE(25))

    FROM ( -- note: '[' is position 49 and ']' is position 75

    SELECT Data = 'ZY0503400000234567891234567890110000000000088975[_5668550000000XXXXXXXXXXX]'

    ) d

    WHERE LEFT(Data,8) = 'ZY050340'

    Or...

    September 13, 2012 at 7:26 am

    #1537186

  • RE: Date Range in my SQL report

    D-SQL (9/12/2012)

    Yes this is the same query they just wanted instead of actual date range tblProcessingFile.Funded to (dbo.tblLoan.Expected_Close = 9) because some actual close on the 1st through the 5th.

    Is...

    September 13, 2012 at 6:15 am

    #1537151

Viewing 15 posts - 9,601 through 9,615 (of 26,489 total)