Changed direction here. Thanks for viewing.
Jul 28, 2011 at 07:56 AM
Aug 01, 2011 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
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jul 28, 2011 at 07:56 AM
Seen: 576 times
Last Updated: Aug 01, 2011 at 01:14 PM
SQL Server 2008 and DB2 Stored procedures
Easy way to manage full database name in stored procedures and triggers?
can we provide output parameters and return statement to a SP at a time?
sum of fields from 2 different views
scalar variable declaration
Is there a way to change the columns to rows in a stored procedure?
How is best to persuade someone that stored procedures can outperform ORMs?
Stored Procedures - Urgent Help Needed
Stored proc execution times different on two machines
convert datetime error