Have you tried this options?

,CODEPAGE = 'RAW'

,DATAFILETYPE ...

Brandie Tarvin (6/22/2016)

---

jasona.work (6/22/2016)

---

So, anyone want to start up a discussion like this closer to the US November elections?

[Commentary deleted by me]

I decided I was getting a little too vitriolic...

You're missing your row delimiter in the last row from your format file.

16 SQLCHAR ...

Here's a way.

Uncomment your preferred line.

WITH CTE AS(

SELECT *, ROW_NUMBER() OVER( PARTITION BY AccountID, Name, Region ORDER BY Special_Flag DESC) rn

FROM MyTable

)

--DELETE...

It's not returning anything because you're telling to return nothing. Your string has a length of 13 chars, if you remove the period, it will only have 12 chars. You're...

Basically, you just change InStr for CHARINDEX(). The following code simplifies the validation, the FROM is just used to generate sample data.

SELECT LEFT(PID, CHARINDEX('.', PID + '.') - 1)

FROM (VALUES('123.21'),...

As mentioned, no need for scalar functions as they perform really bad in queries. A CASE statement will work just fine and it's not really lengthy.

SELECT CASE WHEN LEN(phone) >...

You could use the Quirky Update. Be sure to read and understand the following article as you might get this wrong if you don't know what you're doing. http://www.sqlservercentral.com/articles/T-SQL/68467/

After that,...

Here are 2 options that might help you depending on your data.

SELECT *,

PARSENAME( REPLACE(JobNum, '-', '.'), 3) + '-'

+ REPLICATE(...

You have strings larger than the length of your column. Is that correct?

Even after formatting, you have different lengths on each section. Do you have a predefined length or will...

TRY...CATCH... won't block. Locks can block and locks are issued by SELECTs, DML and...

Palace

You just need to define the groups in your tablix. Identify which columns define a group and use them to get what you need. Your query should show the same...

No, that would become '29-feb-2' which translates as '2002-02-29'.

Only 22 dates will successfully convert in...

Ken Hiatt (6/21/2016)

---

dhaveedh (6/21/2016)

---

Ken Hiatt (6/20/2016)

---

This was definitely wrong on many levels, but what strikes me is that they are expecting to extract a time from the first 8 characters...