That would be a nice change.

Another option

WHERE YourDateColumn >= DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0)  --First of previous month
AND YourDateColumn < DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)  --First of...

So you will want to do some date math.

You should treat all dates as the ISO standard and to avoid any ambiguity use YYYY-MM-DD formatting when passing dates to...

Just a thought, start by importing the file as all character columns, then analyse the data and reconstruct the target table. 😎 I don't like the Import AND...

I think the following error line from those that you provided is the key hint as to what is wrong...

Error 0xc02020c5: Data Flow Task 1: Data conversion failed...

Ah, careful now. ...

Apparently, this isn't an urgent problem, eh?

I think the following error line from those that you provided is the key hint as to what is wrong...

Error 0xc02020c5: Data Flow Task 1: Data conversion failed while converting...

Just try asking that same question on Google or any search engine.  It's a common question and there are a shedload of excellent articles on the subject.

Ah, be careful now.  If you use a formula for the backbone of your computed "field" (they usually referred to as a computed or calculated "column") and it has any...

I did want to mention that this machine is a 2 node(8 cores per) machine and the Cost Threshold for Parallelism is set to 50. Maxdop on server basis...

oRBIT - I finally figured some stuff out and used and old example of a small hierarchy and converted it to HIERARCHYID.  The "ID" column in your table is a...

I have a fellow that's trying to resolve some performance issues in a HierarchyID-based table.  I just don't use HierarchyID because I've found or made better ways to...

@shree23 ,

Thank you for trying but you posted no image of expected results like your post says you did and I know for sure that you didn't even try your...

I have a fellow that's trying to resolve some performance issues in a HierarchyID-based table.  I just don't use HierarchyID because I've found or made better ways to work with...