Put the path between double quotes (").

Could you elaborate more on what do you need? I'm not sure what you're trying to do. If you want to apply rules, you might need to change your table...

Nibbles(.bas)

Does this gives you an idea on what to do?

CREATE TABLE dbo.SampleDates(DateofRecord nvarchar(20));

INSERT INTO dbo.SampleDates

VALUES

('"04/24/2013'''),

('"05/01/2014"')

--Option 1

--Just the Query

SELECT convert(datetime,replace(replace(DateofRecord,'"',''),'''',''))

FROM dbo.SampleDates

--Option 2

--Create new column with correct data type, assign correct values,...

What do you mean by didn't work?

Are you trying to change the column definition or just use it as datetime in a query?

There's an unanswered question about spaces. Would multiple spaces are valid? Would they be valid only if they're within a single gap but not with multiple gaps?

Here's the code for...

rarara (7/24/2015)

---

Luis Cazares (7/24/2015)

---

That's a solution, but it's not the solution. Your lengthy function, does basically what my code does in one line.

Another simple...

I'm not sure if you still need it, but here's a way to make it dynamic. I changed the table variable into a permanent table because I didn't want to...

lsalih (7/24/2015)

---

Question: Now that I changed the actual query, I am running into getting more than 1 record per year for the rows which do not match because of grouping....

That's a solution, but it's not the solution. Your lengthy function, does basically what my code does in one line.

Another simple solution would be...

If you have 3 different tables going to 3 different files, then you just need a single data flow task with the 3 flows.

Why do you want to make...

Do you need to remove the characters that shouldn't be there?

Or simply identify the values that shouldn't be there?

The second option is far less complicated as you just need...

Happyness

The problem is not your CASE statement, but the GROUP BY clause. You need to group the same way you're presenting the information, otherwise you'll get unexpected results with apparent...

johnnycash (7/23/2015)

---

Thanks Luis! Very clean and precise, I like it. If I may take advantage of your disposition to help, I have instances when an OrderID will have...