2
Answers

when i execute the query output i snot coming correctly

narasiman rao

narasiman rao

11y
1.1k
1

 SELECT distinct r.rate as Rate,f.bthid as Batchid,CASE  WHEN r.rate = '1' THEN '100' WHEN r.rate = '2' THEN '75' WHEN r.rate = '3' THEN '50' WHEN r.rate = '4' THEN '25' ELSE '0' END AS Translated_Rate FROM bthfac AS f,batch AS b, faculty AS fa,facfeedback AS r where  month(b.examdate)= '9' and year(b.examdate)= '2011' and b.bthid=f.bthid and r.bfid = f.bfid and fa.facname = 'MADHAVAN'


when i  execute the above query  output as follows;


rate  Batchid Translated_Rate
 0  13         0
3  13       50
4  9       25
1  8     100
4  14     25
1  6    100
2  24     75
2  12    75
4  4     25
1 13    100

but in the above query, when i change the facname (facultyname) and execute the query,same output is coming for all the faculty.


what is the problem in my above sql server query please help me.

Regards,
Narasiman P.

Answers (2)
0
Mrudul Ganpule

Mrudul Ganpule

NA 23 17k 10y
Thank you for your valuable reply , i'll  try this solution in my project ..
0
Umesh Kumar

Umesh Kumar

NA 127 12.8k 10y
Hi Can you try this too,

public static string Serialize(object dataToSerialize)     {         if(dataToSerialize==null) return null;          using (StringWriter stringwriter = new System.IO.StringWriter())         {             var serializer = new XmlSerializer(dataToSerialize.GetType());             serializer.Serialize(stringwriter, dataToSerialize);             return stringwriter.ToString();         }     }      public static T Deserialize<T>(string xmlText)     {         if(String.IsNullOrWhiteSpace(xmlText)) return default(T);          using (StringReader stringReader = new System.IO.StringReader(xmlText))         {             var serializer = new XmlSerializer(typeof(T));             return (T)serializer.Deserialize(stringReader);         }     }
0
Umesh Kumar

Umesh Kumar

NA 127 12.8k 10y
Hi Good day,

Suppose I have a collection 
List<Employee> empList = new List<Employee>();
            empList.Add(new Employee() { ID = 1, FName = "John", LName = "Shields", DOB = DateTime.Parse("12/11/1971"), Sex = 'M' });
            empList.Add(new Employee() { ID = 2, FName = "Mary", LName = "Jacobs", DOB = DateTime.Parse("01/17/1961"), Sex = 'F' });
            empList.Add(new Employee() { ID = 3, FName = "Amber", LName = "Agar", DOB = DateTime.Parse("12/23/1971"), Sex = 'M' });
            empList.Add(new Employee() { ID = 4, FName = "Kathy", LName = "Berry", DOB = DateTime.Parse("11/15/1976"), Sex = 'F' });
            empList.Add(new Employee() { ID = 5, FName = "Lena", LName = "Bilton", DOB = DateTime.Parse("05/11/1978"), Sex = 'F' });
            empList.Add(new Employee() { ID = 6, FName = "Susanne", LName = "Buck", DOB = DateTime.Parse("03/7/1965"), Sex = 'F' });
            empList.Add(new Employee() { ID = 7, FName = "Jim", LName = "Brown", DOB =DateTime.Parse("09/11/1972"), Sex = 'M' });
            empList.Add(new Employee() { ID = 8, FName = "Jane", LName = "Hooks", DOB = DateTime.Parse("12/11/1972"), Sex = 'F' });
            empList.Add(new Employee() { ID = 9, FName = "Robert", LName = "", DOB =DateTime.Parse("06/28/1964"), Sex = 'M' });
            empList.Add(new Employee() { ID = 10, FName = "Cindy", LName = "Fox", DOB = DateTime.Parse("01/11/1978"), Sex = 'M' });


Code to convert to xml

var xEle = new XElement("Employees",
                from emp in empList
                select new XElement("Employee",
                             new XAttribute("ID", emp.ID),
                               new XElement("FName", emp.FName),
                               new XElement("LName", emp.LName),
                               new XElement("DOB", emp.DOB),
                               new XElement("Sex", emp.Sex)
                           ));