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

tlname tfname schoolid schoolname

steve ulman 151 banksville

john smith 152 carnegi

ricky johnston 153 elementery

steve ulman 154 school

john smith 155 monroville

steve ulman 156 pittsburgh

ricky johnston 157 alleghany

i need

tlname tfname schoolid secondary schoolname

steve ulman...

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

tlname tfname schoolid schoolname

steve ulman 151 banksville

john smith 152 carnegi

ricky johnston 153 elementery

steve ulman 154 school

john smith 155 monroville

steve ulman 156 pittsburgh

ricky johnston 157 alleghany

i need

tlname tfname schoolid secondary schoolname

steve ulman ...

sorry friend

i don't know how to do.

please help me

thanks to edit my question

but please give me solution

see

one teacher

teacher school code

steve ulman 151

steve ulman ...

sorry guys

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

so i changed it and it works

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

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

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

so we can clean up physical boxes on different servers

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

is this looks ok??

i need to convert uaivno= es.escino to decimal

can you please give me the syntax

its in left join

please help me ASAP

I need to monitor

What user is currently working on database.

and what they actually do

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

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

Thanks

Appreciate for Your Quick Response