Technically you only have 3 Devices accessing the database, but I doubt MS will see it that way. My understanding is that for web applications you should license SQL...

I don't see any image attached :D. You can install in the .NET Framework without uninstalling VS2008. You probably have the framework installed but not registered...

I forgot to reset the @final_sql variable so it was continually adding on. Down where you close the cursor put in Set @final_sql = ''. You may also...

I'd start by getting involved in local user groups and making it known that I was available. Someone at the group will likely either need some help or know...

It depends on what you want to practice. If you just want base T-SQL then get Express w/ Advanced Services, if you want SSRS, SSIS, or advanced features get...

Not that I am aware of. The only way to guarantee a matrix will stay on one page, that I am aware is to limit the # of columns....

Why are you using a datareader source? I'd recommend using the oledb source.

SQL Server does deferred name resolution because you can create a proc before a table or you can create a table within your proc.

There is actually an issue on Connect,...

I'd sympathize, but I cut and paste them directly into SSMS and have no problems running the code. As far as SSC making it easier, it is actually the...

Since there are 15 code blocks in the article is there a specific one you are having a problem with?

SQL itself doesn't care about whitespace, so as long as you...

Are you using SQL 2005? Based on what the errors are I'm guessing you are running SQL 2000 since varchar(max) was added in 2005. Change the max to...

First of all, what article? Secondly does the code run?

Puneet,

I really think what you want is separate reports based on the parameters passed in. SSRS does not have a simple of way of having dynamic columns. If...

How many tables/columns are we talking about? Do you have some off-peak time to do this in?

This may not be the "best" or "right" way to get his information,...

So you want to know how many non-null values are stored in each column in each table and how many total rows in the table?

For example I have tableA(id int...