Answer Questions

• Asim Ahmed Problem of merged cells in excel format after exporting from SQL Reporting Services 2000

  Hi All, I've faced a difficult problem. After exporting any report from reporting services to excel file format, in excel sheet there are several merged cells appearing in a cell. I'm using SQL Server 2000 & Microsoft Visual Studio .Net 2003. Can anyone help me out regarding this Is there any method in reporting services, so that every column will appear into one cell in excel sheet after exporting the report Thanks, Uttam Kr. Dh ...Show All

• emredincer Differences between SQL 2005 Editions (Ent vs Std)

  Is there a detailed whitepaper or something, listing differences between the SQL 2005 Enterprise and SQL 2005 Std editions We're trying to develop something for Std, but it appears that the Developer Edition parallels Enterprise. This puts us at risk of developing something using a component which will not be available. For example, I read somewhere that clustering and "advanced ETL" were the differences. First of all, we really ne ...Show All

• limno Authentication Issues

  Current Setup: Windows 2003 Server SQL Server 2000 w/ SP3 Windows Sharepoint Servics Problem: I have created a group on our Domain (INT) called Domain Users. Inside this group I have added individual users that need to be there. On the SQL Server when I try to add INT\Domain Users I get an error stateing that the user does not exist. Next I tried typing in INT and selecting the browse button. The window opens up listing all Domain users and grou ...Show All

• js123 order by in a view in sqlserver2005

  Hi, I've a problem with a created view in sqlserver2000 that I'm now using in sqlserver2005. This is the view : CREATE VIEW hsarti01_VD1 AS SELECT TOP 100 PERCENT * FROM hsarti01 WITH(index(hsarti01_PK)) ORDER BY 1,2 desc,3,4 When I do the "select * from hsarti01_VD1" in sql server 2000, I see in the result that the order by is been using. but in sql server 2005 it's just using the order of the primary key and not the orde ...Show All

• Arthur Dzhelali SQL

  Hi! We are getting an error while trying to open Replication Publisher's properties on a server named - SERVERNAME.SUBDOMAIN.DOMAIN.COM rather than SERVERNAME with following details... SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'SERVERNAME'. (Replication.Utilit ...Show All

• Jus55 USING the IN in STORED PROCEDURE

  I have a problem in passing parameters on stored procedure using the IN in the were clause as below ALTER PROCEDURE SELECT_MULTIPLE @MULTI VARCHAR(54) AS SELECT MSISDN, IMSI, HLR_NO FROM HLR WHERE MSISDN IN (@MULTI) ORDER BY MSISDN WHEN I EXECUTE THE PROCEDURE ON QUERIES ON MSACCESS NO OUTPUT WHERE PRODUCED AND data entered is as follows '639229380968','639229485075','639229346127','639229416465' I remove the quote but I can get an o ...Show All

• Ian Donald SQL Mobile performance/size problems with WM5 device

  I just upgraded our application from SSCE 2.0 to SQL Mobile. Our app is written in C++, and we use OLE DB for most of our queries, including the routine the downloads and inserts our lookup table data. This application is running on a Dell Axim X51. Using SSCE 2.0, this routine takes 236 seconds, with most time spent inserting data into various tables (using OLE DB). The resultant database size is 15.1 MB. Using SQL Mobile, this routine now take ...Show All

• sfx1 To persist or not to persist?

  Hi, I'm running Windows Server 2003 with SQL Server 2005. For an ASP.NET application, what is the best choice for opening a link to the database The three possibilities I've thought of are below. 1) An application-wide link which is persistent and serves ALL incoming clients. 2) A link which is persistent ONLY for the duration of a given client's session. 3) A link which is established (and closed) with each and every load of a page. ...Show All

• Ken_H Help -sql query

  How to do it in a query ID EffDT MonthFirstDay 162028 1 11 162028 12 123 162028 15 567 Expect result: ID EffDT MonthFirstDay EffDT MonthFirstDay 162028 1 11 12 123 162028 12 123 15 567 162028 15 567 15 567 Thanks ...Show All

• David Tyler Hunt Modify SSIS package saved on server

  I have saved an SSIS pacakage on my sql server. I am able to see and run the package through Integrations services. My question is, is there a way to edit the package through Management studio Thanks Jim sorry, no. Currently you cannot load a package from Mgt studio for editing. From Mgt studio you can see whats running, whats stored, and can execute a package but not edit. I really miss good ole DTS packages. Th ...Show All

• gudia Export to Excel failed with ReportItems and sub report

  Hi, I have two RDL files, one is main.rdl, the other one is sub.rdl. In the body of main.rdl, I threw in a subreport that links to sub.rdl. Follow by the subreport is a table, in which has a textbox called mytitle. In the page footer, I added one text box that references to mytitle by using ReportItems!mytitle.Value. When this report rendered in HTML or PDF format, it worked fine. However, when exporting to excel format, it failed. I fi ...Show All

• dinsdale Generating XML data based on the Schema

  Hi, i have the following requirement Can a stored procedure in SQL Server 2005 generate XML data based on the schema, We don't prefer to manually build an xml string inside the stored proc Is there any SQL Server 2005 feature to do it if possible i appreciate your help. Thanks, Vaishu Can a stored procedure in SQL Server 2005 generate XML data based on the schema Yes... Create Proc dbo.GenXMLWithSchemaValidation A ...Show All

• Shinya Watanabe Date Dillema!

  Hi There, I've recently come across a problem with a query I'm trying to get results out of. Here's the situation: I have a table called 'ProductsChild', which just stores information about Books such as: ReleaseDate, ISBN Number, etc. I need to know if a specific book is a 'New Release'. A new release is a book that has not been published yet (Release Date) and is still a new release after 1 month of it being published already. I used this quer ...Show All

• nicbkw Exporting a RS 2005 report into a PDF file?

  Hello! I was able to export a report in RS 2005 into a .PDF file but since it is a wide report some of it got cut off in a PDF file. Is there a way to display the whole width of my report in PDF without cutting this off Thanks, You can set the page size in Report->Properties->Layout. For landscape you would just swap the width and height of the papersize. For example, Letter is Width: 8.5in Height: 11in. To make this ...Show All

• Gleedo Persistence Of Temporary Tables

  Is it possible to create a temporary table in a 'parent' stored procedure and then access it from a 'child' or nested stored procedure Bearing in mind that the child proc will definitely be called by the parent proc. Look at the article from Erland: http://www.sommarskog.se/share_data.html HTH, jens Suessmeyer. ...Show All