Here's a slightly different take. This method makes the @UID parameter optional and sets it to NULL initially. If you don't have a UID simply don't pass it.

SET ANSI_NULLS ON

GO

SET...

Another option, try qualifying the table with database.schema.tablename to see if this resolves your issue. It appears the DSN is getting to the server just fine.

Instead of using temp tables you could use a table variable to hold your data during processing. The field definitions will be within your procedure and can easily be altered.

I agree with you Steve. I should clarify my last statement. I know there are many developers and DBA's out there that think they should have the high salary just...

I see more of a need for true DBA's in the larger organization where several database servers exist. These DBA's typically take on more of a system administrator role than...

Report Builder is present in SQL Server 2008 and sounds like the best choice for your requirement. If you are building a custom reporting environment, there is a component you...

You should research modifying the SSRS style sheets. You can modify the appearance of the Report Viewer and Report Manager. Start with the following link:

http://msdn.microsoft.com/en-us/library/ms345247.aspx

I can't think of a way unless the employeeid values are written to a table prior to calling the procedure. If that is the case, you can simply add a...

Hi try the following changing the table back to your table name...

declare @ab varchar (100)

declare @cSQL nvarchar (200)

set @ab='''483503'',''483504'''

SET @cSQL = 'select * from tmpEmployee...

Another option is to use a table variable to store your results. As long as you know the structure of the resulting data, you can setup your table variable as...

Without knowing your table structure the issue is difficult to assess but here is a possible solution you can work with to gather TOP x items for each buyer based...

Thank you for your reply. My main issue right now is dealing with adding the Excel references. In my script task I wan to create an Excel object (Dim xlApp...

I'm not sure what version you will be using but the complete reference series serves as a pretty good resource. Good luck.

http://www.amazon.com/Crystal-Reports-XI-Complete-Reference/dp/B000RG1OJS/ref=sr_1_15?ie=UTF8&s=books&qid=1210863899&sr=8-15

I've worked with Crystal Reports through several versions. If you know Reporting Services and Access Reporting you will have no issues converting to CR. The Crystal syntax is very simple...

I have a big issue with granting any login db_owner and especially sysadmin. I have recently gone through a similar cleanup where users had this level of access. I don't...