I met Grant in real life. I still have nightmares.

Lynn Pettis (6/2/2014)

---

Koen Verbeeck (6/2/2014)

---

Lynn Pettis (6/2/2014)

---

Looks like a Cartesian product to me as well.

Looks like someone was writing the query using the ANSI-89 joins but forgot the WHERE clause...

Lynn Pettis (6/2/2014)

---

Looks like a Cartesian product to me as well.

Looks like someone was writing the query using the ANSI-89 joins but forgot the WHERE clause to properly restrict the...

prepaess (5/30/2014)

---

Hi all i added a parameter in my SSRS project but it didn't work and the value selected in combobox are repeated not distinct how can i solve the...

Seems like cartesion joins to me.

All the more reason I dislike writing inner joins that way. Too easy to forget the predicates.

The error means that either the column is too short, or that you are using the wrong code page.

When you changed the length of the columns, did you do that...

ramana3327 (6/2/2014)

---

Hi,

I am working with SP. I have to tune that sp.

I do have similar kind of code in two of the sp. I changed the distinct to group by....

bnghiem (5/22/2014)

---

Hello,

I have created a variable in a SQL Task and assigned it to a string variable. When I debug the container with a breakpoint, I can see the correct...

Parameters cannot be expressions.

http://stackoverflow.com/questions/12009832/how-to-concatenate-string-when-setting-a-parameter-in-transact-sql

Specify Parameters

mcfarlandparkway (6/2/2014)

---

Hello,

How to subtract the year to -1 in SSRS

I have the parameter called year, suppose id I give...

Sean Lange (6/2/2014)

---

Luis Cazares (6/2/2014)

---

SQLRNNR (6/2/2014)

---

Looks like it got removed. That...

Any formatting on the text field? Any special localization of the report?

Available values is the pane where you specify which values a user can choose when the report runs.

(when a report with parameters is run, you have to choose values for...

Do you have the logging enabled in the packages? If yes, which events?

Here's an overview:

Planning for Reporting Services and Power View Browser Support (SSRS 2014)