Forum Replies Created

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

  • RE: divide column by primary and secondary

    surma.sql (5/2/2012)


    this is the query

    select t.tlname,t.tfname, t.schoolid, s.schoolname from teacher t join school s on

    t.schoolid = s.schoolid

    result

    tlnametfnameschoolidschoolname

    steveulman151banksville

    johnsmith152carnegi

    rickyjohnston153elementery

    steveulman154school

    johnsmith155monroville

    steveulman156pittsburgh

    rickyjohnston157alleghany

    i need

    tlnametfnameschoolidsecondary schoolname

    steveulman...

  • RE: divide column by primary and secondary

    this is the query

    select t.tlname,t.tfname, t.schoolid, s.schoolname from teacher t join school s on

    t.schoolid = s.schoolid

    result

    tlnametfnameschoolidschoolname

    steveulman151banksville

    johnsmith152carnegi

    rickyjohnston153elementery

    steveulman154school

    johnsmith155monroville

    steveulman156pittsburgh

    rickyjohnston157alleghany

    i need

    tlnametfnameschoolidsecondary schoolname

    steveulman ...

  • RE: divide column by primary and secondary

    sorry friend

    i don't know how to do.

    please help me

  • RE: divide column by primary and secondary

    thanks to edit my question

    but please give me solution

  • RE: divide column by primary and secondary

    see

    one teacher

    teacher school code

    steve ulman 151

    steve ulman ...

  • RE: Maintenance Plan Problem

    sorry guys

    i check comparability level and its 70 , suppose to be 90.

    so i changed it and it works

  • RE: copy database

    this is command that i am using

    backup database sasixp

    to

    disk ='\\10.15.1.40\d$\sasixp.bak'

    i need to store on 10.15.1.40 server

    this is error

    Msg 911, Level 16, State 11, Line 1

    Could not locate entry in...

  • RE: copy database

    so can you give me backup t-sql

    because i have to backup from allg-ad1-dc server

    and when i try to take backup it throws error

  • RE: move data file to centralized server

    to have 63 different copies of the MDF file on the archive server

    so we can clean up physical boxes on different servers

  • RE: decimal to char

    replace(space(1)+replace(cast (uaivno= es.escino as varchar),'.',''),' ','0')

    is this looks ok??

  • RE: decimal to char

    i need to convert uaivno= es.escino to decimal

    can you please give me the syntax

    its in left join

    please help me ASAP

  • RE: User Activity

    I need to monitor

    What user is currently working on database.

    and what they actually do

  • RE: Compatibility level

    Because

    SQL Server 2008 can work for Compatibility level 90 (for SQL Server 2005) and 80 (for SQL Server 2000)

    but SQL Server 2005 can't work on Compatibility level...

  • RE: sql count with inner join

    Hey

    Try this

    May be this one will help

    select

    Students.Gender as Gender,

    COUNT(Attendance.studentid) as Absentees,

    max(Sections.studentid) as Presentees,

    from Attendance inner join Students

    on Students.StudentId=Attendance.StudentId

    inner join Sections on Sections.CourseId=Students.CourseId

    group by Students.Gender

  • RE: RUN Stored Procedure

    Thanks

    Appreciate for Your Quick Response

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