Forum Replies Created

Viewing 15 posts - 24,871 through 24,885 (of 59,102 total)

  • RE: transfer data

    fateme soleimani (1/5/2014)

    very thanks for your guides.but i am low level and i dont sovle my problems.

    please more help me about solve problem.

    best regards

    Understood. This isn't a trivial task,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 5, 2014 at 11:28 am

    #1677599

  • RE: Copy Backup to DVD

    alnawrass2002 (1/5/2014)

    Hi,How can I automate copying Last Backup to DVD using SQL Server Job.

    Regards

    Schedule the manual process that you're currently doing using Windows Scheduler.

    As a bit of a sidebar, I...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 5, 2014 at 11:24 am

    #1677598

  • RE: How to partition table

    arooj300 (1/5/2014)

    whenever we try to upload the data...the application will be hang or it stop uploading data.

    please tell me how to resolve this issue

    Thanks in avance

    Gosh... still not enough information....

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 5, 2014 at 11:16 am

    #1677596

  • RE: Get Previous month data based on condition

    @sql crazy kid,

    Your code now appears to work the same as Micheal's...

    declare @MyData table (Id int not null, StartDate datetime not null, EndDate datetime not null )

    insert into @MyData

    select...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 5, 2014 at 9:27 am

    #1677592

  • RE: sort by serialcode

    sayedkhalid99 (1/4/2014)

    thanks for your feed back jeff, since i already implemented the first solution provided when i received the code in my project just wanted to change that rather...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 5, 2014 at 8:46 am

    #1677591

  • RE: Complex Query

    Christian Graus (1/4/2014)

    I agree. The hard part is working out where the tree stops, and where the return journey begins. That's really what I was trying to do...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 9:25 pm

    #1677576

  • RE: Complex Query

    alhakimi (1/4/2014)

    Hi friends thanks for your input and comments and imagine thats the case.. actually the host system who provides the service gives this limited data export to the client...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 9:13 pm

    #1677574

  • RE: Complex Query

    It's difficult for me to believe that there's no flight table. I don't believe it would be possible to make the given test data without it.

    That, not withstanding, the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 8:15 pm

    #1677569

  • RE: Complex Query

    alhakimi (1/4/2014)

    1- create query

    CREATE TABLE table1(

    [Pax ID] [int] NULL,

    [Reservation] [int] NULL,

    [Surname] [varchar](40) NULL,

    [First Name] [varchar](40) NULL,

    [Pax Type] [char](1) NULL,

    [Flight Date] [smalldatetime] NULL,

    [Flight Number] [varchar](10) NULL,

    [Board] [varchar](3) NULL,

    [Off] [varchar](3) NULL,

    [Original Booking...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 6:40 pm

    #1677565

  • RE: populate excel with data

    happy55 (12/30/2013)

    I want to make a job which will populate an excel sheet with data.

    It will run on a scheduled time.What is the best way to do it

    1. a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 6:11 pm

    #1677564

  • RE: Can't drop, detach or set SUSPECT database to emergency mode

    vinod.s81 (1/4/2014)

    am als having the same problem

    What have you tried? Did you try any of the solutions on this thread? Did you try any other solutions? What...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 12:59 pm

    #1677552

  • RE: Slight Performance issues

    New Born DBA (1/3/2014)

    I am having some performance issue when one of a developer is running a simple query from a view. He is complaining that the DB is really...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 12:55 pm

    #1677550

  • RE: Need T-SQL optimization Help

    To be honest, whomever designed the table with an integer representation of year and month did a great disservice to anyone and everyone using the table and it's going to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 12:47 pm

    #1677549

  • RE: Stored Procedure Logging

    At this point, I have to ask the question...

    WHY are you writing this information out to a file? Why not just write it to a table where you can...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 12:37 pm

    #1677547

  • RE: SUM of COUNT

    nasy_mcs (1/4/2014)

    Hi, can anyone help here?

    Thanks!!

    Add a WHERE clause that limits prd_cd to only those values that you test for in the CASE statements and see if that helps return...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 4, 2014 at 12:29 pm

    #1677546

Viewing 15 posts - 24,871 through 24,885 (of 59,102 total)