Search results for query: *

I'm using Oracle version 10.2 and have a query which contains many WHERE conditions, but one in particular I cannot get to work. Here is the code: where table.division_id in (CASE WHEN :Division = 'AA' THEN '02' WHEN :Division = 'BB' THEN '09' WHEN :Division = 'CC' THEN '07' WHEN...

I'm converting a report from Crystal Reports to SQL Server RS 2005, and I'm stuck on a multi-part, nested IF-THEN-ELSE structure that's necessary to display the data the user wants. I don't know if I'm trying to use too many nests, or if I can't keep track of the multiple ELSE's. Below is the...

I'm trying to find out how to tell which license model was used when several SQL Server 2005 instances were installed. I tried @@Version, but it doesn't include information on whether it is licensed per processor or per server (with CALs). Does anyone know how to find this information on SQL...

SQL Server 2005, SP2 (build 3042) running on Windows 2003 Server (SP2) functioning properly. However, I need to install hot fixes that came out after SP2 on the SQL Server instance. Actually, now that SP3 is out, I'd like to install that. Here's the history: Installed SQL Server 2005 in June...

Using SQL Server 2005. I created an SSIS package that runs fine by itself and provides an ADO.NET recordset as output (Data Reader Destination). I then created an SSRS report that connects to that SSIS package as its datasource. On the Data tab in the SSRS designer, I can execute the query...

Using SQL Server 2005 SSIS. I have created a package that imports a flat file, does some conversions and adds a couple of derived columns and then sends the output to a SQL Server table (works great). Now...I want to add logic in a step before the OLE DB Destination step that determines the...

I'm using a PS script to gather all of the scheduled tasks on a number of servers. I have the server names saved in a .txt file, and am referencing that in the PS script. The problem I'm having is that no matter what order I put the server names in, the output only shows the last server name...

I'm using SQL Server 2005, SP2, and SSIS as the package designer. I have (thanks to a script I found on the internet) created a script package that looks at the Event Viewer logs on a designated machine. It executes fine, but I need to store the results in a table somewhere. In fact, I want...

I'm using SQL Server 2005 Integration Services and Reporting Services. I finally figured out how to use an SSIS package as a data source (in Books Online--you have to modify the .config file) and even got the package to accept variable data from the SSRS data source, but now I can't set a...

I'm using SSRS 2005, and I have a report that is using a table with only 2 columns. The possibility of many rows is very high, and the user wants the two columns 3 times on the same page (there is enough room). The table column width (both columns) is 2", so it would easily work...if I could...

Using SQL Server 2005 SSIS and SSRS. I have a package that gathers data from and Oracle 10g database and a DB2 database, and does some processing to provide a merged dataset. When I built the package, I hard-coded the value of an identifier, but now I need to assign a variable to that value...

I'm using SQL Server Reporting Services 2005 and can't seem to figure out how to make one portion of the text bold while leaving the rest of the text normal. I searched in this forum and found similar requests without an answer (see thread1462-1417476 ). In the report, the user has a paragraph...

I'm using SSRS 2005 connected to an Oracle (yikes!) 10g database and I'm getting all the fields I want, except I cannot get DateAdd to work. I'm pulling a datetime field from the database, and the end user wants that date field to appear on the report along with that date-plus-one for a "due...

Hi, I hope I've thouroughly searched for WSUS and SQL Express to have not missed this on a forum. Anyway, I'm using Windows 2003 Server, STD, SP2, and have IIS 6.0 installed, along with .NET 2.0, and have installed SQL Server 2005 Express, with SP1 to be ready to install WSUS 3.0. When I...

I'm using SQL Server 2005 and need to figure out how to write a query that will show me missing ID numbers. The number series is "2000xxx" and I've found a problem with the front end .asp page that's allowing users to skip adding user ids. Anyway, rather than manually look through all of the...

I'm using SQL Server 2005, trying to build a stored procedure or even a DTS (or SSIS now...) package that will execute properly for "Last Week" no matter when the procedure is run. I am trying to figure out how to configure the starting and ending datetime values to always set to the beginning...

I am trying to replace values in a table column. It is a single table (although it is related to other tables...) that has a column called "CompanyEmailAddress". One of our sites has changed the domain name, which of course changes the email address. For example, the current email address of...

I am using SQL Server 2005, specifically Analysis Services. The cubes are already created, but I need to update (refresh) them regularly using the SQL Server Agent to schedule a job. This was a very easy task in SQL 2000, but I can't figure out how to create a job that will process AS cubes...