Forum Replies Created

Viewing 15 posts - 16,606 through 16,620 (of 26,489 total)

  • RE: SQL Job is getting failed in half the way

    Can't even start to help you. Please post the complete error message you are receiving when the SSIS package is run as a scheduled job.

  • RE: Brain Fried

    I have to agree, it looks like you are doing well. All you can do is learn what you need when you need it, and know where to look...

  • RE: Why use N before any string

    The N in front of a string like this, N'A String Constant', is a UNICODE string. You can find more about these in Books Online, the SQL Server Help...

  • RE: DateFunction

    kaladharreddy15 (3/9/2010)


    Write a query based on Customer table that returns list of customers having same birthday. List all

    groups.

    And what have you done so far to solve this particular problem? ...

  • RE: DateFunction

    kaladharreddy15 (3/9/2010)


    Write a query based on Customer table that finds youngest customer’s birth date and returns all

    customers having that birth date.

    And what have you done so far to solve this...

  • RE: DateFunction

    kaladharreddy15 (3/9/2010)


    Write a query based on Customer table that returns oldest customer for each city. If there are more than

    1 person with same oldest birth date, show all names for...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/9/2010)


    CirquedeSQLeil (3/9/2010)


    Maybe change it to Dr. Lynn Pettis. 😎

    Dr. Lynn Pettis, MVP ?

    Sincerely doubt both Dr and MVP. Checked into the Doctorate Program at Colorado Technical University,...

  • RE: Are the posted questions getting worse?

    I think someone has me confused with someone else here.

  • RE: SQL Injection Attempt

    Elliott W (3/9/2010)


    The code she posted would show you. When I did it, I did it the hard way with an ASCII chart that has hex values.. Hers...

  • RE: Are the posted questions getting worse?

    Well, time for me to get ready to leave. I have another high school soccer game to officiate. I hope this one is better than the 10 -...

  • RE: SQL Injection Attempt

    Take a close look at what I posted. There is an implicit conversion between binary and text in the assignment to the variable @x. All I did was...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/9/2010)


    Lynn Pettis (3/9/2010)


    lmu92 (3/9/2010)


    Lynn Pettis (3/9/2010)


    I think it's time for trip to the desert. Anyone care to join me? I'll put the hippo on a leash....

  • RE: Should I Backup The Systems DBs and If so Which ones and why

    Two reasons, first of the chances of that system remaining in that state for any significant time is small. Things change and you should plan for it now, not...

  • RE: GETDATE in WHERE Clause

    Here is your query rewritten:

    SELECT

    prd.ProductID,

    prd.Category,

    prd.ProductCode,

    prd.Description,

    prd.Price,

    ord.CustomerID,

    ...

  • RE: Are the posted questions getting worse?

    lmu92 (3/9/2010)


    Lynn Pettis (3/9/2010)


    I think it's time for trip to the desert. Anyone care to join me? I'll put the hippo on a leash. 😛

    May I join you?...

Viewing 15 posts - 16,606 through 16,620 (of 26,489 total)