Are you embedding the SQL in the report or is the report calling a stored procedure? The latter would be preferred if possible.

wendy elizabeth (8/14/2014)

---

In answer to your questions and with my additional questions:

1. SystemAdmin privledges under Site Settings > Security , can you tell me what I am looking...

Or if you want less than the last day of the prior month (instead of less than the first day of the month)... just subtract a day from the answer...

I've noticed in the case of a multi value parameter, the Select ALL option shows when the code is embedded in the reports. That is, a stored procedure is not...

reddychaitanyakrishna (7/22/2014)

---

Hi Friends,

Please Help me......

I Have the below requirement........

1. Design the DB for ‘Retail Stores Business’ where various products are on sale in both physical and online stores across the...

Have you tried to connect to the reporting service through management studio? Are you able to to see the reports folder there?

What version of SSRS are you using? You should have a radio option to not set a default value for the parameter. Also, run your query by substituting a null...

WILLIAM MITCHELL (7/22/2014)

---

Back to the OP, in the event that somebody actually needs help...

If Access is prompting for a password, but there was no database password set - then the...

Some use triggers in these cases to potentially record changes to important information. These do add overhead to a tables performance but they exist for a reason.

It helps to be able to see what you are seeing. If this is still an issue for you can you post a sample of your xml data? Have you...

Another option if you wanted to have the collation changes apply to existing objects, you could migrate the data to a new database with the desired collation.

Depending...

Thanks Jeff for sharing your knowledge here.

Kevin, I'll have to read up on Latching. Thanks guys.

Please try a quick Internet search:

I quickly found this here

http://social.msdn.microsoft.com/forums/sqlserver/en-US/6680aada-dabf-447d-be77-a2088018594a/info-about-latin1generalbin-collation-s2008r2

The one on your test server was case insensitive (hence the CI portion in the name). That is no...

Jeff Moden (5/27/2014)

---

Ryan Keast (5/27/2014)

---

Hi there,

I had the following script that used to work in SQL2000 but now that I have migrated it, it no longer does.

,TEN.[tncy-sys-ref]

+...

Jeff, I wanted to get your take on something Gail posted once :

http://www.sqlservercentral.com/Forums/FindPost485499.aspx

The way I read it, a clustered index (pk or not) won't necessarily cause a huge slowdown to...