Did you execute this DBCC CLEANTABLE

Read about it here to see if it could help

http://technet.microsoft.com/en-us/library/ms174418(SQL.90).aspx

There will often be someone held accountable, even if the issue isn't publicized, and that person could easily be you. Follow best practices for security, raise awareness where you can,...

CirquedeSQLeil (4/20/2011)

Brandie Tarvin (4/20/2011)

LutzM (4/20/2011)

Is there anything wrong with the...

First of all I would place all your data from Table 1 and Table 2 into a single temporary table

CREATE TABLE #T3(COL1 VARCHAR(1), COL2 VARCHAR(1),COL3 VARCHAR(1), COL4 VARCHAR(1)

,COL1A VARCHAR(1),COL2A...

Steve, Andy may I congratulate you and those you select as mentors on this endeavor. Microsoft should add an award for the two of you.

MVPE .. Most Valued Professional...

shubham.saxena67

with cte

as (select row_number() over(partition by Adm_no order by adm_no) as rn,Adm_no,

first_name,mid_name,last_name

from dbo.tb_studentDetails)

SELECT * FROM cte

Sample of result returned:

rnAdm_nofirst_namemid_name

106/2036ESHITA SINGH

206/2036RajeevSolanki

106/2037DIVYAMTEOTIA

206/2037Divyam Teotia

106/2039Rhythem Saxena

206/2039RHYTHEMSAXENA

106/2040ISHITACHANDRA

206/2040Mohan Gupta

Code removed per correction of me by ColdCoffee...

To help those who want to help you, please, please post your table definitions, sample data, and your expected/required results in an easy to use format. To do...

CirquedeSQLeil (4/19/2011)

Not a direct link but I have it linked...

Just what I needed, a simple question with obviously correct answers

Care to share the link for the Tools Pack?

Have you tried OPENROWSET ? I know it works on 2005, but have as yet not tested on 2008

/*Text file must exist and have a first line of...

If you want tested help from those who can help you, post your table definition(s), sample data and the desired result from that sample data following the instructions which you...

lianvh

I suggest that you read this blog posting of Kimberly L. Tripp

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Spring-cleaning-your-indexes-Part-I.aspx

It may suggest a plan that you can implement to solve your problem

To receive test help, please, please post your table definition, some sample data, the results required from that sample data, and any T-SQL code you have attempted to use?. ...

NOt quite what I asked for. Remember many people do NOT like to open an attachment, not knowing what "worm" or other malicious code could be hidden in it....