Answer Questions

• gaorellana Report performance

  Real quick I have multiple reports that use the same headers say Topic 1 and Topic 2 The body of the reports will have 0-50 records and 2-15 columns. These reports will be run many times concurrently. My question is which is more efficent 1. Open connection Call sp to returns Topic 1 and Topic 2 for report header Close connection Open Connection Call sp to return the report body data 2. Open connection Call ...Show All

• Michael_SQL Header Footer problem

  Hi There, Does anyone know of a way to disable Header and Footer for specific pages The desired output is displayed below. e.g. i want header/footer to be disabled only for page 2. --------------- --------------- HEADER --------------- Page 1 Page 2 --------------- FOOTER --------------- --------------- Thanks. Hi Ryan, Thank you very much for your ...Show All

• dupy How to check if row exists...

  Hello, I'm SQL Server 2005 newbie, could you be so kind and help me how to write the most efficient way stored procedure, which checks by PK if specified row exists, then updating the row, otherwise inserting new one. Thank you for your kind help. How do you determine which data to copy over How do you determine the "last" row How are you accomplishing the ...Show All

• tdpro Run SSIS Package from SQL 2000

  I am looking for a way to execute an SSIS package as the next step in the SQL 2000 Agent, with the first step being replication. Can I reference dtexec.exe on the SSIS box to execute the package located in the file system Thanks JWeil wrote: ... Can I reference dtexec.exe on the SSIS box to execute the package located in the file system Yes, should work. Agent in SQL 2000 has a limitatio ...Show All

• Relja Markovic Dynamic Excel Sources

  Please help.... I have different files that are sent from our vendors. Some are TXT and some are XLS. Some will have the same structure. I plan on grouping these together as best as I can. My main problem is that I would like to go from one source that matches a group of files to a single SQL table. I'm still learning about SSIS and its capabilities. If I can get pointed in the right direction or have an example to work from, that would be ...Show All

• Bharati Kumars InvalidProgramException on Adapter.Fill

  Hi, Using VS2005, Framework 2 and SQL 2005 Mobile all from the recent launch in Australia, I have created a new Smartdevice project in c# and have created an SQL mobile database with 1 table in it. I added a datasource/dataset referencing the mobile database and it displayed the table/columns etc in the Data Sources Pane. I changed the table type to details, then dragged the table onto a blank form. VS created the form well and al ...Show All

• Jose Luis Manners Can you create an Alias in a Data Source View?

  Hi All.  I'm building a report model for the first time (SQL Server 2005 June CTP).  I created a data source view by adding the tables that I wish to have in the model.  Now I want to use one of those tables more than once, but I don't see a way to create an Alias.  I see that I can create a Named Query, so I could use that, but I'd rather have an Alias for performance reasons.  For example:  Let's say you have a Fa ...Show All

• Bill Zunis SSRS taking forever to load a simple select

  I did a simple select below on a DB table that has a total of around 650,000 records.  If I run this select in Query Analyzer, it takes around 11 seconds and returns 19,000 records. In my SSRS report, I've created a dataset that runs this query, the same one I ran in Query Analyzer that took only 11 seconds: select * from master where customer = '0000002' After putting this select in a dataset, I then grabbed one of the ...Show All

• Worachart Report Builder - Error!

  I defined a report through the Development Studio of SQL server 2005 which has got a grid and a chart in its layout. If i try opening the same report through the Report builder I get the following error. Why is it so ====================================================== Cannot open this item The report cannot be opened in the report builder. Object reference not set to an instance of an object. ============================================= ...Show All

• Julia168 Failed to prepare query - Designer Report with Model as Datasource

  SQL Server Reporting Services 2005 Problem: I'm trying to create a report in Visual Studio 2005 using a data souce to an existing model that I deployed earlier.  When I drag some fields on my report then click run, I get the error below. screen shot: http: / / www. webfound. net/ reporterror_ model_ designer. JPG TITLE: Microsoft Report Designer ------------------------------ An error occurred while retrieving the parameters in the query ...Show All

• sdknewbie % remainder in SQL

  In t-sql you can do the following to check if a value is odd or even. If it returns a 0 then the number is even, if it returns a 1 it is an odd number. select @Value%2 I need to do something similar in a backgroundColor expression in RS 2005, any ideas I dont see any built-in function for this. You could do something like this and just use the boolean result(pseudocode only, not tested) (@Value/2 = CInt( ...Show All

• simmonsj_98 SQL Mobile Query

    On the paper: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp frame=true While trying to complete the exercise, I encountered the following unexpected behaviour: While configuring the subscription for the SQL Mobile (from the tutorial – To complete the subscription) section, I encountered the following error – TITLE: Microsoft SQL Server Management Studio ------------- ...Show All

• Greg Pierson - MSFT Dynamic T-SQL steatment

  How can i build a T-SQL statement dynamically Vivek S i have declared a variable of type string and initialised it with a T-SQL statement. The sql statement size is around 5000 characters. To have some run time modifications, i have used a script task and initialised the SQL to the variable so that it can take the changes at run time. i have used a DataflowTask within which accessing the variable for th ...Show All

• Tian Problems installing SQL Server 2005 SP 1

  SQL Server installation fails with the message: "A recently applied update, KB913090 failed to install" The last executed task was: Integration Service The last installation message was: Checking for lock files via Windows installer sqlrun_tolls.msp Hello! We are also having this issue (same KB913090 aborts during the Database Engine update). The rest of the update actually does complete (including Analysi ...Show All

• JeffGill New Guy Question 2: SQL on-the-fly at package runtime?

  Here I go again...thanks for your patience... I'm trying to create a single, all-purpose SSIS package that would move data from a source database table to a matching target database table. The requirement is to create the package such that the SQL statement used by SSIS could be supplied at runtime. This would allow a single package to be used for different SQL statements, representing different tables, rows and columns, etc. as needed. The data ...Show All