Nice topic...

I would suggest you an idea.. for this...

You can achieve by partitioning the data based on specific ID.. may be primary key....

Group that data in a specific file group...

Nice topic.... Sorry for entering in the mid...

Wish to add my view..

For your scenario, dont go for dynamic sql ....

Curious to know,

How you install the sql server instance?

Regards,

Venkatesan Prabu .J

http://venkattechnicalblog.blogspot.com/

select * from xxxxflow f where

(mstr_ordid) = (select max(mstr_ordid) from xxxxflow b

where b.Ord_Num = f.Ord_Num

and convert(varchar(10),b.date,101) = convert(varchar(10),f.date_time,101)

)

some way to improve performance,

select (specify column name) from xxxxflow...

Use your sql server cd to repair the problem

Venkatesan Prabu .J

File groups are used to enhance the performance and also domain wise you can group the tables like consider am having a company database. Here employee related information can be...

Just check my blog

http://venkattechnicalblog.blogspot.com/2008/07/rows-to-columns-in-sql-server.html

Venkatesan Prabu .J

Just try it out with ordinary or temporary table creation

Venkatesan Prabu .J

http://venkattechnicalblog.blogspot.com/

Getting a backup of the existing and restoring is the best procedure to achieve your task.

Venkatesan Prabu .J

http://venkattechnicalblog.blogspot.com/

Please check my blog for your reference,

http://venkattechnicalblog.blogspot.com/2008/07/collation-in-sql-server.html

Venkatesan Prabu .J

I have handled this kind of situation in my blog. Please look into it,

http://venkattechnicalblog.blogspot.com/2008/07/rows-to-columns-in-sql-server.html

Venkatesan Prabu . J

with little bit eager, I wish to ask one question,

How you applied this contraint on the column, Whether you have used check constraint,

name like ('[A-Z][a-z]{1,19}')

Please mail it to venkatesanj@hcl.in

Hope my article will get you to achieve the same,

http://venkattechnicalblog.blogspot.com/2008/07/rows-to-columns-in-sql-server.html

Nice to join with you all in answering this question,

Select field1,GroupKey from

(

select row_number() over (partition by GroupKey order by GroupKey) as rownumber , field1,GroupKey from @mytable

)tbl

where tbl.rownumber<=2

The above query...

You have missed out Stopping the server. 🙂