Answer Questions

• My-Spot Newbie report problem

  Hi, I've created a report which contains a Datetime field. When this is displayed on the report, there is a problem because if it is empty, I want to display "null". So in the expression for the value, I have: =iif(fields!TimeEntered.Value = "" , "null" , fields!TimeEntered.Value) This shows #error if the time is filled. I have also tried putting .ToString() on the end of .Value="", but no luck. Can anybody help please Thanks =IIF(Fields!TimeEntered.Value IS Nothing , "NULL" ,Fields!TimeEntered.Value) Thats great, thanks! ...Show All

• unish.patel Login failed for user ''. Reason: Not associated with a trusted SQL Server connection.

  Hello, I have some problem here. I have a sql server installed on one machine and I have another development machine for my asp application. How could I actually access the asp application and sql server at the same time from another machine within the network. I kept on getting the error message above. Thank you for your help :) Hi, I have a question here. Does sql server mixed mode actually support both the login wither by Window authentication or sql authentication If it is the case then why actually the other machine fails to connect Thank you for your reply. :) Hello oj, Thank you for your help. I still have some doubt over here. I can access sql server succ ...Show All

• S_Parikh Getting Version of Database without convertign to SQL Server 2005

  Is there any way to get the version of a database without attaching it to the server. Or can I attach a database without converting from SQL Server 2000 to SQL Server 2005. The reason is that I have to ask the user before a convert the database from SQL Server 2000 to 2005. Hi, actually I don’t know of any function for that. Never heard. Never seen. Never read. :-) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- I have attached SQL 2000 databses to SQL 2005 without any converting. They work fine. Now if you have maintenance plans or DTS packages this requires conversion. There may be stored procs that may have issues with 2005 so you need to tes ...Show All

• Dan Puiu Session State Management

  Hi to all, if Storing my Session values in Sql Server. i want to know how the request will get the corresponding value from Server and how the response will write the value to the server. how its working. With Regards Amjath hi i want to do avoid multi login. so i store the session in sqlserver and for every login i check the particular user already logged in or not. after expire time, the job for delete get fired. so in that time i want to delete the corresponding details for that session id in my table also, how can i achieve that. i think i may edit that sp for Deleting in aspstate. is it possible. With regards Amjath. Are you talking ...Show All

• pershing 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

• Shrek.NET How to solve this sudden repl problem?

  Hi, We're running a replicationprocess for months now, and 2 days ago it broke down, for no appearant reason I can detect. The setup is this: A SQL2K server has a publication defined on a database, consisting of several dozen tables. It is a transactional publication, running continuously. There is 1 subscriber, a SQL2005. Both servers run with Win2003 and all have the latest servicepacks. Up until 2 days ago there was hardly a problem. Then I received errormessages on being unable to load into a specific table. That table had been changed on that day, namely, 1 column was changed from CHAR(13) to CHAR(12). I do not know if this has any relation with the problem we experience. Currently the databases are structural the same. I could not ge ...Show All

• Gert Christiansen negative values on a measure

  have a measure called total sales amount in a FACT table some values are reported back as a negative number. anyone know the issue Not really sure. I did a test going from -- From -- data warehouse field as a BigInt data source view had xs:long cube strructure for the measure as Int -- and got the same overflowing results, I then changed the cube structure to BigInt and go the correct results. I have just tried to reproduce your error message without any luck. If I put a value that is larger than the maximum that an int can hold I get overflow errors, but I have been unable to trigger a data type not matching error. At this point I can only think of a couple of thing ...Show All

• ReiXou Accessing URL

  Hi! I have two assets: a URL that points to an XML file, and a stored procedure that can accept this file as a text variable and store it in a SQL 2005 table. create procedure [dbo] . [insertObjects] @availabilityXml text as DECLARE @xmlHndAdd INT EXEC sp_xml_prepareDocument @xmlHndAdd OUTPUT , @availabilityXml TRUNCATE TABLE Objects INSERT Objects SELECT * FROM OPENXML ( @xmlHndAdd , '//NewDataSet/Table1' , 2 ) WITH Objects Now, I need to find a solution to combine the URL with the proc. Does anyone have any suggestions on how I can pass my URL as a text variable to the procedure SSIS, vb-script, etc. are welcome! Thank you! Thanks for the reply! I used the a approach, a ...Show All

• mapvman Run RS Script file from SSIS package

  Hi! I have a Reporting Services script file used to publish my reports. Is there anyway I can run it from a SSIS package Thank you! Run rs.exe from an execute process task. ...Show All

• ExtinctPencil Setting column value in script task

  This should be simple. I have a package which reads a flat file into a data flow. One of the columns (RefNumber) needs to be parsed and split into 2 distinct values. So in the dataflow I add the 2 new columns (ID1 & ID2) in a derived column transformation, and then call a script task. In the script task, RefNumber is readonly, ID1 & ID2 are readwrite. Here's a cut-down version of the script task with the boring stuff removed; Public Overrides Sub Parser_ProcessInputRow(ByVal Row As ParserBuffer) Dim narrative As String = Row.RefNumber.Trim() If (String.IsNullOrEmpty(narrative)) Then Return End If 'lots of stuff happening here not relevant to the question so snipped If ((IsNumeric(narrative)) And (narrati ...Show All

• jzfredricks Insert and Update at the same time

  Question1 How can i Insert into 2 table and update the table at same time Example TableA ##TMP INSERT INTO ##TMP Select * FROM TABLE TABLE A WHERE XXXXX =XXXXX UPDATE Indicator field in the Table A when there is a record insert into ##TMP Question 2 How can i Insert the data into 2 table at the same time INSERT INTO TABLE A,TABLE B SELECT * FROM TABLEC WHERE xxxx= 'xxxx' Please advice , is there any other short cut to do this Also, if you want to insert into two tables you can do something like this: insert into tableA output INSERTED.* -- or whatever into tableB select relevantValues from tableC Dave ...Show All

• J Tatta How to determine the number of cluster for the my clustering models?

  Hi, all here, Thank you very much for your kind attention. Is there any good way to determine the number of clusters for the clustering models Really looking forward to hearing from you for your guidance. Thanks a lot. With best regards, Yours sincerely, If you set the CLUSTER_COUNT parameter to 0, then the algorithm will try to determine automatically the number of clusters. Also, you could try to set CLUSTER_COUNT to a large value (say, 30). The algorithm will start looking for 30 clusters, then merge those that are really close, so the result will be less or equal to 30, and will give you an idea of how many actual clusters seem to exist in your data. You can also use the MINIMUM_SUPPORT parameter to add ...Show All

• Apathy Reports to csv

  I have a requirement for converting the reports created using SSRS to csv files instead of Excel. The user sholud not get the option of exporting the report to Excel, instead it should be csv. Is it possible There are 2 ways you could do this. First is to get rid of (rename) the rendering DLL file. Go to this directory on your reporting server: {Drive} :\Program Files\Microsoft SQL Server\MSSQL. {InstanceID_of_RS} \Reporting Services\ReportServer\bin\ Rename this file: ' Microsoft.ReportingServices.ExcelRendering.dll ' to ' Microsoft.ReportingServices.ExcelRendering.dllbak ' Another way is to take out the option from your rsreportserver.config file. Go to this directory on your repo ...Show All

• Roman Nurik coosing more than 1 value in QUERY PARAMETERS Dialogue Box

  You know how there is a Query Parameter Dialogue Box in the Data Tab in Reporting services. In other words, if you have a query with a parameter and want to run your query, this dialogue box appears and wants you to enter the value for the parameter. How can I choose more than 1 parameter in Query parameter dialogue box. I mean, I have a SalesPerson parameter in my query, and whenever I enter John as the value for SalesPerson Parameter I am OK. Whenever I enter Bob as the value I am OK too. How can I see the results for both John and Bob John, Bob seems not to work IN (John, Bob) Seems not to work either. What is the correct syntax. Pleaseee.(I'm going crazy) Thank you T ...Show All

• GeminiSaka Latest value for all members at a given point in time

  We have a fact table with a current balance record. For this balance rows are added to the table only when the balance has changed. This way we can reduce the volume in the fact table by not saving redundant information for every point in time that we want to analyze. In SQL it is a simple task to get a view of the lastest fact records for a given point in time. SELECT f1.* FROM factTable f1 WHERE f1.timestamp = (SELECT MAX(f2.timestamp) FROM factTable f2 WHERE f2.timestamp <= givenPointInTime AND f2.balanceKey = f1.balanceKey). In other words, the given point in time directly determines which rows should be fetched from our fact table, one row for each balance record (balanceKey). This row will of course include several dimension at ...Show All