How about reducing some steps?

DECLARE @str VARCHAR(250) = 'DWDate,Email,UserID,ID,LoanNum,PersonEmail,LoanDate,Paymt'

SELECT RIGHT(@str, CHARINDEX(',', REVERSE(@str))-1)

Ed Wagner (3/14/2016)

---

That leading wildcard in the search will force a scan of the column, so the...

Unread

You might find some inaccurate results, but a simple conversion to datetime then to time might work.

SELECT CONVERT( time, CONVERT(datetime, 0.416666666666667))

Are you sure that you don't have invalid strings that escape your validation? Something like 'asd%'

I tried to replicate the error but wasn't able to do it. This is my...

Use a CTE with ROW_NUMBER to find the first for each group.

WITH CTE AS(

SELECT c.CompanyName,

v.UserId,

...

rcooper 78099 (3/10/2016)

---

unfortunately I do not have those options see screen shot attached.

Luis Cazares (3/10/2016)

---

What do you mean by...

Did you follow these steps?

- Open the Parameter properties.

- Set Data type to Date/Time.

- Go to Default Values tab.

- Click on the formula (fx) button.

-...

What do you mean by have not worked? How are you assigning the default value?

I just tested both approaches...

It's a nice article that explains this problem which unfortunately is more common that it should be.

I'd take a different approach which includes some "safe nets". It seems that your...

gabtugm (3/5/2016)

---

Luis Cazares (3/4/2016)

---

oneteabag (3/4/2016)

---

Nice Thoughts newbie, I got the logging part but wasn't sure if I stay away from SSIS how I would automate this process.? Right now it...

pants

You're...

The code already has that value. If you can't find it, maybe you're not understanding how this works.

Please, try to explain it and ask any questions you might have.

Using a tally table and SUBSTRING(), it's very easy to accomplish this. In this example, I'm using a cte to create the tally table on the fly.

Consider changing the text...