Changed direction here. Thanks for viewing.
Jul 28 '11 at 07:56 AM
Aug 01 '11 at 01:14 PM
@Redder - I am not too sure what you are trying to achieve with this process. The explanation regarding swapping Field1 for FieldN is quite confusing.
Maybe you could try re-phrasing the question, telling us what it is you are trying to achieve. It would be even better if you could supply us with table creation scripts, a set of sample data and the expected output.
Dynamic SQL mebbe?
@fatherjack - possibly, let us see what @redder really wants to do
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Jul 28 '11 at 07:56 AM
Seen: 279 times
Last Updated: Aug 01 '11 at 01:14 PM
Stability problem for Excel commander report using RDBMS and OLAP
Can this linear regression algorithm for SQL Server 2K5 be made reusable?
Pass value of selectedindex of a listbox to a stored procedure
Use a left hand value in right hand SQL comparison
Stored Procedure to delete child and parent table
Instant copy of local server database to removeable USB back up drive
There is already an object named '#tmpCostTable' in the database
How To Create A Cursor That Uses Dynamic SQL?
Error handling EXEC(@CMD) in SP (SS2000)
problem with date in where condition
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.