DesNorton, your solution is so much simpler. Thank you very much!

DECLARE @naam AS varchar(20) = 'I' + RIGHT(CAST(DATEPART(yy,GETDATE()) AS varchar),2) + RIGHT('0'+CAST(DATEPART(mm,GETDATE()) AS varchar),2) + '-' + @zeroes + @MAX_naam;

Oh bless you, Scott Pletcher, this works wonderfully.

• This reply was modified 2 years, 6 months ago by  Melanie Peterson.
• This reply was modified 2 years, 6 months ago by  Melanie Peterson.

OK, you're right. However, when I change my code to DECLARE @zeroes AS varchar(5) I get the same result. @zeroes = '0'

Thank you very much for your feedback. You've given me a couple of useful options, plus a couple of things to think about. This is a query that came from...

OK, here's the "harch" execution plan:

<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.5" Build="11.0.7493.4" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
  ...

I can upload the execution plans as XML. Is that OK?

No, I didn't get an error message when I posted the files, but apparently they didn't upload. So here goes. First the DDL for vwRequests view:

USE [CMI]
GO

/******...

Here are the defs of the 2 views. One thing I discovered is that ConflictCheckStatus, referenced in vwRequests, is a view. I add it here.

OK, I'm posting the DDLs for all the tables used in both views. I'm also posting both execution plans, the one that takes 3 secs (chameleon) and the one that...

Good observations. The view, like this query, is a mess. It joins 7 tables, including one in a database on another server with a different collation, and another view. However,...

• This reply was modified 3 years, 10 months ago by  Melanie Peterson. Reason: More info

Yes, I understand completely. The software the vendor is selling allows our systems admins to give network credentials to  no one. We will log into servers using dummy credentials via...

OK, I think I got it. If I create a csv file with column names ONLY and then link to a Flat File Connection Manager with Column names in the...

When I do that, I don't get the column names I assign in my SQL statement in the OLE DB Data Source; I get column names that the SSIS package...