Forum Replies Created

Viewing 15 posts - 361 through 375 (of 7,164 total)

  • RE: How to do CASE WHEN THEN CASE

    tshad (1/30/2016)

    I didn't know there was a return value for isnull.

    In most of the samples on line that is not even mentioned. But I did see a few that...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 30, 2016 at 1:14 pm

    #1855522

  • RE: BIG HELP Needed!!

    cortech (1/30/2016)

    Ok, new development.

    I opened 1433 in my SQL firewall - I created a SQL ODBC connection and it worked!!

    I then ran Linked Tables Manager in Access and entered...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 30, 2016 at 1:10 pm

    #1855521

  • RE: Script to create Triggers

    TheSQLGuru (1/30/2016)

    Such a shame too. But it wasn't fully baked when it was released and it has never gotten the attention it needed/deserved from the product team.

    I could not agree...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 30, 2016 at 1:05 pm

    #1855520

  • RE: BIG HELP Needed!!

    cortech (1/30/2016)

    They double click the db2 file and then it opens in Access. Forms then run.

    Trying non-intrusive changes first...keeping modifying Access (what Ed suggested) as a last resort...

    From what I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 30, 2016 at 12:44 pm

    #1855517

  • RE: Importing Poorly Formatted Text File to SQL

    I wanted to do this with only native SSIS objects but am not seeing a way. Pivot was promising but the source data does not have a grouping attribute, e.g....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 30, 2016 at 10:41 am

    #1855514

  • RE: BIG HELP Needed!!

    cortech (1/30/2016)

    A couple questions:

    1. What or whom is trying to use the Access database when you get this error? Is it a Windows service (something unattended) or an interactive user...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 30, 2016 at 10:04 am

    #1855513

  • RE: BIG HELP Needed!!

    cortech (1/29/2016)

    Using a DSN file

    [ODBC]

    DRIVER=SQL Server

    UID=username

    PWD=password

    DATABASE=db2

    WSID=workstation

    APP=Microsoft Data Access Components

    SERVER=192.168.1.200\data

    Trusted_Connection=Yes

    The DSN settings makes no sense. If you are providing a username and password then why are you also saying it is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 30, 2016 at 9:23 am

    #1855503

  • RE: Simple Solution to Common Problem

    Current shop has everything in one domain but issues admins a second Windows account for use in the prod region. I basically did the same as you, created a shortcut...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 29, 2016 at 9:11 pm

    #1855444

  • RE: OPENROWSET - how to read everything as text

    If you can initiate the process from outside the database engine I would recommend SSIS or BCP. If using only T-SQL is a requirement I would recommend using the BULK...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 29, 2016 at 2:52 pm

    #1855408

  • RE: Deciding not to use a plan

    PHXHoward (1/29/2016)

    Is the size of the variable specified in the prepare statement or somewhere else? Who needs to fix this? SQL developer or Middleware admins in Websphere?

    Sounds like maybe...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 29, 2016 at 2:27 pm

    #1855400

  • RE: Can we delay the execution?Or ReWrite this Query?

    suryahanuma (1/29/2016)

    In short - I need a very very very small delay in inserting the records because I want the function which is in the select statement to work on...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 29, 2016 at 1:38 pm

    #1855382

  • RE: Make Rows to a Column

    Thank you for trying to post test data and your desired output. Next time it would be ideal if you could provide the test data in the form of a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 29, 2016 at 1:01 pm

    #1855368

  • RE: How can I convert char field to be used for calculation?

    mbatchelor (1/29/2016)

    I am trying to use a char field in a calculation with no success.

    .

    .

    .

    I am only getting the current CUR_YR data. I need to extract seven years of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 29, 2016 at 12:55 pm

    #1855366

  • RE: How can I convert char field to be used for calculation?

    reformatted code:

    SELECT REG_CONFIG.CUR_YR_DFLT,

    SECTION_MASTER.YR_CDE,

    CAST(ROUND(REG_CONFIG.CUR_YR_DFLT - 1, 0) AS INT) AS NEWYEAR,

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 29, 2016 at 12:53 pm

    #1855363

  • RE: How to do CASE WHEN THEN CASE

    tshad (1/29/2016)

    I am trying to do a case statement without having to a bunch of and's and or's. This is being done in a set statement.

    I tried to do...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 29, 2016 at 12:50 pm

    #1855360

Viewing 15 posts - 361 through 375 (of 7,164 total)