eralper

Hi Experts I don't have the least idea on how to rank (desc) the following sample ExamScores by CourseID , grouping by Level. Some help needed. gbhs Newbie Level StudentID CourseID CourseName ExamScore ScoreRank A 101 1 Math 11 A 101 2 French 3 A 101 3 English 7 A …

I know that this question is asked a lot but still can't find the correct answer. I have a database on SQL Server 2012 Express Edition, that I need to protect the information and its structure. What's the best way to do it? Is there any way to protect the …

how to delete duplicate record in a table by using SQL query

Dear all , i want to transfer the sqlserver2008 database to sap business one database/? It is possible?

i m working on certain project ,i created some tables in database sql server 2005 .and it created smoothly. for examples users table .so it append it with dbo.users .till there there was no problem i can easily access its object (table,storeed procedure) .but after few days it appended table …

Hi, I have two tables where both contain the ID number and Date. The first table will always have a date and the second table will never have a date. Basically I want the query to bring back a result set that if the ID is in table 1, then …

Hi All, When I run the query: [B]select (100/50)[/B] It give me "2"... good. But when I run the query: [B]select (50/100)[/B] I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?

Hi guys, I'm brand new to SQL and was looking for any help I can get my hands on! What resources does everyone find useful?? Books, magazines, links, forums, etc.??? My friend shared this one with me so I thought I'd pass it along, I've found it pretty informative and …

Hi, i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it? Thanks this doesn't work but something like this; insert into exam (e_score, l_name, s_id) values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id)

Hi, I'm writing some complex queries on a very poorly designed database. We're running on MS SQL Server2000. I was wondering if its possible to do in-line if-else blocks within a query.. i.e. [PHP] SELECT * FROM tablename IF (condition1 = 'a') WHERE condition2 = 'a' ELSE WHERE condition2 = …

I want to return an XML stream from a SQL 2000 database using a URL query. I have been trying to get a simple M$ Northwind example to work on a Windows 2003 server but I can't get it to work. I can get the simple example to work on …