Answer Questions

• syndicate Opportunity to provide feedback on performance improvements in SQL Server...

  Please consider giving your feedback or suggestions on the top 5 OLTP and data warehouse performance improvments you would like to see in the next version of SQL Server. Use the links below to provide your comments. http://blogs.msdn.com/sqltips/archive/2006/09/20/TOP_5_OLTP_PERF_IMP_NEXT_SQL.aspx http://blogs.msdn.com/sqltips/archive/2006/09/20/TOP_5_DW_PERF_IMP_NEXT_SQL.aspx Thanks I would like to see SQL Server have something like the MINUS set-operator I have used in ORACLE. It provides a very easy way to see if anything is different between two tables. It is not necessary to specify the columns or any sort of JOIN condition -- merely SELECT * FROM A MINUS SELECT * FROM B This simple query returns all row ...Show All

• Franky Uray Anyone know a self extracting tool for a zip file?

  I have a zip file that requires a password to extract the file inside of it. Is there away to do this automatically Can't find any software that does this. Mike I've downloaded this software, how do I test this or get it to work I'm using the below as an argument in SQL 2005. 7z x C:\Documents and Settings\mroush\Desktop\Cnet Apps File\OSU20060824.zip -pmike Mike Thanks for the example. So, what would be the syntax for zipping each individual file in a directory Mike, With Winzip, use the command-line parameter 'P' followed by the password. Frank The spaces in the directory names can cause problems in a command line. ...Show All

• xlordt I thought this would be simple...

  I had originally thought a full outer join would solve this, but alas I'm a roadblock. Perhaps it's because it's a Friday! The goal is to create the most efficient query that will display results of the daily calls and sales as this: Date EmpID Calls Sales 7/1/2006 1 20 5 7/1/2006 2 25 7 7/1/2006 3 NULL 1 7/1/2006 4 10 NULL The problem is a simple full outer join ends up ignoring EmpID 3 who has no Calls in t1, but I still want that row displayed in the results. Any ideas TIA create table t1 (Date smalldatetime, EmpID int, Calls int) create table t2 (Date smalldatetime, EmpID int, Sales int) insert into t1 values ('7/1/2006', 1, 20) insert into t1 values ('7/1/2006', 2, 25) insert into t1 values ('7/1/ ...Show All

• vkan Converting milliseconds in hours

  Hi! I have the difference between two dates in milliseconds. I want to convert this difference to the format hh:mm:ss.mmm, without the date. So, if the difference is bigger then one day, I would like to show it like this, for example: 36:25:14.047 How can I do this Thank you! Thank you! AnaC: Below is another alternative. Dave declare @1stDt datetime set @1stDt = '10/15/6' --declare @2ndDt datetime set @2ndDt = '10/15/6 01:02:03.006' declare @2ndDt datetime set @2ndDt = '10/16/6 12:25:14.047' declare @diff integer set @diff = datediff (ms, @1stDt, @2ndDt) select convert (varchar (13), @diff/3600000) + ':' + + rig ...Show All

• Mitch5713 User Provisioning Tool for Vista

  Hi! I have installed SQL Server 2005 Enterprise on Windows Vista Business. Then, I have installed SP2 of SQL Server. In the "User Provisioning Tool for Vista" the "Available privileges" list is empty, but I am administrator of the machine. So, I'm unable to connect to the Database Engine via the Management Studio. What is the problem Thanks in advance. The SP2 installer when launching the "User Provisioning Tool for Vista" does launch the tool based on which feature have been installed. Since the database engine can't installed with the Enterprise edition on Vista, then there is nothing for the tool to do. Thanks, Peter Saddow Vista is an client operting system, on which SQL Server 2005 Enterpri ...Show All

• BonnieB Datasets in report header/footer - A Summary of the issue

  I know there are already a few threads on this topic but I wanted to create another one - and directly ask - how could this limitation possibly exists - and even more important - why is it still a problem in 2005 I want to summarize a few of the solutions that have been listed here and elseware online. We've tried them all and they all have some kind of problem: 1) Create hidden field(s) and then reference that field from the header: Doesn't work on any pages where the field isn't printed. Header value will be blank in this case. 2) Create hidden column(s) in the data table and reference that from the header: Works, but again, if the table is showing on every page, the value will be blank. i.e. - if you have two or more tables ...Show All

• rosakruten Dynamic data source name...

  Sorry if this is a pretty basic question.. but my team here is working on SQL Reporting app for the first time. is it possible to put the data source name/connection string in a config file (like web.config) and have the reports use that from there What is the standard way of doing this while trying to deploy the reports on different servers Thanks Hi Friend Did you able to get further information on SOAP API by calling SetDataSourceContents if yes please pass it to me It would be really nice to have this info.. I tried the solution with a report specific data source and parametrizinf the connection string. I get the follwing error 'An error occured duing report processing. Ca ...Show All

• ejstembler generate report using recordset

  I am generating crystal reports using recordset in ASP.Now i want to generate the report using reporting services 2000 with the same recordset.how can i do this.pls suggest me. Thanks Hi Teo Thanks for the information... Here my scenario is different..let me explain you.. First i am generating a recordset object with populated data and putting it into session.. then i am creating an object of crystal report and accessing its database and then its table. finally filling this table with session data table.here is the code like... Set session("oApp") = Server.CreateObject("CrystalRuntime.Application") Set session("oRpt") = session("oApp").OpenReport(path & repo ...Show All

• Ian Thomas problem with job

  hy, i have made a package that fills a sql server 2005 database. when i run it locally it runs all the way, no errors. Now that i have deployed the package en work with a job that executes it every day i get these errors. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. and component "Source - BU" (1) failed validation and returned error code 0xC020801C. the strange thing is i don't get an error on the first dft which uses the same connection. i have pressed the test connection button and it states connection succesfull. any help would be appreciated. Greetz, Jens It sounds like youre dynamical ...Show All

• Dark Pontiac Setting the Locale of Reports

  I am having a problem with date formats in reports. I have a two servers, one setup as En-US and the other En-UK in Windows. I have various reports that are rendered using the report viewer control in local mode. In my reports I have not set a language on any text boxes or on the report itself (using Default option in VS 2005). As I understand reporting services should therefore use the locale set in the browser, or else the locale of the report server. However, when viewing the reports, both servers display date time values in American mm/dd/yyyy format! I do not understand this as I am using the local machine to view the reports and the so the locale of the browser and the locale of the OS are En-US and En-UK respectively. Please could ...Show All

• mfauziii Any keyboard shortcut for "open table" in Mgt Studio?

  Folks, does anyone know if there is a keyboard shortcut to open a database table in Management Studio I refer to the equivalent to right-clicking on a table to choose "open table", in order to view/edit the data. I find no reference to an equivalent in the menu, nor even any reference to "open table" in the online help. I've dug around the web, to no avail. Surely other keyboard fans must groan at the need to touch the mouse for this frequent operation. Thanks in advance. Thanks, but that's about creating new shortcuts. I was looking for any existing ones. The previous answer about using shift-f10 will suffice. As for why one would use the "open table" option, do you r ...Show All

• Laurentiu Nicolae SOLUTION! - VB.NET 2005 Express and SQL Server 2005 - NOT saving updates to DB - SOLUTION!

  VB.NET 2005 Express and SQL Server 2005 Express - NOT saving updates to DB - SOLUTION! ----------------------------------- The following article is bogus and confusing: How to: Manage Local Data Files - Setting 'Copy to Output Directory' to 'Do not copy' http://msdn2.microsoft.com/en-us/library/ms246989.aspx You must manually copy the database file to the output directory AFTER setting 'Copy to Output Directory' to 'Do not copy'. Do not copy The file is never copied or overwritten by the project system. Because your application creates a dynamic connection string that points to the database file in the output directory, this setting only works for local database files when you manually copy the file ...Show All

• Rashar Decrement values in an aditional column

    Hi I have a table like this: CLIENT  Value a              12 b             11 c              8 d             10 e            4 I want to decrement this values in an aditional column CLIENT Value  ACUM a              12               12 b     &nb ...Show All

• losdude Does SSRS 2005 use paginging when rendering report?

  Hi, When I'm excute an SSRS report that build upon SP with output of 5000 records I get a reply by 15 seconds. When I'm execute the same report with output of 100,000 records it take 160 seconds to get the first page. Does SSRS use paging when executing a SP (presenting the first page and continue rendering the next pages on backend) Is it configurable Thanks, Assaf There is no way to configure paging on ssrs that i know of unfortunately, the users just have to wait looking at the report generation logo.... does this information help Unfortunately like we say there is no real way of handling this other than snapshot if you need but then you are not really running live data (May n ...Show All

• SGriffiths data are not allocated in the properly NDF. Why?

  Hi everyone, The followings actions works fine. But only the first NDF (PRIMERO) is growing up. I don't get the point at all, I though that SEGUNDO would store February, TERCERO March and CUARTO April to December (according RANGE LEFT) I feel that there is something very important that I did not in all of this... I'm stuck. --Definition table CREATE TABLE [dbo] . [DatosMensuales] ( [Id] [int] NOT NULL, [Concepto] [varchar] ( 50 ) COLLATE Modern_Spanish_CI_AS NULL, [FechaAlta] [datetime] NULL ) ON rangoMesFE ( FechaAlta ) CREATE PARTITION FUNCTION rangoMesFP ( datetime ) AS RANGE LEFT FOR VALUES ( '200601' , '200602' , '200603' ); CRE ...Show All