Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 2,648 total)

  • RE: How to add year to membercode already exist on table firstprintcardfooter

    ahmed_elbarbary.2010 - Monday, January 28, 2019 9:13 PM

    Problem

    Cannot add year to this query 

    SELECT FirstPrintCardFooter.FooterNotes,FirstPrintCardFooter.PrintFlag, dbo.VMainMembers.TransactionNo,dbo.VMainMembers.PaymentDate, dbo.Members.MemberCode, dbo.Members.SpecialCode, dbo.Members.Name,CAST(CAST(LEFT(dbo.Members.SpecialCode, CHARINDEX('/', dbo.Members.SpecialCode...

    January 29, 2019 at 6:33 am

    #2020398

  • RE: Beginners Question

    Jim-S - Tuesday, January 29, 2019 5:09 AM

    Hi Guys,

    I clearly don't understand how SQL deals with negative selection.

    Please consider the following:

    [code...

    January 29, 2019 at 5:23 am

    #2020386

  • RE: Equivalent of 'DECODE' in sql

    rachit.agarwal2011 - Tuesday, January 29, 2019 4:40 AM

    decode(e.V_Billing_Currency_Code,a.V_CHECK_CURRENCY_CODE,d.N_Applied_Amount,decode(a.N_Exchange_Rate,0,0,(d.N_Domain_Amount/ a.N_Exchange_Rate)))

    Could anyone help me in converting this to CASE statement

    I think this...

    January 29, 2019 at 5:15 am

    #2020384

  • RE: Order BY clause in View using Stuff Function.

    This should do it:
    SELECT V1.F_PRODUCT,
           STUFF((SELECT ',' + V2.F_TEXT_CODE
                    FROM (SELECT V3.F_PRODUCT,
         ...

    January 29, 2019 at 4:33 am

    #2020381

  • RE: Order BY clause in View using Stuff Function.

    jkramprakash - Tuesday, January 29, 2019 3:43 AM

    SELECT V1.F_PRODUCT,
      F_TEXT_CODES = STUFF((SELECT DISTINCT TOP (1000000)',' + V2.F_TEXT_CODE FROM first_view V2...

    January 29, 2019 at 4:06 am

    #2020378

  • RE: Query Question

    dougsto - Monday, January 28, 2019 1:43 PM

    I have a table that contains multiple fields:
    Diagnosis1
    Diagnosis2
    Diagnosis3
    Diagnosis4
    Diagnosis5
    Diagnosis6
    Diagnosis7
    Diagnosis8
    Diagnosis9
    each field only contain codes, the descriptions are...

    January 28, 2019 at 1:50 pm

    #2020330

  • RE: Order BY clause in View using Stuff Function.

    Have you tried adding an order by in the stuff:
    F_TEXT_CODES = STUFF((SELECT DISTINCT ',' + V2.F_TEXT_CODE FROM FIRST_VIEW V2
    WHERE V1.F_PRODUCT = V2.F_PRODUCT ORDER BY colToOrderBy...

    January 28, 2019 at 10:35 am

    #2020312

  • RE: Sanity check: developers storing ad-hoc production backups on their workstations

    scareddba - Monday, January 28, 2019 12:31 AM

    Our team of eight developers stores ad-hoc production database backups on their workstations. Some in...

    January 28, 2019 at 9:54 am

    #2020308

  • RE: how to track DB read-write operations for 30 days without using Profiler

    I think you can use perfmon for this. Just select the statistics you want to track and you can get it to write to a flat file or a database...

    January 28, 2019 at 7:42 am

    #2020282

  • RE: How to schedule database backup in SQL Server Express edition

    binutb - Sunday, January 27, 2019 11:47 AM

    Hi,

    How to take/schedule database backup in SQL Server Express edition (latest version)
    Required log backup every...

    January 27, 2019 at 1:23 pm

    #2020228

  • RE: Query tuning with conditional aggregation

    I was wondering how much time was taken going through a 900 line case statement 1 million times.
    It would certainly contribute to the runtime of the query.

    January 24, 2019 at 7:59 am

    #2019957

  • RE: TempDB

    sqlfriends - Wednesday, January 23, 2019 3:46 PM

    Can SQL server have multiple Tempdb, and assign users to use different tempdb like Oracle...

    January 24, 2019 at 4:34 am

    #2019925

  • RE: Get total count for similar string

    Helpseeker - Thursday, January 24, 2019 1:43 AM

    If i use group by left(OU, 7) am getting the desired output only in terms...

    January 24, 2019 at 3:49 am

    #2019921

  • RE: very slow select

    Tomys - Wednesday, January 23, 2019 2:28 PM

    Thanks for the reply. I basically want to just select and wouldn’t update any rows....

    January 23, 2019 at 2:37 pm

    #2019883

  • RE: very slow select

    Tomys - Wednesday, January 23, 2019 2:05 PM

    Thanks guys I actually can’t even see the fragmentation on the index when I run...

    January 23, 2019 at 2:12 pm

    #2019877

Viewing 15 posts - 1,756 through 1,770 (of 2,648 total)