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
Multiple Valued Stored Procedure
Stored procedure definition after sp_rename
Run Stored Procedure at Startup
Insert into Statement after Insert show no Record in Table
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?