Mapping A Number To A Letter Grade...

Mar 24, 2008

I'm trying to think a way to map an average rating (1-10) to a letter grade (A-F).

For example, if I querry the name of a professor and the corresponding rating for the professor, then I would also like to generate a column displaying the corresponding letter grade for the professor based on the rating.

Professor | Rating | Grade |

Smith 8.5 B

I use an aggregate function to diplsay the rating.
I'm thinking I may need to write my own aggregate function to display the letter grade. 'Professor' is an actual field of the database.

View 4 Replies


ADVERTISEMENT

How To Take Grade Letter From Marks Range From Grade Table

Oct 20, 2015

Grade Table is:

Grade_letter lowbound_marks uperbound_marks
A 85 100
B 60 84
C 0 59

Suppose some another query returns marks.Now, I am stuck with the query which takes the grade_letter based on the marks falling in the range given above. I want a query which is not hardcoded and calculates the grade based on the values given in the table only.

View 4 Replies View Related

SSIS Parameter Mapping With Oracle Data Type Mapping!

Mar 19, 2008

Hi Friends,

I have a small problem in parameter mapping for Execute SQL Task.
I am using a delete statement with 2 conditions.
Followed by another Execute SQL Task which contains commit statement.

delete from tname where c1 = ? and c2 =?

where c1 is number(4) datatype and c2 is of varchar2(20) datatype in oracle.


The connection manager i am using is ORacle OLE DB provider.
I am passing 2 global variables i.e g_v1 of Int32 and g_v2 of String Type.

In the parameter mapping of the Executing SQL task, i am mapping these 2 variables for
c1 and c2 and changed the datatypes inside parameter mapping as Numeric for c1 and Varchar for c2.

I also set the property as ByPassPrepare = True.

When i am executing the package i getting INVALID NUMBER ERROR.
i believe the SSIS is unable to perform the implict datatype converison.

For the next run, i changed the g_v1 varible datatype to Double and also i changed the parameter mapping for c1 as Doble datatype.
This time it is working fine. I can see the Green signal for the 2 SQL Tasks.

But when i connected to Oracle check the count in the table, the data is not getting deleted.

Also,
I set the property RetainSameConnection = TRUE for oracle connection manager.
I am not able to trace this logical error.

The same is working fine in my local machine.
But i am facing the problem when i deployed the same on the client machine.


Is there any problem with parameter mapping?
What should be equialent Datatype for Oracle NUMBER datatype that should be used inside the SSIS package while declaring the global variable and
inside the parameter mapping.

Any thoughts!

View 5 Replies View Related

Above My Pay Grade

May 14, 2008

We are going to be converting our access database into an Eaglesun database. What commands would you use for the conversion

Thanks for the help


US Navy - We are fueled, armed, and go for launch.

View 4 Replies View Related

Need To Calculate Grade Age

Mar 7, 2004

Need to calculate the Grade age based on the birthdate and Nov month and 30th Day of the current year.
I have a working datediff statement but I need to always but in the current year. I would like to have the statement get the current year. Then if the age is greater than xx and less than xx your age level is "xyz"

This works DateDiff("d" [Birthdate], 11/30/2004) /365.25 will return the age.

I want to replace the 2004 with a getdate yyyy so I do not need to maintain this statement.

Thanks in advance of a reply
Gary

View 2 Replies View Related

Transact SQL :: How To Upgrade Student Grade Only

Jun 9, 2015

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

View 6 Replies View Related

Need Commercial Grade FileWatcher Task

May 19, 2006

Does anyone know of such a task than runs under both x86 and x64? (I know a FileWatcher add-in but it was built using Beta verisons of VS.NET)

TIA,

barkingdog

View 1 Replies View Related

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

View 7 Replies View Related

Get The First Letter

Mar 24, 2008

I have a table of definitions:

---------------------------
Glossary
---------------------------
Term | Definition
---------------------------


What I need to do is find all the letters that are at the beginning of the terms.

So if I have "apple" as a term, A is returned.
Also, if I have "forest", "fruit", and "flower", F is returned, but only once.
And if I have no terms that start with Q, Q is not returned.
Lastly, if I have a term like " 'Walking' Pneumonia", it should recognize that the term starts with a W.

View 4 Replies View Related

Get First Letter In A Sql-query

May 6, 2007

Hello!I want to get the first letter in a sql-query and compare with a QueryString.This is the pricip in ASP Classic:Select * From Dictionary Where Left(_Name, 1) = Request.Querystring["Letter"]I think you'll understand.Thanks. 

View 1 Replies View Related

How Many Times Does A Letter Appear In A Name

Nov 30, 2006

i have a column containing employee name with datatype varchar.
i want to find out that how many times does letter 'y' appear in employee's name.

am a beginner to sql
help appreciated

cheers

View 5 Replies View Related

Getting Only First Letter Of The Column

Jun 29, 2007



Hi,

I am using an OLEDB source to run a stored procedure, which returns records from a temp table. The destination table is exactly same as the temp table in the stored procedure. I've some collation settings on both the destination table and temp table, but both are exactly same.

I got Unicode to Non-unicode conversion error first. I dont know why it happened as there is no difference in source and destination table. I solved that issue using the data conversion component. Then I got the truncation error. I set the Ignore on Truncation on error output to get rid of that issue. Then the package executed without any problem. But all the nvarchar and varchar fields in the destination table got populated with only the first letter of data.

Any Idea?

View 3 Replies View Related

Drop Down List - Use More Than 1st Letter

Apr 26, 2005

In my drop down menus - which are populated by tables - we can only use the scroll bar OR type in the first letter to find the item - Is there a way to type in several letters to find something? (e.g. if I want to find clockwork - right now I could type in "C" to get to the C's - but if I tried typing "clo" it would end up at the beginning of the "O's" - Thanks

View 1 Replies View Related

Grabbing The First Letter Of A Field

Dec 1, 2005

Hey all, i'm trying to build a little piece of code that will grab the first letter in a first name field, but I can't quite get it.

Any help would be great
thanks
Caden

View 1 Replies View Related

Not Display The Letter Unless Count &>= 3

Jun 3, 2008

SELECT name = SUBSTRING(name, 1, 1),
total = COUNT(SUBSTRING(name, 1, 1))
FROM products
GROUP BY SUBSTRING(name, 1, 1)

the assignment said that,

quote:"Do not display the letter and count unless at least three product names begin with the letter."

but i got the errors when I try following.

WHERE total >= 3

quote:Msg 207, Level 16, State 1, Line 4
Invalid column name 'total'.

WHERE COUNT(SUBSTRING(name, 1, 1)) >= 3

quote:Msg 147, Level 15, State 1, Line 1
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.


so what should I do?

View 3 Replies View Related

Replacing First Letter Only In Column

May 17, 2006

Hello. We have a list of 1000+ sku numbers. 90% of them start with u. I need to replace the u with T.

Concerns:
It has to only replace the first letter, if there are other "u"s in the sku, they need to remain.
Not all skus start with u, those that don't should remain the same.

I have searched and searched because I'm sure someone has requested the exact same thing but I can't find anything that is identical.

I have this so far but I know its not correct:
set sku = replace(left(sku,1),'u',right(rtrim(sku),1)+
'T')

Can someone help lead me down the right path?

Thanks in advance!!!

View 4 Replies View Related

Increment Char Or Letter

Aug 17, 2007

I'm looking for a way to do something like this:
A, B, C, ... Z, AA, AB, AC

View 1 Replies View Related

Use Of Capital Letter N In Script

Dec 29, 2007

Below is from the SQL Help files on INSERT INTO
http://msdn2.microsoft.com/en-us/library/ms174335.aspx

What is the N doing in this script? (...N'F2'...N'Square Feet'...)

-----------------------------------------
USE AdventureWorks;
GO
INSERT INTO Production.UnitMeasure
VALUES (N'F2', N'Square Feet', GETDATE());
GO
-----------------------------------------

TIA.

View 3 Replies View Related

Changing Drive Letter

Jul 20, 2005

Hi there. I have to change the drive letter where SQL server have hisdatfiles (master included). If I do that, ob the SQL fail to start, becouseit's unable to find the master datfiles. Is it possible changing driverletter without reinstalling the complete product?BRamnésia

View 2 Replies View Related

First Letter Capital More Than One Word

Oct 26, 2006

Here is my question: Can you set this code up to do more than one word ex: I have names like Mc Donald, or Brook-Smith and the are lower case like the code states??



upper(left(client.first,1))+ lower(right(client.first,len(client.first)-1)) +' '+ upper(left(client.last,1))+ lower(right(client.last,len(client.last)-1)) As 'Full Name'

View 7 Replies View Related

Using 1 Report To Print In Both Letter And A4

Aug 7, 2007

I am looking for a way to, at execution, have 1 single report either print in "letter" or "A4" depending on a parameter I send it... anyone have an idea on where to start on this?

Thank you,

Brian

View 6 Replies View Related

Convert 1st Letter To Uppercase In SQL Comand

Aug 15, 2005

Hi all!This is the problem:User enters student name, in the database, only the 1st letter is uppercase and the rest is  in Lower case.So, I want to fix this so as it is not case sensitive, i.e. the user can enter a name and it will return the recordwhether they enter it in upper or lower case.My Code:CvtUpperCase.Text = UCase(Content.Text)                //stores user's input
   Select Case OptionChoice
       Case "Student_FirstName"            MyCommand = New SqlDataAdapter("select * from [qryStudentDetails] where [qryStudentDetails].[Student_FirstName] like             '" & CvtUpperCase.Text & "'" , myConnection)
....Any ideas??

View 2 Replies View Related

Specifying Drive Letter For Data And Log Devices

Sep 25, 1999

Hi am new to this, I am doing some asp development and wanted to know if there is a way of specifying the drive to place log and data devices through sql statments or stored procedures.

--Tito

View 1 Replies View Related

How To Get The Drive Letter And The Backup Directory

Jan 16, 2008

Hello,

I'm looking to get the drive letter and path for my backups programmatically. I am monitoring my sqlserver boxes remotely and need to get this information to determine if my backups will fit on the backup drive.

I'm looking for either a sql statement or a stored procedure to accomplish this.

For example...the backup script states:
EXECUTE master.dbo.xp_create_subdir N'H:MSSQLBackupmaster'

I need to know how this script gets H:MSSQLBackup

Thanks in advance.

View 6 Replies View Related

Update Column Based On 1st Letter

Feb 25, 2014

I have a large website with over 100,000 images and the location of the images are stored in a column (img_url) as below:

/images/imagename.jpg

Because all these images are stored in the same folder it is hard to manage so we want to store each image under a directory based on the 1st letter of the image name, ie:

/images/a/aimage.jpg
/images/b/bimage.jpg

I can automate the physical move of the images into the correct directory but I need SQL update query that will update each column based on the 1st letter of the image.

So:

/images/aimage.jpg
/images/bimage.jpg

Updated to:

/images/a/aimage.jpg
/images/b/bimage.jpg

View 4 Replies View Related

Skip Rows Where The First Column With Letter 'S' - BCP

Aug 9, 2006

Hi All,I have this data file with fix length(see below). I am able to insertit into the database using bcp, but now I want to skip (do not insert)the row which start with letter 'S' into the database. Is there away todo it? By the way I am using -F2 option to skip the first record.Here is my data:Record 1 04XXX2 13106900240120042003040045061 Testing N POLYDOROS TRUSTEEE2 12621241640280041004040045633 What are they MARTIN &XXXXXS C1000003200400409850000059611000000500001000000001 9613000000576497500S X1000003200000209850000059613000000000000000000001 9613000000573497000Thanks for your help.Ted Lee

View 1 Replies View Related

Capitalizing First Letter, And Lower The Rest

Oct 25, 2006

I am trying to get this code to work: (left(religion,1))+ lower(right(religion,len(religion)-1))As Religion

I am getting this error:

Invalid length parameter passed to the RIGHT function.

View 6 Replies View Related

Preventing A Page Break For A Letter

May 20, 2008

I have a letter I am creating in SSRS and would like the data to flow smoothly from one page to the next even if the whole section doesn't fit on a page instead of it forcing a page break which results in a large blank space on the page before. I have put the data into multiple text boxes (can grow is set for the text boxes) because of formatting requirements (I also tried the table object).

--Start Example--

TEXT HEADER 1
very long report letter information here (call it detail 1)

TEXT HEADER 2
even more very long report letter information here (call it detail 2)

TEXT HEADER 3
The term ""Accountant€™s Letter"" as used herein shall mean the certain math verification report, to be provided by an independent certified public accountant, certifying that the Securities shall generate the debt service payments due under the Loans. (call it detail 3)

--End Example--

So assume that everything but detail 3 fits neatly on the first page. Now part of detail #3 should fit on page one but it pushes the whole section to page 2 because it doesn't all fit. All I want is for say line to to be the last line on page #1 and lines 2 and 3 to be in page 2 instead of lines 1 through 3 on page 2. In reality, this letter is about 6 pages and each section is about a half page to 2 pages. This perceived minor issue has cost me a good day+ set back. Thanks,

View 1 Replies View Related

Search Not Working With String Consisting Of Two Letter

Feb 25, 2007

hi friends,
 I have search in my project based on strings(surname, firstname).. but it does'nt works wen name consists of only two letters.... could somebody please help me on this.
 
Thanks sandeep

View 3 Replies View Related

How To Store Resume And Cover Letter Into SQL Server?

Jun 6, 2005

Hi,
    I am trying to create an asp.net web recruiting application for HR, which will give the users the ability to both copy/paste the Resume and cover letter in textbox and upload resume and cover letter, then submit it (which will be saved into SQL Server 2000 table). 
I am thinking to save Resume and cover_letter as Image data type columns in SQL Server. 
.  Can someone give me a direction about how to save the uploaded resume and cover letter to table and if it's the easiest way to do it?
.  What to deal with different formats of uploaded resumes?  I hope to limit to only Word or HTML
.  Since I also give user another option - copy/paste the resume and coverletter into a textboxes.  Can I simply save the copy/paste resume and cover letter into text field column?  Later, say, if any HR recruiter retrieve the text from database, will it concatonates everything together without line break?
Any ideas is appreciated.

View 8 Replies View Related

Restoring Master,Model To Different Drive Letter

Jan 26, 2001

Hi All,
I took a backup of master,model and msdb database which was on D: drive and i tried restore it on C:. Now if i try to start sql server it comes out with a erorr that model database cannot be found and it keeps looking for model in D: drive which is not there.I tried restore of model with move option but it says cannot drop model as its system database.I tried attach detach but it does not understand tempdb as temp db is also on d: and i cannot understand how to move or point it to c:

Suggestions will be greatly appreciated
Vishal

View 1 Replies View Related

Query For Searching 'names' Based On First Letter

Apr 2, 2004

I would like to search MySQL table for names by selecting the first letter of the name.
eg: SELECT * FROM names WHERE lastName "begins with" M (or Mi, etc)

Right now if I use LIKE I get all names that contain "M".

Thanks.
PeterM

View 2 Replies View Related

Transact SQL :: How To Add A Letter In Front Of Value Using Case Statement

Jul 28, 2015

I am trying to add the letters 'MS' in front of value while using a case statement. If Dispo = 2 I want it to pull back 'Inactive', else I want it to pull back the Value with MS in front (eg. "MS14"). The data in the value column are numbers. Would I use a CONCAT? If so where does that need to go?

Case when dispo = 2 then 'Inactive' else cast(Value as varchar(11)) end ,

View 27 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved