The error is coming from your Caché database, so you'll probably get a better answer from a Caché forum, but it looks like Caché doesn't support the DATE datatype.

Another...

itskanchanhere (3/15/2012)

---

Guys, I need an answer in general. What can be the disadvantages of using any 3rd party tool other than sql server mgnt studio.. I dont answer specific to...

ColdCoffee (3/14/2012)

---

How about this?

SELECT DatetimeasVC , CrsApp1.String , CONVERT( DATETIME , CrsApp1.String) [Converted To DateTime]

FROM @Table

CROSS APPLY (SELECT CHARINDEX('.',DatetimeasVC ) ) CrsApp (Idx)

CROSS APPLY (SELECT LEFT ( DatetimeasVC...

Part of the reason that you are having problems is that your first table is not normalized properly. Instead of having a separate column for each month, you should...

Based on this comment, it looks like you need to add parens to your query.

ken def

---

I'm beginning to think that the OR clauses are allowing the query to go outside...

Don't let your developer play around in the live database!

Note that RESEEDing the table can cause problems because of duplicate values if not done carefully. In the vast majority...

The calendar table allows you to more easily handle holidays. The fact that the OP said he wanted to return the "next working day (Monday)," indicates that he needs...

Check out the following article. Fun with business days, calendar tables, and test-driven development[/url]

There was a recent thread about calendar tables, but I can't find it right now.

Drew

ismailmallum (3/8/2012)

---

Is there also a way of dynamically changing the Output column in the XML Source component of SSIS. If this is possible the is would be simpler to let...

Try using a CROSS APPLY instead of the EXISTS.

UPDATE t1

SET t1.col1 = t2.col1, t1.col2 = t2.col2, t1.col3 = t2.col3, t1.col4 = t2.col4, ........

FROM t1

INNER JOIN t2

ON t2.ID = t1.ID

CROSS APPLY...

Samit Shah (3/7/2012)

---

Now when I change the Server Name and Database Name in XML file, it doesn't picks the SQL SERVER Package Configurations which is specified in XML, instead it...

A CASE statement should be faster, because it doesn't have to do the aggregrate calculation (even though there are only two values in the aggregate for each row). My...

The standard term is "shredding XML".

You first need to be familiar with XPath and XQuery. You can find tutorials on the web. Once you feel comfortable with those,...

Another option is STUFF()

STUFF(p.SSN, 1, 7, 'XXX-XX-'

Drew

Please refer to the following article on how best to post sample data.

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Second, your sample...