Answer Questions

• cplusplus1 How to pass table name as parameter to reporting service 2005

  Hello to everyone, Right now i am working on a reporting project. I am using SQL server 2005 Reporting services for this project. In my project I want to pass table name as a parameter to report. I tried but i cant get result. In other words, i want to generate a dynamic query in which i want to pass table name as parameter. This table name and other parameters are passed to report from .aspx page. I use @financialyear as my table name parameter in sql query of report, but it give me error that " @financialyear variable must be declared ." If anybody know answer pls reply me fast my deadline for project is near... Thx, for ur reply. When i will use expression in query, it will no ...Show All

• Arun C The product level is insufficient for component...

  Hi. I'm using SQL Server 2005 Management Studio to try and run an SSIS package. One step blows up with this error: "The product level is insufficient for component "data conversion 1"". I checked out the thread here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=112469&SiteID=1&PageID=0 However, after installing SP1, the program is still giving me the error. I'm running the package from my WinXP Pro SP2 workstation. What am I missing Thanks. I'm part of the development team and our server group installed the database. Would we need to request the database installation CD for the SSIS The database version is 9.00.2047.00 SP1 Enterprise Edition. Thank you. ...Show All

• Mathieu Cupryk SQL Server 2005 Everywhere Edition: Replication with MS Access?

  Hello @all, does anyone know whether a SQL Server 2005 Everywhere database can be replicated with a common MS Access database Is there any possibility to synch a database on a mobile device (SQL Everywhere) with a central database on a server computer (like MS Access or SQL Express) without having to use a full version of SQL Server Replication is just needed for merging a small database (4-5 tables) so I think the full version of SQL Server is a little bit oversized for this issue (and too expensive, too). Thank you very much in advance, Tim Hi Tim, Answering your questions below. If you have any more questions i will be glad to answer. "Do I understand correctly that no conflict res ...Show All

• voila jacques advice/suggestions PIVOT

  Hi all, Please look at the attached - I think it works, but I'm looking for some comments/advice. Included is table creation, samepl data and the t-sql statement. [code] SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[DBO].[ProductPriceComparison]') AND type in (N'U')) DROP TABLE [DBO].[ProductPriceComparison] CREATE TABLE [DBO].[ProductPriceComparison]( [CatalogueItemID] [nchar](8) NOT NULL, [RetailerName] [nvarchar](100) NOT NULL, [RetailerPrice] [money] NOT NULL, [RetailerPriceCheckDate] [datetime] NOT NULL, CONSTRAINT [PK_ProductPriceComparison] PRIMARY KEY CLUSTERED ( [CatalogueItemID] ASC, [RetailerName] ASC, [Retai ...Show All

• can_thing_beat_hulk How to get nextcounter for each row via a stored procedure and use it in insert into clause for each row

  Insert into TestJobTable (BookNumber,BookCode,IsActive,SourceId,ContactNumber) select [exec getnextBooknumber 'Book'],BookCode,'1', @SourceId ,[exec getnextBooknumber 'contact'] from TestBookTableTemp where SourceId = @SourceId and BookCode not in ( select BookCode from TestBookTable where SourceId = @SourceId ) Here i have to select records from the temprory table and insert it into actual table. During insertion I have to execute stored procedure for two columns and get counter for that coumlumn for each row. What can i do Can any body please give me a solution of my problem even by using cursor Thanks ManiD Its look like a simple and common solution. Please guide me how can i change my Stored procedure to u ...Show All

• Colin Bowern Cannot install RS on a SQLserver 2005 SP1 installation

  The situation is as follow: Sqlserver 2005 installed, reporting services NOT installed SP1 installed Trying to add Reporting Services results in an eror messages about incompliant versions. Nothing happens Is there anybody who has a clue So I am still stuck at the beginning. on the server the installation refuse to install extra components. I hope that there is a better solution than completely deinstall SQlserver2005 and do a complete reinstall since this is a production server and I want to avoid the risk from a deinstall No. You cannot add instance-awared components when SP1 is applied. But you can do as follows, 1. Install RS RTM 2. Apply SP ...Show All

• Samoyed Partition Slice Property

  I'm having trouble processing a partition that has a slice property selected. My data is partitioned on a montly basis, hence the slice is along the lines of [Date].[Date Hierarchy].[Month].&[200607]. When I do process index or process full, it fails. Iget the following error: Error: The script threw an exception: Errors in the OLAP storage engine: The slice specified for the Half Year attribute is incorrect. Errors in the OLAP storage engine: An error occurred while processing the indexes for the Viewers 200607 partition of the Viewers measure group of the Viewing cube from the BDW database. I didn't type the mdx myself, just click and drag from metadata pane. Anyone know why this might be happening Thank. Rahil ...Show All

• Johnny2006 Problem with a view (not a simple one)

  Hi, I have a table that is something like this: Products ----------------- idProduct as int, idPart1 as int, idPart2 as int, idPart3 as int then other table, which is something like: Parts: ---------------------- idPart as int, partName as VarChar(30) Now, some products only take one part, but others will take as many as 3 parts. Since it's a relatively small number I thought it would be better to put 3 different idParts on the product table and have two of them allow nulls, instead of creating a Master / Detail kind of thing. My question is, how do I create a view with something like: v_Products ----------------- idProduct as int, namePart1 as VarChar(30), ...Show All

• Thunder2002 Formatting numbers question

  I have a datagrid with currency amounts, the default currency format "C" shows only two decimal places, I would like to show up to 4 decimal places. Useing the formula/expression editor, how would this be done Have you tried C4 Currency with 4 numbers of precision. Just an thought, I do not know if it will work or not. I do this in the expression. =Format(Fields!ThisValue.Value, "$#.####) Hope this helps. Both of the above are possible options. rs12345 - put "c4" into the Format property of the textbox guyinkalamazoo2 - apply the formatting directly tot he value in the expression of the textbox ...Show All

• Peter D.252325 Foreign Key Constraint enforcement question

  If I have an composite Foriegn key on a table, say like this: CREATE TABLE FKTable ( ID INT NOT NULL, ID2 INT NOT NULL, PRIMARY KEY (ID,ID2)) CREATE TABLE OtherTable ( OID INT NOT NULL, ID INT, ID2 INT, PRIMARY KEY (OID), FOREIGN KEY (ID, ID2) REFERENCES FKTable (ID, DI2)) ) Other than the fact that the above probably isn't correct SQL Syntax but you get the idea of the structure. Am I wong in believing that an INSERT into OtherTable should fail the Foreign Key Constraint test, if either ID or ID2 is null when being inserted into OtherTable ie INSERT INTO OtherTable (OID, ID, ID2) VALUES (1, 123, NULL) or INSERT INTO OtherTable (OID, ID, ID2) VALUES (1, NULL, 123) Your assumption that the insert stateme ...Show All

• nayob insufficent system memory

  Running a large transaction that runs successfully in SQL 2000 in a couple of minutes but running on another system with SQL 2005 after 4 hours it failed with error “ there is insufficient system memory to run this query” Both systems are running a GIG of memory with 1 instance each and nothing else running. 1 Gig of memory for SQL 2005 seems to be way underpowered as crazy at that might seem. Is the only answer to add more memory or are there settings I can adjust to avoid SQL 2005 from being such a hog Thank you in advanced, Pauly C Can you please share out the errorlog after such a failure (The errorlog resides in the "LOG" folder) Thanks, Ron D. Did you update statistics Did you look at th ...Show All

• Viren Kapadia cannot connect to integration services

  When i try to connect to SQL 2005 integration services from object explorer i get connected (in the sense it shows in object explorer running packages stored packages ..)but when i try to exand any of these objects i get the following error -------------------------------------------------------------------------------------------------- Failed to retrieve data for this request(Microsoft.sqlserver.smoEnum) Additional information The sql server specified in SSIS service configuration is not present or not available.This might occur when there is no default instance of Sql server on the computer. For more information see "config integeration services" in server 2005 books online. Login time out expired An error ha ...Show All

• deekatz Problem in changing Account Name, Password

  Hi I installed SQL Server 2005 Express Edition. When I try changing the account name, password in the SQL Server Configuration Manager, i.e. by clicking on Apply, the SQLEXPRESS restarts and the password gets replaced by a longer password. Also the user name gets prefixed with "./". Any help on this will be highly appreciated. Another query: Do we have the query analyser (gui or command line) kind of thing in Express Edition Also where can I get a proper documentation of doing elementary things in setting up a database, like creating a database, adding a user, etc) Thanks and Regards Roopesh A few additional notes, if you've only downloaded Express Edition (not Advanced Services) you can get Management Studio Express separately fr ...Show All

• Escape SSIS Job Does Not Run

  Hello, I have recently installed sql server on a second machine to perform SSIS extractions. The job I created does not run from sql server agent while I'm vpn'ed into the client site (the packages fail). If I run the packages from Integration Services the packages execute fine. I am sure all my SQL server configurations are properly set, since the are identical to the settings on my primary machine (where the jobs execute fine). Any Ideas Thanks in advance for any suggestions. Please search the forums... Ensure that the user account running the SQL Server service has permissions to all data sources. ...Show All

• Thulasi command line parameters are invalid

  I have a package that let me to import data from a excel book to a Sql server data base. When I try to run this package like a step into a SQL server Job it show me the next error. "The command line parameters are invalid. The step failed." the "command line" looks like this /FILE "C:\Project\Package.dtsx" /CONNECTION ConexionExcel;"Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source=;Extended Properties =""EXCEL 8.0;HDR=YES"";" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI and in my excel conexion is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties="EXCEL 8.0;HDR=YES"; When i run the "Command Line" in the "Com ...Show All