Here's a link that explains Output Parameters, which you should read.

So here's how I'd modify the procedure to return @cnt as an output parameter. I'd probably make some other...

If you aren't on Twitter you may have missed that Jason Brimhall (SQLRNNR) got awarded MVP today.

Luis Cazares (10/1/2014)

---

Most people won't download RAR files. Please post the code using IFCode tags [ code="sql"][/code] or at least text files. We would also need DDL and sample data....

Do you have specific format applied to the cells? Just guessing but I'd be there is some kind of illegal character in the source data that is causing your...

It looks like the article you linked to applies specifically to how Toad Intelligence Central works and not how SQL Server works.

As long as permissions are correct running cross-database queries...

Kevin is correct. And the number of indexes that is correct is going to vary greatly based on workload. Is it an an active OLTP system, then fewer...

HanShi (9/30/2014)

---

In the Netherlands there's a huge movement towards the "new working". More and more medium/large sized companies redisign the office space. It's all open, no cubicles, no borders between...

I'm sure there are other, perhaps simpler ways to do this, but here's one that works using Jeff Moden's DelimiteSplit8K function which you can get from and learn about here[/url]:

DECLARE...

No, that's in the printer properties, not anything in the report.

What order do you want your example data to be returned in?

If I just use:

SELECT

*

FROM

@IPAddresses

ORDER BY

[@IPAddresses].IPAddress

I get the...

SSRS is not designed to update data, it is "reporting" services, so is designed to display data. If you really need to perform an update on the selected data,...

I'm not sure what you mean by the term OLAP. Are you talking about cubes or data warehouse/data mart databases?

In either case, best practice is to keep them separate....

There aren't any dependencies between data sets in a report that I know of.

I think you want something like this, but I'm not sure:

CREATE TABLE #Tracking

(

ID INT IDENTITY(1, 1),

COrderID...

I recommend sp_WhoIsActive that Adam Machanic has provided free to the community. You can download it here.

If you don't want to go that route you need to be sure...