Forum Replies Created

Viewing 15 posts - 4,591 through 4,605 (of 8,731 total)

  • RE: Finding the first credit balance date

    Sure, it can be done. Could you please post DDL and INSERT statements for your sample data?

    Check the following article or the one in my signature to understand how to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 26, 2015 at 2:10 pm

    #1815018

  • RE: SSIS challenge

    Put the path between double quotes (").

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 25, 2015 at 6:18 am

    #1814949

  • RE: Query Execution with rules

    Could you elaborate more on what do you need? I'm not sure what you're trying to do. If you want to apply rules, you might need to change your table...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 1:23 pm

    #1814902

  • RE: Today's Random Word!

    djj (7/24/2015)

    Ed Wagner (7/24/2015)

    Revenant (7/24/2015)

    Ed Wagner (7/24/2015)

    J Livingston SQL (7/24/2015)

    crookj (7/24/2015)

    Ed Wagner (7/24/2015)

    BWFC (7/24/2015)

    Spelling 😀

    Reading

    Writing

    Rithmetic 😀

    Homework

    Boredom

    Trouble (usually follows boredom)

    Tribbles

    Nibbles(.bas)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 1:11 pm

    #1814898

  • RE: need help in converting nvarchar to datetime

    Does this gives you an idea on what to do?

    CREATE TABLE dbo.SampleDates(DateofRecord nvarchar(20));

    INSERT INTO dbo.SampleDates

    VALUES

    ('"04/24/2013'''),

    ('"05/01/2014"')

    --Option 1

    --Just the Query

    SELECT convert(datetime,replace(replace(DateofRecord,'"',''),'''',''))

    FROM dbo.SampleDates

    --Option 2

    --Create new column with correct data type, assign correct values,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 1:05 pm

    #1814894

  • RE: need help in converting nvarchar to datetime

    What do you mean by didn't work?

    Are you trying to change the column definition or just use it as datetime in a query?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 12:56 pm

    #1814890

  • RE: Find any character that isn't a number or letter - confused!

    There's an unanswered question about spaces. Would multiple spaces are valid? Would they be valid only if they're within a single gap but not with multiple gaps?

    Here's the code for...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 8:15 am

    #1814781

  • RE: Find any character that isn't a number or letter - confused!

    rarara (7/24/2015)

    Luis Cazares (7/24/2015)

    Peddi Praveen kumar (7/24/2015)

    Hi,

    here is the solution....

    That's a solution, but it's not the solution. Your lengthy function, does basically what my code does in one line.

    Another simple...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 8:06 am

    #1814776

  • RE: Using PIVOT question - Very newbie

    I'm not sure if you still need it, but here's a way to make it dynamic. I changed the table variable into a permanent table because I didn't want to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 8:04 am

    #1814773

  • RE: selecting max between two dates for a given year

    lsalih (7/24/2015)

    Question: Now that I changed the actual query, I am running into getting more than 1 record per year for the rows which do not match because of grouping....

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 7:40 am

    #1814759

  • RE: Find any character that isn't a number or letter - confused!

    Peddi Praveen kumar (7/24/2015)

    Hi,

    here is the solution....

    That's a solution, but it's not the solution. Your lengthy function, does basically what my code does in one line.

    Another simple solution would be...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 7:34 am

    #1814751

  • RE: SSIS challenge

    If you have 3 different tables going to 3 different files, then you just need a single data flow task with the 3 flows.

    Why do you want to make...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 7:22 am

    #1814747

  • RE: Find any character that isn't a number or letter - confused!

    Do you need to remove the characters that shouldn't be there?

    Or simply identify the values that shouldn't be there?

    The second option is far less complicated as you just need...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 7:02 am

    #1814737

  • RE: Today's Random Word!

    djj (7/24/2015)

    Ed Wagner (7/24/2015)

    Stuart Davies (7/24/2015)

    Ed Wagner (7/23/2015)

    Revenant (7/23/2015)

    SQLRNNR (7/23/2015)

    J Livingston SQL (7/23/2015)

    SQLRNNR (7/23/2015)

    J Livingston SQL (7/23/2015)

    Eirikur Eiriksson (7/23/2015)

    DonlSimpson (7/23/2015)

    Ed Wagner (7/23/2015)

    J Livingston SQL (7/23/2015)

    Revenant (7/23/2015)

    Eirikur Eiriksson (7/23/2015)

    SQLRNNR (7/23/2015)

    cowboy

    dichotomy

    Opposition

    antithesis

    Conflict

    Resolution

    Clarity

    coherent

    disorderly

    conduct

    steward

    care

    Neglect

    Disregard

    Ignore

    Ignorence

    Happyness

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 6:48 am

    #1814729

  • RE: Case statement causes duplicates.

    The problem is not your CASE statement, but the GROUP BY clause. You need to group the same way you're presenting the information, otherwise you'll get unexpected results with apparent...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 24, 2015 at 6:46 am

    #1814726

Viewing 15 posts - 4,591 through 4,605 (of 8,731 total)