I have to agree with MentalWhiteNoise (great moniker by the way). That query is simpler and I am going to guess it returns the same data.

You could also use...

You cannot use variables for column names, table names, etc... In order to do what you want you would need to use dynamic SQL.

Set @sql = 'Drop Table '...

Unfortunately the forum does not like to show HTML/XML in posts so we cannot see the code. Your best bet is to zip the rdl file and attach it to...

How can someone update a row they cannot see?

How do you abuse select?

Yes you can grant insert and update without select. I am of the opinion that you control access...

I think this does what you need (I set dateformat because my machine is not set to dmy):

[font="Courier New"]SET DateFormat dmy

DECLARE @episodes TABLE(id INT, Source VARCHAR(20), DateSampleTaken DATETIME)

DECLARE @PositiveSamples TABLE(id...

If you are really in SQL Server 2005 then you could use the varchar(max) data type.

Could you explain how you are doing the import (SSIS, DTS, Linked Server,...

Yes your low cache size is causing this. How much memory is on the server and what is SQL Server configured to use? Are there any other applications...

or:

[font="Courier New"]SELECT

    Table_Schema,

    Table_Name,

    Column_Name,

    Data_Type

FROM

    information_schema.columns

WHERE

    table_name = AND

    table_schema = [schema][/font]

You need to enable 64-bit ASP.NET. Here is an MS KB Article that discusses how to do it, http://support.microsoft.com/kb/894435

YOu need to add the port to your connection servername\instance, port

It depends on what you want to do. In your first option you are only going to get the column from the first row returned (could vary based on...

You do not need to open the package on the server. You can open it from any PC with BIDS installed by creating an SSIS project and selecting ADD...

I think there will always be opportunities for competent Technical people, because no matter how simple a computer or software product is to use it still needs to be designed,...

It is not a best practice to add index and join hints to queries in SQL Server. With each release the Query Processor has gotten better and usually makes...

I don't think it would be too difficult to do in VB.NET. You could write a CLR procedure that handles this. I really think MS missed the boat...