Forum Replies Created

Viewing 15 posts - 46 through 60 (of 325 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...

    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...

    March 14, 2013 at 9:29 am

    #1597085

  • RE: update still difficult??

    Did you try the above query ???

    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...

    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...

    March 14, 2013 at 3:02 am

    #1596873

  • RE: Precision required

    an easy one for the day !!!

    thanks for the question

    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...

    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...

    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 .

    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...

    March 12, 2013 at 12:11 am

    #1595823

  • RE: INNER JOIN

    SQLRNNR (3/11/2013)

    Nice and EZ

    +1

    😎

    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...

    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...

    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...

    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...

    March 11, 2013 at 1:47 am

    #1595406

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