Forum Replies Created

Viewing 15 posts - 406 through 420 (of 1,048 total)

  • RE: The US Holiday

    yooooooooo!!!!!! :hehe:

    What a day 😛

    feels awsome when you earned 7 points at start of the day 😀

    Thanks Steve:-)

    July 3, 2013 at 11:17 pm

    #1629729

  • RE: sql sales

    You can use LIKE keyword for this-

    SELECT dbo.Trnasction.Salesorder, dbo.SalesPerson.SalesPersonName

    FROM dbo.Trnasction CROSS JOIN

    dbo.SalesPerson

    WHERE dbo.SalesPerson.SalesPersonName LIKE 'John%'

    July 3, 2013 at 4:51 am

    #1629475

  • RE: T-SQL Like

    Nice question and nice explanation from Iggy and Hugo 🙂

    +1

    July 3, 2013 at 4:41 am

    #1629469

  • RE: Information displaying incorrectly.....

    I have solved my issue 🙂

    July 3, 2013 at 4:36 am

    #1629463

  • RE: Move Log file

    Abu Dina (7/1/2013)

    RIGHT-CLICK folder, click properties then Security tab, click EDIT then give the SQL Server Service account Full control of the folder.

    ohhh yes, that was permission issue with the...

    July 1, 2013 at 8:10 am

    #1628722

  • RE: Move Log file

    HanShi (7/1/2013)

    1. Take the database OFFLINE

    2. copy the LOG file to the new location

    3. Change the location in the master database with code:

    ALTER DATABASE [dbname] MODIFY FILE (NAME =...

    July 1, 2013 at 7:57 am

    #1628715

  • RE: Move Log file

    GilaMonster (7/1/2013)

    Operating system error 5 is Access Denied. The SQL Server service does not have full rights on that folder.

    How to grant it ful rights?

    July 1, 2013 at 7:53 am

    #1628714

  • RE: Move Log file

    kapil_kk (7/1/2013)

    Hi,

    I have data file and log file at different location.

    data file at location:

    D:\Folder1\test.mdf

    while log file at place

    D:\folder2\test_log.ldf

    Now I want to move this log file to D\folder1\test_log.ldf

    How can I...

    July 1, 2013 at 7:40 am

    #1628708

  • RE: Move LDF file

    sorry I posted it a wrong place....

    July 1, 2013 at 7:35 am

    #1628704

  • RE: Query suggestion

    Bhaskar.Shetty (7/1/2013)

    You can create a trigger on Table A and update the Table B directly, why to create Table C just for later joining it with TableB.

    thanks Bhaskar, magic tables...

    July 1, 2013 at 1:32 am

    #1628623

  • RE: Fun with real and float

    Danny Ocean (6/30/2013)

    Good question with real fun 😀

    +1 😛

    July 1, 2013 at 12:24 am

    #1628606

  • RE: Query suggestion

    Is this approach is right?

    If I create a trigger on table A and insert those voucherno into another tableC...after that using JOIN I can update column modifieddate of table B...

    July 1, 2013 at 12:23 am

    #1628605

  • RE: Query Help

    Cadavre (6/30/2013)

    kapil_kk (6/30/2013)

    thnks its working.. but can you plz explain me this part of query:

    SUBSTRING(VoucherNo,2,LEN(VoucherNo)) - ROW_NUMBER() OVER(ORDER BY VoucherNo, TransNo)

    Sure. I'm removing the character from the start of the...

    July 1, 2013 at 12:01 am

    #1628603

  • RE: Top 2 with Count

    niladri.primalink (6/30/2013)

    hi All,

    Thanks for your reply. it is now working fine

    @kapil: your code has helped a lot. Thanks buddy.

    thanks Niladri, but Sean is right as he said using TOP...

    July 1, 2013 at 12:00 am

    #1628602

  • RE: Query Help

    Cadavre (6/29/2013)

    kapil_kk (6/29/2013)

    Srry that was typo misktake in my question n i Have corrected that...

    that was trns1 only not trns2...

    I tried it but not it is not possible with min...

    June 30, 2013 at 10:53 am

    #1628554

Viewing 15 posts - 406 through 420 (of 1,048 total)