Forum Replies Created

Viewing 15 posts - 271 through 285 (of 389 total)

  • RE: Today's Random Word!

    SQLRNNR (7/12/2012)


    capn.hector (7/12/2012)


    rhythmk (7/11/2012)


    SQLRNNR (7/11/2012)


    Cliff Jones (7/11/2012)


    crookj (7/11/2012)


    Possinator (7/11/2012)


    SQLRNNR (7/11/2012)


    jasona.work (7/11/2012)


    EL Jerry (7/11/2012)


    SQLRNNR (7/11/2012)


    exploding grapes

    Exploding Gremlins

    "El" Jerry.

    Mogwai

    Gizmo

    Bright light!

    Poltergeist

    They're heeeeere!

    steak and maggots

    Careful

    Security

    Burden

    Donkey

  • RE: unable to load the data

    Raghavender (7/12/2012)


    I have added the data viewer and executed the package but nothing is displayed.

    That means data is not flowing from source itself.

    Check the configuration for all sources as...

  • RE: Using CASE for quieries via a Linked Server (MySQL)

    karen.blake (7/12/2012)


    Hi there,

    I am hoping that you can help me with a problem I am having using CASE in a query via a linked server.

    I have set up a linked...

  • RE: Unable to connect to one of Production database through SSMS

    vinod.saraswat (7/12/2012)


    Hi ALL,

    I need an urgent help on this issue.

    I got the problem that I and team not able to connecto the product server giving following error..

    A network-related or instance-specific...

  • RE: Select 1 top record from each type of record

    rajawat.niranjan (7/12/2012)


    rhythmk (7/11/2012)

    No issue.:-)

    However one question.You did not mention which record you want.So if you want any specific record tweak the query little bit get the name of column for...

  • RE: SQL Server 2008

    rimitha.p (7/11/2012)


    Hi,

    When i am using SQL Server 2008,im writing update query by using the following query

    update PackingHdr set Remarks = 'ABC' where Remarks IS NULL

    but it is not possible...

  • RE: Assign Claims Sequencial Number

    sheridan.zhu (7/11/2012)


    During file transfer into SQL Server, I am trying to assign a unique sequencial number after certain line meets the criteria. For example, in the file, if a...

  • RE: Select 1 top record from each type of record

    rajawat.niranjan (7/11/2012)


    That worked

    Many Thanks @rhythmk 🙂

    No issue.:-)

    However one question.You did not mention which record you want.So if you want any specific record tweak the query...

  • RE: Today's Random Word!

    SQLRNNR (7/11/2012)


    Cliff Jones (7/11/2012)


    crookj (7/11/2012)


    Possinator (7/11/2012)


    SQLRNNR (7/11/2012)


    jasona.work (7/11/2012)


    EL Jerry (7/11/2012)


    SQLRNNR (7/11/2012)


    exploding grapes

    Exploding Gremlins

    "El" Jerry.

    Mogwai

    Gizmo

    Bright light!

    Poltergeist

    They're heeeeere!

    steak and maggots

    Careful

  • RE: Select 1 top record from each type of record

    rajawat.niranjan (7/11/2012)


    Hi All,

    I have got following data:

    ZIP CITY LATITUDE LONGITUDE

    D1Dublin53.34410-6.26749

    D1Dublin53.34673-6.22762

    D1Dublin53.34844-6.25902

    D1Dublin53.34854-6.26882

    D10Dublin53.33020-6.29876

    D11Dublin53.32524-6.25131

    D11Dublin53.36834-6.26759

    D11Dublin53.38450-6.31176

    D11Dublin53.38590-6.29217

    D12Dublin53.32689-6.34291

    D12Dublin53.32960-6.33472

    D12Dublin53.33205-6.29344

    D12Dublin53.33302-6.31857

    D13Dublin53.32130-6.26704

    D13Dublin53.36324-6.21185

    D13Dublin53.36998-6.18986

    D14Dublin53.31511-6.25458

    D14Dublin53.31539-6.23178

    D14Dublin53.31855-6.24850

    D15Dublin53.35659-6.28591

    D15Dublin53.36291-6.33774

    D15Dublin53.36414-6.30097

    D15Dublin53.36933-6.32962

    D15Dublin53.37165-6.33976

    D15Dublin53.41073-6.32775

    D16Dublin53.30240-6.29219

    D16Dublin53.30449-6.23824

    D16Dublin53.31327-6.29392

    D16Dublin53.33793-6.22439

    D17Dublin53.39741-6.23751

    D17Dublin53.39875-6.18809

    D17Dublin53.40402-6.17819

    D17Dublin53.40577-6.19502

    Here I want to select top 1 from each zip and city,

    hence my results should look...

  • RE: Getting Weeks Start Dates for a Given Month.

    rhythmk (7/10/2012)


    Arman Khan (7/10/2012)


    Hello, I need some help from the experts to get the Start date for each week in a given month.

    For example:

    ...

  • RE: Get Column name & table name from value

    Kingston Dhasian (7/11/2012)


    A quick search on this site gave me the below link

    I hope this will be helpfull

    http://www.sqlservercentral.com/scripts/Miscellaneous/65769/

    Hello Kingston,

    If I am not wrong then he wants all columns of tables...

  • RE: unable to load the data

    Raghavender (7/11/2012)


    Please find the attachment.

    Hi Raghavender,

    It is very difficult at our end to tell you what is the problem at your end.

    However the only solution is that try out all...

  • RE: why nvarchar using in sql?

    artcvmna (7/10/2012)


    why nvarchar using in sql?

    I usually use it to support unicode data string which varchar does not support e.g. you can use it to store multilanguage data in database.

    For...

  • RE: Today's Random Word!

    capn.hector (7/10/2012)


    jasona.work (7/10/2012)


    SQLRNNR (7/10/2012)


    Cliff Jones (7/10/2012)


    crookj (7/10/2012)


    Daniel Bowlin (7/10/2012)


    rhythmk (7/9/2012)


    Possinator (7/9/2012)


    SQLRNNR (7/9/2012)


    Cliff Jones (7/9/2012)


    Ray K (7/9/2012)


    Revenant (7/9/2012)


    rhythmk (7/9/2012)


    Brandie Tarvin (7/9/2012)


    Daniel Bowlin (7/9/2012)


    Heatwave

    Heatstroke

    Engine

    Piston

    V6

    V8

    HEMI

    Barracuda

    Fearsome

    Foursome

    Quartette

    Beatles!

    Monkees

    MonkeeMobile!

    wiener mobile

    Hot Dog

Viewing 15 posts - 271 through 285 (of 389 total)