<div>
The script below will get you to the point of the sequence, but we'll need to know more information about the sequence number.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41711065-1"><span>DECLARE @testDate DATETIME</span>
<span></span>
<span>SET @testDate = GETDATE()</span>
<span></span>
<span>PRINT 'PR' + CONVERT(VARCHAR(6), @testDate, 12) + REPLACE(CONVERT(VARCHAR(5), @testDate, 108), ':', '')</span>
</code></pre>
</div>


<div>
select &nbsp;'PR' +<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;right(year(getdate()),2) +<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;right('0' + cast(month(getdate()) as varchar(2)), 2) +<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;right('0' + cast(day(getdate()) as varchar(2)), 2) +<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;right('0' + cast(datepart(hh, getdate()) as varchar(2)), 2) +<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;right('0' + cast(datepart(mm, getdate()) as varchar(2)), 2) +<br />
'016';
</div>


<div>
shaun: beat me by one second!
</div>


<div>
So the sequence would start with 001 and count from there for each line in the query. &nbsp;Each line should represent a single row in the table. &nbsp;Not sure yet whether they are going to want me to group by patient or transaction or invoice. &nbsp;I won't know for sure until testing phase.<br />
<br />
Mankowitz: &nbsp;Your code returned 1607150907 where Shaun's returned 0955 which is the exact hh and mm when I ran it. &nbsp; I ran yours at the same time so I don't know what happened there. &nbsp;I like Shaun's better because of that though.
</div>


<div>
How was this abandoned? &nbsp;I accepted the solution the next day. (7/15)
</div>


<div>
<div class="content wysiwyg-content">
The unique id has to be this <br />
Patient Refund (PR) +Year(YY) + Month(MM) + Day(DD) + Hour(HH) + Minute(MM) + Sequence Number/Count (001)<br />
Example:<br />
2/13/2016 7:30AM record number 16 = &quot;PR&quot; &amp;&nbsp;160213 &amp;&nbsp;0730 &amp;&nbsp;016 = PR1602130730016<br />
<br />
I have this so far: &nbsp;CONCAT('PR',(CONVERT(VARCH<wbr />AR, GETDATE()-1, 112))) <br />
but that just returns PR20160713<br />
<br />
I have tested all the date formats listed on the internet and none of them bring up what I want.<br />
<br />
Is this even possible?
</div>
</div>


The unique id has to be this 
Patient Refund (PR) +Year(YY) + Month(MM) + Day(DD) + Hour(HH) + Minute(MM) + Sequence Number/Count (001)
Example:
2/13/2016 7:30AM record number 16 = "PR" & 160213 & 0730 & 016 = PR1602130730016

I have this so far:  CONCAT('PR',(CONVERT(VARCHAR, GETDATE()-1, 112))) 
but that just returns PR20160713

I have tested all the date formats listed on the internet and none of them bring up what I want.

Is this even possible?

Need to create a unique id, using todays date is YYMMDDHHMM format, adding sequential number and text added

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.