Re: "OpenQuery does not accept variables" -- This runs fine in my set-up: Select * from OpenQuery(MyLinkedServer,'Declare @name varchar(50) Set @name=''RemoteDB'' Select * from sys.databases where name=@name') Note the declaration of the variable within the query statement (and the ...
I tried to find some solutions to overcome these but I wasn't able to find anything useful. I don't really understand what the first error message means. Trying to declare the @DateBegin variable with the SQL DECLARE and SET methods only resulted in an error message saying "@DateBegi...
Access Code - DELETE Statement with DISTINCTROW and T-SQL Access Now() vs. T-SQL GETDATE() ? ADD and SUBTRACT depending on the condition is CASE STATEMENT ADD COLUMN to variable table? Add prefix in data column Add Time in SQL HH:MM:SS to another HH:MM:SS Adding a column to a lar...
Can I create a SSIS package to get only row 12 to row 123 from an excel sheet..?? Can I have multiple instances of SSIS on a server? Can I preserve carriage returns in a string variable from SQL Server? Can I query SQL Server Agent Job Step Configuration Parameters Can I Referenc...
I tried to find some solutions to overcome these but I wasn't able to find anything useful. I don't really understand what the first error message means. Trying to declare the @DateBegin variable with the SQL DECLARE and SET methods only resulted in an error message saying "@DateBegi...
Can we edit @timestamp variable in SSRS? Can we have combo chart in SqlServer Reporting Services 2008 ? Can we use CSS in SSRS? Can you create a subscription with a dynamic date Can you tell me which SQL server edition and version is 9.00.1399.00? Can you use a hierarchy as a paramet...
I tried to find some solutions to overcome these but I wasn't able to find anything useful. I don't really understand what the first error message means. Trying to declare the @DateBegin variable with the SQL DECLARE and SET methods only resulted in an error message saying "@DateBeg...
Access Code - DELETE Statement with DISTINCTROW and T-SQL Access Now() vs. T-SQL GETDATE() ? ADD and SUBTRACT depending on the condition is CASE STATEMENT ADD COLUMN to variable table? Add prefix in data column Add Time in SQL HH:MM:SS to another HH:MM:SS Adding a column to a ...
Can we edit @timestamp variable in SSRS? Can we have combo chart in SqlServer Reporting Services 2008 ? Can we use CSS in SSRS? Can you create a subscription with a dynamic date Can you tell me which SQL server edition and version is 9.00.1399.00? Can you use a hierarchy as a par...
[Execute SQL Task] Error: An error occurred while assigning a value to variable "maxDate": "Value does not fall within the expected range.". [File System Task] Error: The process cannot access the file because it is being used by another process. [Flat File Source [2]] Error: Cannot...