Thanks again for your really helpful reply.

This gives me below output :

rollnonameclassSortOrder

1RobertIT1

1DavidScience2

1MichelCommerce4

1AlbertGeography5

1RichardHistory6

2HussainIT1

2JonathanScience2

2JohnArts3

3PoloIT1

4JosephHistory6

Kindly tell me how do i get required i.e. row number 1,6,9 and 10 please. This grouping is...

Thank you for your reply.

Here is my try till now, but not what I am wants :

CREATE TABLE #TempTable (Rownumber INTEGER IDENTITY(1, 1),ROLLNO INTEGER,NAME VARCHAR(30),CLASS VARCHAR(30),RNK INTEGER)

SET IDENTITY_INSERT #TempTable OFF

INSERT...

I solved the question with the help of below link :

http://stackoverflow.com/questions/14694691/sql-server-pivot-table-with-multiple-column-aggregates

declare @sql nvarchar(max)

select @sql='SELECT min(t.code) As CODE,PRODNAME'

DECLARE @ColumnTemplate NVARCHAR(MAX)

select @ColumnTemplate='SUM(CASE WHEN t.department=''{department}'' THEN t.netqty...

Problem solved, but with a very uncommon / unknown way. I told him to change the query text something like this :

insert into #tmp

select deptmst.deptname As 'Department',

isnull(doctormst.title,' ')+' '+isnull(rtrim(doctormst.firstname),'...

In addition to above, when I sees the same excel file in MS Office 2007, Windows 7 Home Premium 64 bit machine, no box character are there, but the same...

Thank you for your reply. Here is table defination :

SELECT ORDINAL_POSITION, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH

, IS_NULLABLE

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'doctormst'

DOCTORMST TABLE STRUCTURE

ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECHARACTER_MAXIMUM_LENGHTIS_NULLABLE

12accodechar8YES

9activechar1YES

6address1varchar40YES

7address2varchar40YES

10degreechar40YES

16DesignationCodechar5YES

1doctorcdchar5No

5doctortypechar2YES

14doctypechar1YES

2firstnamevarchar15YES

18honapplicablechar1YES

4lastnamevarchar15YES

15medicalregnovarchar15YES

3middlenamevarchar15YES

13mobilenochar15YES

8phonevarchar30YES

19tdstypecodechar3YES

11titlevarchar4YES

17WeekApplicablechar1YES

For Unicode :

When he run below queries, there...

Thank you for your reply. I don't know how and why you are anticipating that I am saying to build the whole project for me and this is beyond...

Just a little doubt; is it all due to I am trying to install Enterprise Edition on the XP machine, which is not a server OS ? Can I...

Surprise....

There is no entry named MSSQLServer in Event viewer found for application log. How it is possible, installer "installed" the sql server 2000 succesufully messaged, but there is no...

Thank you very much for your reply and time given to my request. At this moment, I am in my office, I shall follow the suggestation by today evening...

I am pulling up the thread after very late, but with the same problem status. After formating the C:, fresh installatation of XP with 3 SP, reinstallation of SQL...

Hi Dev,

Yes you are right that its very tough for a peer to do the programming in a new tech (without having architecture knowledge). I just thought on the...

Hi Dev,

Yes you are right that its very tough for a peer to do the programming in a new tech (without having architecture knowledge). I just thought on the...

Any Update please?

What i understood from your suggestion that i should break the "TYPE" column into different parts. Ok, suppose i do like this then ? I mean, now i...