Google on this error message and try some of the suggestions that you find:

I've seen some resolutions where the error was caused because there was...

Great story and very inspirational.

SELECT *

FROM sms_processedfeeds

WHERE pf_fund='108'

AND pf_trtype='SIPDEBALT2'

AND pf_entdt >= '08/05/2014 00:00:00'

AND pf_entdt < '08/06/2014 00:00:00'

Nice question. I use SQLPrompt by Redgate so I immediately get all the column names and data types through the IntelliSense without even doing anything 😎 :w00t:

Eirikur Eiriksson (8/6/2014)

---

Jeff Moden (8/5/2014)

---

rajeshn29.dba (8/5/2014)

---

Hi Friends,

I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity...

happycat59 (8/5/2014)

---

Firstly - I haven't done this as yet but...

They should be - in the project properties, you set the folder that you want to deploy shared datasets to. ...

SQLRNNR (8/5/2014)

---

Koen Verbeeck (8/5/2014)

---

It's the holiday season...

It's the holiday season for everyone 😎

That will work when you want to display the values of the parameter into a textbox.

Not sure...

This article should get you started:

Loop through Excel Files and Tables by Using a Foreach Loop Container

susmitha117 (7/30/2014)

---

Hi,

I have a file which changes every week @C:\TEMP(data and filename both) schema remains the same all the time. I want to import this data to sql and save...

Your initial question states otherwise:

I have developed report with parameter having multi value option. The report was developed...

Well it is weird. SSRS 2008R2 can work with multi-valued parameters. A bit strange you develop on SQL Server 2012, only to deploy to a lower version.

What if you create...

No use of stored procedures?

So if I understand it correctly, SSRS passes ('A','L','P') to SQL Server in acceptance, but ('A,L,P') in production?

Without any changes to the report or queries?