<div>
and the question is? <br />
Somewhat pedantic perhaps, sorry, but there is no actual question, just a series of statements.<br />
<br />
I suspect you will need a function, not a view, for this.<br />
&amp;&nbsp;are you also expecting these to be flexible?<br />
<i>where submitdate between <b>'08/01/2015'</b> and <b>'08/30/2015'</b> and CustomerScore &lt;&nbsp;<b>7</b></i><br />
are these the only likely filtering conditions?<br />
<br />
{+ edit}<br />
oh, and can you expend on what you mean by random?<br />
for example, do you mean, that the 38% any be any percentage (0 to 100)<br />
or, do you mean, the rows returned to meet the 38% are randomly chosen
</div>


and the question is?
Somewhat pedantic perhaps, sorry, but there is no actual question, just a series of statements.

I suspect you will need a function, not a view, for this.
& are you also expecting these to be flexible?
where submitdate between '08/01/2015' and '08/30/2015' and CustomerScore < 7
are these the only likely filtering conditions?

{+ edit}
oh, and can you expend on what you mean by random?
for example, do you mean, that the 38% any be any percentage (0 to 100)
or, do you mean, the rows returned to meet the 38% are randomly chosen

<div>
I want to pull back 38% of the rows that meet the criteria of <br />
<br />
where submitdate between '08/01/2015' and '08/30/2015' and CustomerScore &lt;&nbsp;7<br />
<br />
and the questions is this possible and if so how would the query look ?<br />
<br />
thanks
</div>


I want to pull back 38% of the rows that meet the criteria of

where submitdate between '08/01/2015' and '08/30/2015' and CustomerScore < 7

and the questions is this possible and if so how would the query look ?

thanks

<div>
<div class="content wysiwyg-content">
I am trying to create a view from a table &nbsp;where the view is a percentage and random.<br />
<br />
So the view always has 38% of the list in the table<br />
<br />
ie: &nbsp;select 38% of table where submitdate between '08/01/2015' and '08/30/2015' and CustomerScore &lt;&nbsp;7<br />
<br />
But i want the 38% to be stored in another table so that value can adjust from month to month.
</div>
</div>


I am trying to create a view from a table  where the view is a percentage and random.

So the view always has 38% of the list in the table

ie:  select 38% of table where submitdate between '08/01/2015' and '08/30/2015' and CustomerScore < 7

But i want the 38% to be stored in another table so that value can adjust from month to month.

MS SQL + Percentage from List - Random

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.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.