User Profile

Collapse

Profile Sidebar

Collapse
bashaa
bashaa
Last Activity: Nov 17 '07, 03:30 PM
Joined: Nov 17 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • bashaa
    replied to get max values
    there is no stright way to find the max value in a row among the column.

    see the following example ,to find the solution for ur problem.
    replace the ur identity column with id column.


    create table test2(id int identity(1,1),m ar1 decimal(15,3),m ar2 decimal(15,3),m ar3 decimal(15,3),r es decimal(15,3))

    insert into test2 values(12.00, 11.00, 21.00,0)
    insert into test2 values(11.00,...
    See more | Go to post

    Leave a comment:


  • bashaa
    replied to problem on blank space
    use right() function to find the row.

    delete from list where right(remark,1) ='p'....
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...