In SQL, I have a Date field called Origination Date that is a datetime datatype.
I am writing a View where I need to create a Request Number that is a combination of the Date field and the letters AB.
The end results needs to read: AB-20181002-# if the date was 10-02-2018. The end # is a counter for how many requests have been made for that day.
So I have a select query that selects the rows I need, how do I create this combination column?