Forum Replies Created

Viewing 15 posts - 46 through 60 (of 326 total)

  • RE: update still difficult??

    prathibha_aviator (3/14/2013)

    well on a sample table yes it works... On my actual production table it wont the errors that i have been showing you are from my production table

    Can you...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 14, 2013 at 11:06 am

    #1597155

  • RE: update still difficult??

    prathibha_aviator (3/14/2013)

    Infact the same error for all of them like i mentioned before...

    This is the statement

    update employees set ID = EXTENDEDID

    I get

    Msg 512, Level 16, State 1, Procedure trig_AfterFamGroupInsert, Line...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 14, 2013 at 9:29 am

    #1597085

  • RE: update still difficult??

    Did you try the above query ???

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 14, 2013 at 9:16 am

    #1597077

  • RE: update still difficult??

    prathibha_aviator (3/14/2013)

    @ above all

    Well, its just an example... My work place might have had really bad designers when they started designing the database... That Primary key column(ID) is not used...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 14, 2013 at 9:08 am

    #1597067

  • RE: update still difficult??

    What are the errors/problems you are facing when you are running the query?

    Also,

    out of curisoity , why do you have this table structure anyway ..

    ID column with int , which...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 14, 2013 at 3:02 am

    #1596873

  • RE: Precision required

    an easy one for the day !!!

    thanks for the question

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 13, 2013 at 10:30 pm

    #1596809

  • RE: When delimiter is part of the field - How to handle in SSIS

    dfine (3/13/2013)

    I have a CSV file with field delimiter as COMMA (,). The package is working without any issues for few source files, but fails when the field value in...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 13, 2013 at 1:15 am

    #1596379

  • RE: Temp Table Data Types

    bitbucket-25253 (3/12/2013)

    Nice question .. learned something from it ... thanks

    +1

    I gotta learn about Select Into ; as I mostly avoid it , I don't pay attention ...

    I guessed for...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 12, 2013 at 10:20 pm

    #1596347

  • RE: inserting data from one table to another and want to create primary key at same time

    Or , even better , don't use select into ..

    Just create a table first and then Insert values into it ..

    I find it better than Select into .

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 12, 2013 at 12:13 am

    #1595824

  • RE: inserting data from one table to another and want to create primary key at same time

    When you use

    Select Into

    the columns created would take the data type ,nullability etc. properties from the columns available in FROM clause.

    so make sure you have SOFTWARE_NAME_ORIGINAL as NOT NULL...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 12, 2013 at 12:11 am

    #1595823

  • RE: INNER JOIN

    SQLRNNR (3/11/2013)

    Nice and EZ

    +1

    😎

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 11, 2013 at 10:54 pm

    #1595812

  • RE: Doubt in Data Warehouse design...

    ard5karthick (3/11/2013)

    Hi,

    We are creating a Data Warehouse for our Client

    We need to store a list of locations that our company.

    My Colleague says we will store the list of all the...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 11, 2013 at 2:22 am

    #1595410

  • RE: Query in SSRS

    davoscollective (3/3/2013)

    You want to get all data even though you have filtered the data? That doesn't really make sense. If you want all the data, don't filter it.

    Can you explain...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 11, 2013 at 2:13 am

    #1595409

  • RE: Need Help In SSRS

    sagar0838 (3/11/2013)

    Hi everyone i have an issue in SSRS report .i have created a new entry for

    one column of a table.whereas my report is still showing the old value...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 11, 2013 at 2:02 am

    #1595407

  • RE: DATETIME - 3

    kapil_kk (3/11/2013)

    Hi,

    can someone plz explain it in a more simple manner..... explanation in QOTD is very inscrutable for me:cool:

    Inscrutable , is that the right word :ermm:

    well, as explained in the...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 11, 2013 at 1:47 am

    #1595406

Viewing 15 posts - 46 through 60 (of 326 total)