Regarding the first error: are you executing the script in the correct database?

Regarding the second error: you forgot the parameters data types.

Divine Flame (1/28/2015)

---

I think the information was too short for an article. "You need to put an alias for the subquery", that's it, that was the all info.

It could have...

Normally there should be an explanation somewhere. What if you hover over them with the mouse?

anjalipunjabb (1/28/2015)

---

You can also use oledb to connect to Sql Server but the performance is lower as compared to a adodb connection which is optimized to work with Sql Server...

Which tool are you using?

Are there any errors/warnings or tooltips that give more information?

Easy one. I use it a lot to test two tables (one from test and one from prod) to see if the data is equal or not.

So it seems the snow blizzard of the century in New York was just a mild breeze?

What kind of project are we talking about here?

Awesome question, it made me think about PIVOT which I almost never use. Thanks Steve.

srajpx (1/26/2015)

---

I believe that for each row of the first subquery, the second subquery is executed. Say, the first sub query returns 100 rows, for each of this row the...

You can take a look at Targit, Qlikview and Tableau.

GilaMonster (1/26/2015)

---

Sean Lange (1/26/2015)

---

Jack Corbett (1/26/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700...

It all depends on the query and how many subqueries there are.

I've encountered cases where temp...

Nice basic article.

I encountered the same issue when I was learning T-SQL, so I'm sure people will benefit from this article.

It's not the most easiest tool, because users have to write their own queries. Unless they all use stored procedures or shared datasets.

Or you can use the report model...