Viewing 15 posts - 46 through 60 (of 61 total)
surma.sql (5/2/2012)
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...
May 2, 2012 at 4:38 pm
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 ...
May 2, 2012 at 4:29 pm
sorry friend
i don't know how to do.
please help me
May 2, 2012 at 4:13 pm
thanks to edit my question
but please give me solution
May 2, 2012 at 3:03 pm
see
one teacher
teacher school code
steve ulman 151
steve ulman ...
May 2, 2012 at 2:59 pm
sorry guys
i check comparability level and its 70 , suppose to be 90.
so i changed it and it works
May 1, 2012 at 1:01 pm
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...
April 30, 2012 at 1:51 pm
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
April 30, 2012 at 1:32 pm
to have 63 different copies of the MDF file on the archive server
so we can clean up physical boxes on different servers
April 30, 2012 at 8:33 am
replace(space(1)+replace(cast (uaivno= es.escino as varchar),'.',''),' ','0')
is this looks ok??
April 26, 2012 at 8:11 am
i need to convert uaivno= es.escino to decimal
can you please give me the syntax
its in left join
please help me ASAP
April 26, 2012 at 8:03 am
I need to monitor
What user is currently working on database.
and what they actually do
April 25, 2012 at 1:55 pm
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...
April 13, 2012 at 10:11 am
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
April 12, 2012 at 9:33 am
Viewing 15 posts - 46 through 60 (of 61 total)