Dose MS Sell SQlSerever With Student Rate?
Apr 4, 2006Dose MS sell SQlSerever with student rate? If so, which website do I
buy from?
ADVERTISEMENT
A Bug On Sqlserever
Oct 25, 2000I'm using sql server extended store procedure xp_send mail to send mails from the sql server, at some places it loops i dont know where ant what makes it to loop, even if i type sql statement in the plsql window it sends approximately 512 mails but with different messages and subjects and i really dont know where it picks those details from, i'm totally lost. is this a bug on sql server. any info on this is apperciated, Thank you in advance.
View 7 Replies View RelatedCounting Only Countries That Can Sell A Product Category?
May 20, 2008In my data, I'm looking to find how many countries purchased a specific category, and how many countries total can sell the category in question.
(only certain countries sell each category)
This will probably be represented with a many to many relationship between country and category (in order to show the restriction between category and country).
How would one write a calculation to determine how many countries purchased a specific category, and how many countries total can sell the category in question?
Stores In Australia That Sell SQL Server 2005 Developer Edition
Oct 25, 2007Does anyone know which stores in Australia sell SQL Server 2005 Developer Edition. I want to buy it from a store not online, thanks...
View 1 Replies View RelatedDose Sp_helptext Loss Something?
Aug 8, 2007I am using sp_helptext to generate script of stored procedure. However someone said sp_helptext loss something if stored procedure is big. That means the script is not completed. Is it true?
Thanks
ZYT
Dose Not Build SSISDeploymentManifest
Nov 2, 2007Hello,
This might be a very basic problem. I have two SSIS solutions. I was able to build SSISDeploymentManifest for one solution, but not the other. When I press BUILD, it does create dtsx in bin folder but I do not see any Deployment folder created nor manifest file. What did I do wrong?
Why The Report Parameter Dose Not Take Effect?
Nov 6, 2006Hi, all experts here,
Thank you very much for your kind attention.
I am encountering a problem with reports built on my SQL Server 2005 Reporting Services Server. The reports parameters do not take effect at all? I chose the value from the report parameter list, but the result returned the whole report data. Why is that? And how can I solve this problem? Really need help.
Thanks a lot in advance for any guidance and help.
With best regards,
Yours sincerely,
Error Message:sql Server Dose Not Allow Remote Con
Oct 24, 2006an error has occurred while establishing a connection to the server.when connneting to sql server 2005,this failure
may be caused by the fact that under teh default settings sql server dose not allow remote connectings.(provider:
sql network interfaces,error:26-error locating server/instance specified)
when connect to database,the error message shows up.Help!
Dose Sqlserver 2000 Support Array Type?
Mar 31, 2006Any one know about it?
View 9 Replies View RelatedStudent Who Wants To Dba
Jan 10, 2005i'm currently a student in computer information sciences, and i wanted to give my studying some more focus thus choosing dba. now i'd like to dba but be as broad as possible when i first start out my career. i know some programming languages and recently finished a C# book for doing .net development and a ASP.net book for scripting. but where should i go from here? should i just start studying ms sql server? what about a microsoft certification? i'm very curious to know where the next step in my studying should be, so anyone who was in my shoes, i'd love to hear any information you have to offer. TIA
View 14 Replies View RelatedDose It Make Sense To Create Indexted Views On A Single Table?
Apr 24, 2007Hi, all experts here,
Thank you very much for your kind attention.
I am wondering if there is any sense to create indexed views on single table? I simple want to improve the report query performance as most of the reports data are from a single table. As views most of the time are created as for joined across tables.
Thank you very much for your advices and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
Dose SQL Server Integration Service Support Farsi (Persian) Language?
Mar 31, 2008
Dose SQL Server Integration Service support Farsi (Persian) language?
I passed a column of a Farsi text database to Term Extraction component put it didn't send anything to output (destination).
I even use CodePageConvert (http://www.microsoft.com/downloads/details.aspx?FamilyID=9E56417E-23D1-4FD3-8D6D-61314FAA2DE3&displaylang=en) between Source and Term Extraction, it seems that it converted the text but still nothing comes from the Term Extraction.
Sample input for Term Extraction component:
به بوی ناÙ?Ù‡€ŒØ§ÛŒ کاخر صبا زان طره بگشاید
ز تاب جعد مشکینش Ú†Ù‡ خون اÙ?تاد در دل€ŒÙ‡Ø§
مرا در منزل جانان چه امن عیش چون هر دم
جرس Ù?ریاد Ù…ÛŒ€ŒØ¯Ø§Ø±Ø¯ Ú©Ù‡ بربندید Ù…Øمل€ŒÙ‡Ø§
Thank you,
Babak
Beginner Student PL/SQL To T-SQL
Jul 23, 2005Hi,I'm finishing up a beginning SQL class where we learned on an Oracledatabase and the transition to working on SQL Server is easy. The next moreadvanced course will be in PL/SQL, but I know I will be working on SQLServer in the workplace, so my question is if I should take this course.Will I benefit from the basic philosophies that will be covered, or will itjust make a transition for me more difficult? Will it be partly a waste oftime and money and I'd be better served getting a book and self teachingmyself? I know that in a greater sense learning something isn't necessarilya waste, but I mean from the perspective of my goal of being able to use SqlServer, will this course be useful?thanks.
View 10 Replies View RelatedStudent Needs Help With Editions
Oct 18, 2007I am starting a class on SQL Server, and my school wants me to builddb's either on campus or remotely at my home connecting to their SQLServer Enterprise.Will I be okay to use Developer Edition at home to connect with anEnterprise-licensed SQL Server on campus, to build databases,sprocs, .net apps that connect to the database stored on my school'sserver?I would rather avoid the Express edition.thanks
View 1 Replies View RelatedA Student Would Like To Know What A Database Administrator Does.. Thank You
Jan 18, 2008I'm a kid and I'd like to know what kind of work a database administrator does. It would be great to learn from a real database administrator how you spend your typical day at the office. What are some of your main duties? Thanks so much in advance.
View 1 Replies View RelatedCalculating Average For Each Student And Get The Highest
Feb 12, 2013I want to calculate average of grades of each student and get the highest one with SQL command.
I have 2 tables:
Students:
*StudentId
*StudentName
___________
Grades:
*StudentId
*Grade
___________
I need to calculate average of each student and then get the highest.
My try:
Code:
SELECT Students.StudentId,Students.StudentName,AVG(Grades.Grade) AS avg_grade FROM Students s JOIN Grades g ON Grades.StudentId =Students.StudentId
GROUP BY Students.StudentId, Students.StudentName
ORDER BY avg_grade
LIMIT 1 FROM Students;
I encounter problem with this code, maybe it's Completely wrong...
How To Find Age And Group By Student Number Like (IT%)
Aug 4, 2013I have created a table:
CREATE TABLE [dbo].[Student](
[StudentNumber] [varchar](50) NOT NULL,
[Name] [char](50) NOT NULL,
[Contact] [int] NOT NULL,
[Address] [char](50) NOT NULL,
[DateOfBirth] [datetime] NOT NULL,
[YearEnrolled] [int] NOT NULL,
[Year] [int] NOT NULL;
And insert the following data:
INSERT INTO Student VALUES('IT123456X', 'Ahmad Adam','05-18-1997', '33 Mangis Rod', 19970518, 2013, 1);
INSERT INTO Student VALUES('IT334455U', 'Mary Tan', '01-23-1996', '51 Koon Seng Road', 23-01-1996, 2012, 1);
INSERT INTO Student VALUES('BS123456X', 'Samuel Lee', '03-30-1997', '2 Joo Chiat Lane', 30-03-1997, 2013, 1);
INSERT INTO Student VALUES('BS234234Z', 'Nathaniel Koh', '12-08-1997', '5 Stll Road', 08-12-1997, 2013, 1);
INSERT INTO Student VALUES('BS987987F', 'Siti Faridah', '07-04-1995', '3 Duku Road', 04-07-1995, 2011, 3)
How do i calculate the age and how can i group by the StudentNumber like 'IT%'
Transact SQL :: How To Upgrade Student Grade Only
Jun 9, 2015We have SQL database now a days we are planing to update our students ID Records but i don't know the exact query for this. Table format is below
StudentIDÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Name
500132253/Prep              Aslam
112344883/Prep              Ali
451132537/Prep              Ahmed
Now i want to update only the grade from prep to KG-1 without update the registration number only prep to kg-1. in one column there is student register number and after slash the grade.
Need To Identify Student With Multiple Id Numbers
Jan 17, 2008My working table:
CREATE TABLE [dbo].[Name_ID4](
[id_num] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[student_last_name] [varchar](30) NULL,
[student_first_name] [varchar](30) NULL,
[student_middle_init] [varchar](1) NULL
[local_student_id] [bigint] NULL,
I need to identify only the students with more than one local_student_id and the associated local_student_id's.
I can identify the students with two id's but not the associated id's
SELECT COUNT(*) AS Dup_Num,
rtrim(student_last_name),
rtrim(student_first_name),
rtrim(student_middle_init),
from Name_ID4
group by
student_last_name,
student_first_name,
student_middle_init,
having (count(*) > 1)
order by student_last_name, student_first_name, student_middle_init
Thanks
Only Max Date Record Should Be Shown For Every Student
May 25, 2015I have a table which shows data in below format
Now I need that only the max date record should be shown for every student as shown below...
Find 90th Percentile Scores For Each Student
Sep 15, 2006I am stumped on a set-based approach for this one.
A cursor approach is straightforward enough, but i want to avoid that.
Here's my table:
create table StudentScores
(
id int primary key identity(1,1),
student_id int not null,
score int not null
)
with some sample data:
insert into StudentScores (student_id, score)
select 1, 10 union all
select 1, 29 union all
select 1, 50 union all
select 1, 53 union all
select 1, 45 union all
select 1, 10 union all
select 1, 29 union all
select 1, 50 union all
select 1, 53 union all
select 1, 45 union all
select 1, 88 union all
select 2, 23 union all
select 2, 54 union all
select 2, 55 union all
select 2, 34 union all
select 2, 56 union all
select 2, 78 union all
select 2, 23 union all
select 2, 54 union all
select 2, 55 union all
select 2, 34 union all
select 2, 56 union all
select 2, 78 union all
select 2, 23 union all
select 2, 54 union all
select 2, 55 union all
select 2, 34 union all
select 2, 56 union all
select 2, 78 union all
select 2, 98
What I want is, for each student, what is their 90th percentile score?
For a given single student, one possibility would be:
declare @studentid int
set @studentid = 2
select top 1 @studentid as student_id, a.score as [90th percentile score]
from
(
select top 90 percent score from StudentScores
where student_id = @studentid order by score asc
) as a
order by a.score desc
But I want this for all students, and not use a cursor.
Any ideas?
Thanks!
Average Number Of Contact Hours Per Student
Feb 20, 2012I am trying to find out the the Average number of contact hours per student. in Reporting Services 2005. The contact hours is the in the Totaltime field
Is this formula correct
=Sum(Fields!TotalTime.Value)/Avg(Fields!TotalTime.Value) is in the =Fields!StateServices.Value Group
My groups are
=Fields!Student_ID.Value
=Fields!StateCategory.Value
=Fields!StateServices.Value
Code:
SELECT Student_ind.[Student ID], ParticipantActivity.ActivityDate, School_tbl.[Studentschool Id], School_tbl.schoolID, ParticipantActivity.TotalTime,
ParticipantActivity.Services, ParticipantActivity.Activity, Student_ind.SSID, ParticipantActivity.StateCategory, ParticipantActivity.StateServices
FROM ParticipantActivity INNER JOIN
School_tbl INNER JOIN
Student_ind ON School_tbl.[Student ID] = Student_ind.[Student ID] ON ParticipantActivity.[Student ID] = Student_ind.[Student ID]
[code]....
Attendance Records - Bulk Insert In Student Database
Apr 5, 2012I have a csv that contains attendance records that I get daily from a 3rd party grade book solution. I need to import directly into the attend table in our student database.
Code:
Attend File-"1112","0021","404550","20120402","ABU","2300000","06","05"
The file is setup as follows, School Year, school number, student_id, absence date, absence code, course number, section number.
I need to check the student schedule to see if they are scheduled for that class when the import runs. So if they had a schedule change in the middle of the day it won't post attend to a dropped class.
I have done something similar to this before with the way I export teachers out to our grade book. I have it check the master schedule to see if the teacher is teaching at least one class, that way it won't export tutors and office staff to the grade book. I used the script below to do that but not sure who to apply it to a bulk insert.
Code:
Script Used to export teachers note last four lines, checks master
USE [GSchool]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
[Code] ....
Secondly I need to check the date of the record and overwrite a record if one already exists for that exact course and section for that student, I need this because if they make changes to a previous day from absence un excused to excused I need to get rid of the unexcused by overwriting it.
One more thing that would be nice but is optional, is there a way to send log of errors on the import via email?
Data Access :: How To Compute Student Grade In Server
Nov 21, 2015 i am having problem putting this query to calculate students grade using the condition and legend bellow.
WHEN EXAMS BETWEEN 75 AND 100 THEN 'A'
WHEN EXAMS BETWEEN 70 AND 74 THEN 'AB'
WHEN EXAMS BETWEEN 65 AND 69 THEN 'B'
WHEN EXAMS BETWEEN 60 AND 64 THEN 'BC'
[code]...
Find Highest Marks In Student Table Query
Oct 9, 2007
Hi Everybody
I've one table named Student. Here is data
Name
Subject
Mraks
Prasad
English
80
Tushar
English
79
Sunil
English
78
Prasad
Geometry
80
Tushar
Geometry
81
Sunil
Geometry
79
Prasad
History
82
Tushar
History
81
Sunil
History
80
Now I want to write a query that displays student with subjects and marks who secured highest marks in each subject.
I want to output like this
Name
Subject
Mraks
Prasad
English
80
Tushar
Geometry
81
Prasad
History
82
So will anybody help me to write a sql query that acheive the same output
Transact SQL :: Retrieve Last Class Attended By The Student Using JOIN
May 14, 2015In my query, I am showing Student Record and also want to retrieve the last class attended by the student using JOIN to the table (ClassHistory).
Master
ID Â Â Â Student_Name
1 Â Â Â Arindam
2 Â Â Â Brenda
3 Â Â Â Callie
(ClassHistory)
ID    Class    Year
1 Â Â Â 4 Â Â Â Â Â Â Â Â 2003
1 Â Â Â 5 Â Â Â Â Â Â Â Â 2004
1 Â Â Â 6 Â Â Â Â Â Â Â Â 2005
2 Â Â Â 4 Â Â Â Â Â Â Â 2003
2 Â Â Â 5 Â Â Â Â Â Â Â 2004
3 Â Â Â 4 Â Â Â Â Â Â Â 2003
DESIRED RESULTSET
ID   Student_Name   Class Record
1   Arindam                6
2   Brenda                  5
3   Callie                    4
The result is like - Arindam last class was Class 6, while Brenda was in Class 5 and Callie was in class 4.
Please note that the query will b part of a larger query and the Class record to be retrieved from ClassHistory if possible need to be retrieved through JOIN.
Rate() And PMT()
Oct 13, 2004If you are familiar with Crystal reports or Visual basic, you may be familiar with the Rate and Pmt functions.
I need to duplicate them in SQL sever 7.
Anybody have code for this already? I hate re-inventing the wheel.
More (Unnecesary) details:
I have a client who has handed me the formula that I need to use for calculating Interest rates. Unfortunatly, the formula was written in Crystal reports, so now I need to pick it apart and do the work that CR does automaticly. Any help?
At What Rate Is The Db Growing???
Oct 27, 1999Hello,
Does 7.0 store db Growth rate information?
I am looking for information that tells me how fast a db is growing in MB and or percentages over a given period of time, ie weekly, monthly, yearly etc. Either in real numbers or estimates. Does 7.0 already store something like this or do I need to create some code for this?
Or does someone have something like this already coded that they would be willing to share?
Thank you in advance.
Troy
SQL Server 2012 :: How To Calculate Attendance For Single Student For Yearly Basis
Jul 2, 2015I have to calculate the Total number of days present and absent for a singel student.
AS of now i have 3 tables.
1.Daily attendance - Columns -[Guid][,AcademyId],[StudentId],[Date],[Status],[Reason]
2.Student details - Columns - [Guid],[FullName],[DOB],[Address]
3.Class Details - Columns - [Guid],[AcademyId],[Class],[Section],[Startdate],Enddate]
So now i have loaded all the data into the table.
I can fetch the counts for total present and absent
Query i have tried is
Declare
@StudentId Uniqueidentifier ='0B2D4D41-8D33-4D79-A981-03E0F093F458'
Begin
select A.StudentId ,A.Date,Count(Date)Total,B.Guid,
[Code] ....
AS result of this query i get the data.Present count and Absent count from date inserted in Dailyattendance tables.
SO my problem is if the student have promoted to next class then by this query it will count the before year also how do i need to calculate the count according to the Class StartDate and Enddate as i mention in the Class Details table what will be the query.
Student Trying To Install SQL Server 2005 Developer's Edition On Windows Vista
Jan 18, 2008Has microsoft issued an update so I can install SQL 2005 DE on Windows Vista? Thank You!
View 3 Replies View RelatedTax Rate Data Type
Jul 15, 2004Hi,
I want to store tax rate in my tables. I set the data type to float, I wan't 4 decimal places and the data in the table has 4 decimals, but when I run a query in query analyzer it returns: 4.4999999999999998E-2 instead of 0.045.
How can I fix this?
Hourly Rate For Consulting
May 8, 2008I am working with a company that needs some SQL Reporting developed. What is the going rate for SQL Reporting work?
View 14 Replies View RelatedDate Between Query - How To Get Rate Value
May 29, 2014I have a Table as below
Month Year Rate
1 2013 100
2 2013 101
8 2014 105
The rate is the value for the Month(1)January and year 2013.
I wana have a query which need to get rate value between 3rd month 2013 and 5the month 2014.
The Output has to be
3 2013 101
4 2013 101
5 2013 101
to
4 2014 105
5 2014 105