Answer Questions

• Marek Istvanek date parsing

  Hello, I have a source with two smalldatetime fields, the first field contains 8/1/2006 12:00:00 AM, and the second field contains 8/10/2006 7:57:00 PM. I would like to have the date from the first field and the time from the second field. No chance of changing the source system to do this for me. What I have so far works, except the time portion is converted to 19:57:00 instead of 7:57:00 p.m. Any Ideas My expression is below. (DT_STR,2,1252)DATEPART("month",FIELD1) + "/" + (DT_STR,2,1252)DATEPART("Day",FIELD1) + "/" + (DT_STR,4,1252)DATEPART("Year",FIELD1) + " " + (DT_STR,2,1252)DATEPART("Hour",FIELD2) + ":" + (DT_STR,2,1252)DATEPART("Mi ...Show All

• mckraut Printing and exporting in Reporting Services 2005

  I want to be able to grant the ability to print and export reports in Report Manager to individual users or a group of users. I know I can disable or enable printing and exporting for all users. What I would like to do is create user groups and place everyone who needs to ability to print or export into those groups. This isn't currently supported. Permissions for printing and exporting are contained within the "View Report" permission, and aren't separable. Anyone that can view a report can also print and export it, unless as you say you disable printing and exporting for everyone. ...Show All

• Syed Atheeque Pasha Multi-line subtotal

  Hi guys! I have a problem... I need to create matrix report with 2 total rows... It should looks like: User Name        Col1      Col2      Col3        Total   User1              2            3          2             7                         0      ...Show All

• InfoDemers PredictProbability with Association Rule model..

  I have run into a .. somewhat of a "duh" question. I'm running association rule to run a basket analysis, and I'm trying to get probability of each prediction. I know this is wrong, but how do I go about running PredictProbability on each ProductPurchase prediction When I run the below DMX query, I get this error message... Error (Data mining): the dot expression is not allowed in the context at line 5, column 25. Use sub-SELECT instead. Thanks in advance... -Young K SELECT t.[AgeGroupName] , t.[ChildrenStatusName] , (Predict([Basket Analysis AR].[Training Product], 3)) as [ProductPurchases] , (PredictProbability([Basket Analysis AR].[Training Product].[ProductName])) as [ProductPurchases] From [Basket Analysi ...Show All

• Aatif sum of a column in matrix

  hi reporters! i m using matrix in my project and i want to calculate the (cell_value/sum_of_column). for data cell values we have to use sum or another aggregate function for subtotaling, so for the cell value i m wirting sum(column) / A. how to write A that points to sum of all cells on the column. x_column y_column z_column sum(y_column)/A A Dear,  u can count the number of columns from the sys.syscolumns  table in master database and use that value in ur matrix. HTH from Sufian thanks mohs, but this is not i wanted i don't want the count the number of columns, i want the sum of the datas in a ...Show All

• Bradley Reynolds ActiveX Script Task/Function Not Found

  We have a SQL Server 2005 Cluster that we are trying to send email from to notify when certain jobs have completed, failed, etc. We are having a bit of a problem getting the email to work and I believe that the failure is at the SMTP server, not at the SQL level. That being said, I'm trying to create a simple SSIS package that I can use to test connectivity to the SMTP server with and send email. I've added an ActiveX Script Task that calls a COM object that actually sends the email. I keep getting a "Function not found." error when I try to execute the package, and I have no idea why I'm getting that. It says that the errors were found during validation. Can anyone help Function not foun ...Show All

• Keith Seifert Insert into a View (Error Msg 4405)

  I have a view of two underlying tables, each with its own "identity" primary key, that are joined as a 1 to many. The view itself excludes the foreign key and identity columns of both tables. I have tried to INSERT INTO this view, and I receive a "Msg 4405, view is not updatable because the modification affects multiple base tables." Well yes, I know it affects multiple base tables, but I figured that this is one of the reasons why "views" are used - to simplify the insertion of data into multiple base tables. What am I doing wrong More precisely, the tables look like this: TableA ---------- TableAID (bigint, PK, identity) Name (nvarchar) TableB ---------- TableBID (bigint, PK, identity) TableAID ...Show All

• arkiboys Migrating DTS packages Question: Dynamic Properties

  Hi guys, After DTS Migration is "successful", I opened up dynamic properties step but I saw codes were all commented out inside the public class ScriptMain. Since I am not familiar with Microsoft.SqlServer.Dts.Runtime , I'm not sure what methods I should use as there aren't much examples available online. How do I do the following in SISS way ' Add your code here ' Source Type = 2 ' Global variable = glvTrade ' Destination = 'Connections';'Trade';'OLEDBProperties';'Data Source';'Properties';'Value' Regards Migration Wizard Doesn't Support Dynamic Properties Task. There is another 3rd Party Migration Tool available which handles Dynamic Properties and many ...Show All

• mbeninca Calculations

  Hi, I have a cube like that: Account Dimension vs Product Dimension Sell Income | Quantity | Unit Price Computers 210 7 30 Computer A 20 2 10 Computer B 100 5 20 Sell Income = Quantity * Unit Price The cube always aggregate first and after it calculate, because of that the total get wrong, Sell Income of Computers give me $210 and the correct value is $120. I tried put that formula in the dimension custom roll up, in dimension unary operation, in a calculated member but always give me the wrong value. The only solution is create a script command in the cube calculation like this: Scope(leaves(account), leaves(product)) ...Show All

• anderskj1 What is the commad prompt option to install SQL Server Management Studio Express

  I am trying to install SQL Server 2005 using command prompt. I have gotten the latest download. My question is what is the commad prompt for the tag ADDLOCAL for SQL Server Management Studio Express. For SQL Server datatbase it is called SQL_Engine. In the same way what should I be using for "SQL Server Management Studio Express". I want to limit the choices that are installed on the user machines. Any help is greatly appreciated. Thanks, Mahesh hi Mahesh, I just played a little before answering with the setup_adv.exe SQLExpress with Advanced Services installer.. as you know, this package is th eonly one including SQL Server Management Studio Express... I first tried c:\somefo ...Show All

• looplocal SP2 Deleting Subscription Problem

  I have installed SP2 and have been testing it. I have found an issue with deleting subscriptions thru report manager. I get an error on page: Line: 1 Char: 58 Error: 'return' statement outside of function Code: 0 I can delete thru SSMS with no problem. Is anyone else have an issue with this Thanks! BobP Mike, Is there a fix out for this symptom I am running the basic SP2 (9.00.3033.00 ). This is really becoming an issue. R If this happens when you select subscriptions using the checkboxes in the List view, it's most likely an issue in SP2 CTP3 that has since been fixed. ...Show All

• Robert3234 Is it Possible When the time of Implement SSIS Package show Windows and ASk SERVER NAME ,DB NaME ,PAsword

  Hi, now i am currently using SSIS Package using BUI, The Source and Destination File we Given Manullay Connect the Server name ,And Table . Instead of given Manual . How to create Global Variable Connection Manager. Suppose Today i am Working Developement Server. Latter i will be changed Production Server Database. At That time we have to Going to Modify all the Connection .Instead of This How to Create the Connection Manager Gloabe Variable . and How to Use .Please Any one give Sample For Connection Manager variable for Different Server. Thanks & Regards, Jeyakumar.M chennai Err not sure. Here's a tip for you though. Don't store all the individual properties. The only one you need to store is Con ...Show All

• FernandoLeite Stored Procedure Update parameters question

  I just posted a question on WHERE clause impotence in SELECT command, I mean in my setting. It obviously should work on a global scale and now I have a problem with UPDATE command WHERE clause. I am talking about a different SP now. It is supposed to update a record in a table. Anyhow, the procedure did NOT seem to execute properly (did not update the record) when called from C# code but when I tried to exec it in the server it finally did work but raised a problem of safeguarding the unused parameters . I do not need to update all columns in every call to the SP that uses UPDATE statement. Some parameters are left the way they are. I found out that if I ignore them they are set to default values which is NULL for DateTime. It ess ...Show All

• xlordt Calculating number of subscriptions in time

  Hi all, I'm new to SQL AS and MDX in general but I'm trying to build the following and maybe you guys can help me. I have a snowflake database with a table containing subscription. Each subscription has a date/time at which it starts and a date/time at which it is terminated: subscription: id start_date end_date .... 100 10-jul-2005 17:00 10-aug-2005 11:00 ... 101 11-jun-2005 17:00 12-dec-2006 18:00 ... 102 1-may-2005 17:00 17-jan-2007 13:00 ... 103 10-apr-2005 17:00 10-sep-2005 15:00 ... And there is a dimension-table called datetime: id year month .... 10-jul-2005 17:00 2005 06 ... 10-jul-2005 18:00 ...Show All

• aa807 Significance of sp_getschemalock

  Hi Stumbled across sp_getschemalock when setting up a solution to use linked server and synonyms. Ran a profiler trace of what was actually transmitted over the wire to the linked server. As we're in a POC phase whith the linked server strategy I was wondering if anyone has input on the significance of the SQL Servers use of sp_getschemalock. What does it do No help from Books Online or google. I mean, a schema lock ! And there is one sp_getschemalock call for every table I touch on the linked server! Sounds heavy as the linked server is a sentral point to the whole customer operation. Am I moving into really murky waters here with lots of centrally placed locks that bog down the central server How does it play performance wise Bette ...Show All