sr. Developer

Larry Brister

<div>
yeah... thats what I thought... was hoping there was some super-secret wonderful thing that was recently invented
</div>


yeah... thats what I thought... was hoping there was some super-secret wonderful thing that was recently invented

<div>
&gt;&gt; was hoping there was some super-secret wonderful thing that was recently invented <br />
I don't think so, though I'm curious too :-) &nbsp;... but I suspect the multiple columns is going to necessitate a CASE or UNION ALL approach no matter what you do.
</div>


>> was hoping there was some super-secret wonderful thing that was recently invented
I don't think so, though I'm curious too :-)  ... but I suspect the multiple columns is going to necessitate a CASE or UNION ALL approach no matter what you do.

<div>
<div class="content wysiwyg-content">
I have select statement the produces 9 columns<br />
<br />
What I need returned is for columns 2 through 9<br />
The results of the first column where the integer value &gt;&nbsp;0<br />
<br />
example... the columns would be<br />
IndividualID &nbsp; &nbsp; &nbsp; [1] &nbsp; &nbsp; &nbsp; &nbsp; [2] &nbsp; &nbsp; &nbsp; &nbsp; [3] &nbsp;... etc<br />
95487512 &nbsp; &nbsp; &nbsp; &nbsp; 32546 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; 33365<br />
95487513 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; 33358 &nbsp;33365<br />
<br />
The desired final select would be<br />
IndividualID &nbsp; &nbsp; &nbsp; &nbsp;OPCol<br />
95487512 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;32546<br />
95487513 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;33348
</div>
</div>


I have select statement the produces 9 columns

What I need returned is for columns 2 through 9
The results of the first column where the integer value > 0

example... the columns would be
IndividualID       [1]         [2]         [3]  ... etc
95487512         32546      0         33365
95487513             0         33358  33365

The desired final select would be
IndividualID        OPCol
95487512            32546
95487513            33348

MS SQL Server first column with no zero

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.