Forum Replies Created

Viewing 15 posts - 10,141 through 10,155 (of 15,381 total)

  • RE: How to correlate data between two tables

    Also there needs to be some rationale more than just name for when there are more than 1 child rows.

    Consider this:

    select * from #oldAccount where Name = 'MyAccount1' order by...

    November 5, 2012 at 2:09 pm

    #1556205

  • RE: How to correlate data between two tables

    Zeev Kazhdan (11/5/2012)

    You're correct - the values for #oldAccount.newId and #oldAccount.newParentId will come from #newAccount.Id and #newAccount.ParentId respectively. An only common field between the two tables is Name

    Thank you

    But can...

    November 5, 2012 at 1:46 pm

    #1556197

  • RE: 70-461

    goelshobhit79 (11/5/2012)

    hii

    i also prepare for 70-461 so plzz provide me softcopy of book r dumps if u have plzzz

    thnks in advance

    my id- goelshobhit79@gmail.com

    dumps violate the agreement with...

    November 5, 2012 at 1:34 pm

    #1556194

  • RE: create table

    Also given the sheer number of columns you are going to have a number of these that are mostly null. You should take a look at sparse columns.

    http://msdn.microsoft.com/en-us/library/cc280604%28v=sql.105%29.aspx

    November 5, 2012 at 12:46 pm

    #1556188

  • RE: create table

    harri.reddy (11/5/2012)

    hi,

    i need to create table with 1000 column with varchar(100), for every column.

    is there any way i can do it faster,instead of doing it manually and writing each of...

    November 5, 2012 at 12:15 pm

    #1556182

  • RE: How to correlate data between two tables

    Zeev Kazhdan (11/5/2012)

    I need to update newId and newParentId of #oldAccount with Id and ParentId of #newAccount respectively.

    At the moment I'm only able to update #oldAccount table with newId and...

    November 5, 2012 at 11:16 am

    #1556167

  • RE: How to correlate data between two tables

    Zeev Kazhdan (11/5/2012)

    Point taken - have updated my original post

    Thanks for the ddl and sample data. I still have no idea what you are trying to do here.

    November 5, 2012 at 10:55 am

    #1556160

  • RE: I have a dilemma

    Oksana March (11/5/2012)

    Hi everyone,

    I have a dilemma and need your advice.

    We have a customer that runs a report that retrieves very detailed data and takes about 5 minutes to...

    November 5, 2012 at 10:27 am

    #1556150

  • RE: How to correlate data between two tables

    Your question and the details are very clear to you. Unfortunately we don't know what your tables or data looks like and we not familiar with your project. We need...

    November 5, 2012 at 10:23 am

    #1556148

  • RE: Top 20 count

    jerome.morris (11/5/2012)

    The amount off calls raiesed by an operator, so I thought counting the ID would give me this which it does, but I want the operator with the most...

    November 5, 2012 at 9:50 am

    #1556132

  • RE: delete top 1000 rows from table

    yogi123 (11/5/2012)

    Hello

    I need to delete 1000 rows from table and it should do it batch wise.

    means

    i need to loop delete statement that delete top 1000 rows.

    please help me

    Why do you...

    November 5, 2012 at 9:45 am

    #1556129

  • RE: Autonumber on a field that doesn' have increlent or identity

    Resender (11/5/2012)

    Hello all,

    Quick question

    I got a table with a varchar(20) field as primary key

    the result has to be

    W0001

    W0002

    ....

    The data is coming from existing tables and I'm using a merge...

    November 5, 2012 at 9:38 am

    #1556125

  • RE: Top 20 count

    jerome.morris (11/5/2012)

    Hi all, I was wondering if this is possible, I use the query below which is working great if be it a little slow as table is huge. I...

    November 5, 2012 at 9:31 am

    #1556118

  • RE: Not generating run time

    dwilliscp (11/5/2012)

    I have the SQL, listed below, what I would like to do is to get the fractions down to two places (0.25), but looking at the convert function it...

    November 5, 2012 at 9:16 am

    #1556108

  • RE: how to insert image in sql server 2005

    DiverKas (11/5/2012)

    sanjay.dakolia (11/5/2012)

    hi,

    i want to insert image into sql server using sql query. please help.

    thanks in advance

    sanjay

    It is generally considered bad practice to store images in...

    November 5, 2012 at 8:54 am

    #1556098

Viewing 15 posts - 10,141 through 10,155 (of 15,381 total)