Try using .value() instead of .query. I think that the .query may have an implicit conversion to varchar in it somewhere. With the .value, you can specify an...

He also has a valid point here. We already know that there was a problem with multiple records being returned and both the subquery and the merge will raise...

I think that this performs better, because it only requires one scan of the table instead of two.

SELECT * FROM #tmp

ORDER BY ROW_NUMBER() OVER( PARTITION BY Gender ORDER BY Name...

It's "next" as in "following", not "next to" as in "adjacent". That still doesn't explain what to do with the "][", since the following character doesn't have an uppercase...

The non-standard WITH CUBE has been deprecated as of SQL 2008 in favor of the standard CUBE(<composite element list>) syntax that was introduced in SQL 2008.

GROUP BY (Transact-SQL)

---

WITH CUBE

This feature...

No, it's SQL 2005 or greater.

Drew

Just to clarify, here is a quote from BOL (emphasis added).

Subqueries with EXISTS

---

When a subquery is introduced with the keyword EXISTS, the subquery functions as an existence test. The WHERE...

Since the error is occurring in your VBA code, not your T-SQL code, you're more likely to get help from a VBA forum.

Drew

You can still create a temporary table or table variable that holds this information. It probably isn't as good a solution as incorporating it directly into the database, but...

I think the best way to do this is code it into your table with a foreign key to the overarching corporation. That way you can prevent things like...

T-SQL doesn't have a Boolean data type, so I see no problem with using a BIT to represent...

The CASE function cannot return a Boolean value. You can either rewrite your query to return a pseudo-Boolean value and then check whether that value is equal to "true"...

Sean Lange (5/11/2012)

---

themangoagent (5/11/2012)

---

Jeff Moden (5/10/2012)

---

Didn't look to see if it was mentioned before but one sure fire way to increase the performance here would be to use UNION ALL...

I still don't see any sample data. It's hard to rewrite your view if we don't have data to compare the original results with the revised results.

Also, please pick...

This problem is almost certainly due to parameter sniffing. Gail has a good article on Parameter Sniffing[/url]

There are other issues with your code, though. You should use a...