Answer Questions

• Jneve7 Forien Key back to Same Table, fails.

  USE [db] GO /****** Object: Table [dbo].[TABLE] Script Date: 06/27/2006 09:30:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo] . [TABLE] ( [INDEXID] [int] IDENTITY ( 1 , 1 ) NOT NULL, [OWNERINDEXID] [int] NULL, [CAPTION] [varchar] ( 254 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_TABLE] PRIMARY KEY CLUSTERED ( [INDEXID] ASC ) WITH ( PAD_INDEX = OFF , IGNORE_DUP_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE TABLE   ADD CONSTRAINT FK_TABLE_TABLE FOREIGN KEY (OWNERINDEXID) REFERENCES TABLE(INDEXID) GO ...Show All

• R.S.N IIF gives error, but shouldn't

  This one's driving me nuts. I'm trying to show a "variance from revenue budget" column in an otherwise functioning report. The basic formula is: (((Fields!budget.value-Fields!actual.value)/Fields!budget.value)*-1) which displays as: Agent Variance Budget Sales John 20% $80 $106 Mary #Error $0 $50 I want Mary to display 0%, but division by 0 gives an error. Fair enough. Let's test for a 0 value: IIF(Fields!budget.value = 0,0,5) Agent Variance Budget Sales John 5% $80 $106 Mary 0% $0 $50 Okay, the test works. So this should work, right: IIF(Fields!budget.value = 0,0,(((Fields!budget.value-Fields!actual.va ...Show All

• Jarodtweiss FTP from a mainframe (z/os)

  Being that this issue first surfaced September 2005 and it's now six months later (March 29, 2006), has the problem with recognizing VMS datasets (not requiring a '/') been addressed Now that it's almost a year later......has this problem been addressed Or has anyone figured a way around this (within SSIS - not using cmd files) One solution is to use IIS and go VMS -> IIS. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=317604&SiteID=1 ...Show All

• Abdel1 Performance problem: SSAS 2005 + ProClarity

  Hi, I am facing a performance problem. Here is my scenario: I am using ProClarity to create reports/graphs by connecting to ssas 2005. These are not dynamic graphs but are created beforehand in proclarity and accessed by users. The graphs enable drill-down/drill-up features. My Cube contains: 1 MeasureGroup 4 Measures 7 calculated measures 4 dimensions ( 1 time dimension: date) dimension partition count: 1,095 4,018 8 453 4,018 (hierarchy) 11 (hierarchy) 7 (hierarchy) 5 hierarchies in time dimension 1 hierarchy in other dimension 1 partition, partition count: 33,574 (current) partition size : 708.4 kb storage: MOLAP Partition aggregations: 15 current performance gain: 51% This cube is processed manually and appx of ...Show All

• voltagefreak Delete rows

  Hi I am trying to delete rows in temp1 which are exist in temp2 delete from dbo . temp1 as a inner join temp2 as b on a . regionname = b . regionname and a . servicecode = b . servicecode and a . directioncode = b . directioncode and a . destorigflag = b . destorigflag I am getting error : Incorrect syntax near the keyword 'as'. thanks in advance subash delete from dbo.temp1 FROM dbo . temp1 as a inner join temp2 as b on a . regionname = b . regionname and a . servicecode = b . servicecode and a . directioncode = b . directioncode and a . destorigflag = b . destorigflag ...Show All

• Ondra Br. Return all fields of database

  Hello, Is it possible to return all the field names of a database. I do not want the data rows. Just a list of fields in the databse. Thanks ... just run this - don't change the SQL   USE HOUAPPS237.CallsAndIncidents.dbo.PROBSUMMARYM1 select table_name , column_name , ordinal_position , data_type from information_schema.columns   and see what you get   or even USE PROBSUMMARYM1 select table_name , column_name , ordinal_position , data_type from information_schema.columns   THANKS WILL, WORKED GREAT Only change I had to do was from USE HOUAPPS237.CallsAndIncidents.dbo.PROBSUMMARYM1 select table_name ...Show All

• Aelx DTS to VB

  Can someone help me please. I am having issues with the following code. This is the first time I am doing this, so it is Brand new to me. Sorry if I look and sound like an idiot. I am having issues with 'DTS.OleDBProperties' cannot be indexed because it has no default property at the following line :oConnection.ConnectionProperties I used DTS wizard to create my vb code and I am following this page: http://msdn2.microsoft.com/en-us/library/aa176248(SQL.80).aspx Can someone please guide me in the right direction. Option Explicit Public goPackageOld As New DTS.Package Public goPackage As DTS.Package2 Private Sub Main() set goPackage = goPackageOld goPackage.Name = "Test" goPackage.Description = "Casier" ...Show All

• hrubesh Report SnapShot Creation Programmatically through Java

  Hi, I am facing some issues while creating report snapshots programmatically using axis (Java platform for creating and deploying web services applications). To create a report snapshot what should be the methods called I tried using UpdateReportExecutionSnapshot() but didn't find any parameters to set the schedule information which would say when the execute the report snapshot. Can you please guide me for this Also I had one more doubt regarding report snapshots. If a parameterized report is configured as snapshot then we would require to set default parameters for the report. Is there a way to create snapshots of the same report with different parameters eg : The employee information report displays the information base ...Show All

• Yustme export the query result to html

  I am using the query window n SQL server 2005 express to execute some sql statement but i want to export the resut to html.. is that possible within the sql statement Could you try to export your query result as XML and then create style sheet to transform it to browser Just a thought. I didn't try this, but you can try if you like. No; you'll have to use a client of some kind (ASP.NET, perhaps) to do that.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     <Jassim Rahma@discussions.microsoft.com > wrote in message news:8bd587be-fcd2-4012-9b48-f535f5487fd7@discussions. ...Show All

• Sweed Package randomly stops

  I have a very weird issue in my latest package. I run it and it just randomly stops. When I watch it in debug mode or not in debugging a command prompt window will flash for an instant (too fast to read) and then the package will stop. It stops inside of a for each loop and the "on completion" is never fired for the loop. I never receive any errors - its just like someone hit the stop button. Sometimes it will process hundreds of files before stopping, other times only a few. (And its not stopping on the same file each time.. it doesn't appear to be related to the file at all) Any ideas what could be going on How to troubleshoot Please contact product support services - they'll be able to a ...Show All

• InHowes Package execution fails in Windows service but runs fine as a Windows application.

  I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service. The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task. Again, the app will run all packages just fine. The data is imported and t ...Show All

• Uwe Keim using multiple values in IN CLAUSE

  how can i use multiple values in IN CLAUSE in a SQL query, that too when the number of values are changing at runtime. complete SQL code required............... I have following picture in mind but the values(in IN clause) are changing at Runtime DECLARE @groups TABLE (group_id int) SELECT * FROM abc WHERE abc_id IN (SELECT group_id FROM @groups) What you have looks good. What you are missing is how to populate the values in the @groups table variable. To help with that I need to understand the background. Are you running this in a stored procedure Are the groups passed in as a parameter(s) If so what format Ah, dynamic search. You'd want to start here: http://www.sommarskog.se/ ...Show All

• AndyPham How to restore a Sql Server 2005 database backup to Sql Server 2000

  Hi All This is a very urgent requirement of my client having 200 stores and one Head office. the HO has just installed SQL-Server 2005, The HO sends small backups of the data related to stock transfer which needs to be restored at stores. It was working find when both the HO and stores were SQL-Server 2000. but the process has come to a dead halt as the HO has SQL-Server 2005. It is not possible to convert the stores immediately. please help me out. Thanks Raoshan I have learned this the hard way - you cannot restore a SQL Server 2005 backup to SQL Server 2000 due to some changes in the metadata. Even an attach/detach from SQL Server 2005 to SQL Server 2000 won't work. Try out Jens K. Suessmeyer advice, script out the ...Show All

• hunb export the query result to html

  I am using the query window n SQL server 2005 express to execute some sql statement but i want to export the resut to html.. is that possible within the sql statement No; you'll have to use a client of some kind (ASP.NET, perhaps) to do that.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     <Jassim Rahma@discussions.microsoft.com > wrote in message news:8bd587be-fcd2-4012-9b48-f535f5487fd7@discussions.microsoft.com ... I am using the query window n SQL server 2005 express to execute some sql statement but i want to export the resut to html.. is that possible within the sql statement ...Show All

• frank chen Export to PDF

  I have a wide report and i want to export it to PDF in lanscape mode. How can i do that Setting page layout in ReportViewer control has no effect on generated PDF document - it is always in portrait mode. Check out Brian Welcker's blog entry on the topic: http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx Thanks, Donovan. ...Show All