Answer Questions

• Witold Grouping, Sums and Scope problem....

  I have a report with two groups in a table Group1 is grouped by Lot Group2 is grouped by SeuqnceNumber In the body of Group1 I am trying to do a sum of QTY using the group2 groupby. Is this poosible in SSRS It is easily done in crystal. In crystal the group1 grouping is done on LOT Group 2 is grouped by sequenceNumber the expression for a field on group1 is (Sum ({R_COA_Charact;1.Primqty}, {R_COA_Charact;1.SequenceNumber})) I have read about scoping, but can't figure out the right way to do this. Help Please try this link. odeto code.com is my favourite.   http://www.odetocode.com/Articles/Topic.aspx topic=SQL+Reporting+Services or http://www.odeto ...Show All

• Ron DeSerranno - MOBIFORM DDL Triggers

  I know that DDL_LOGIN_EVENTS is the same as CREATE LOGIN, ALTER LOGIN and DROP LOGIN combined but where is this documented I have some code here ( http://sqlservercode.blogspot.com/2006/08/ddl-trigger-events-revisited.html ) that basically shows that you can combine events But where is this info in BOL For example if I do this: create a trigger and I use DDL_VIEW_EVENTS CREATE TRIGGER ddlTestEvents ON DATABASE FOR DDL_VIEW_EVENTS AS PRINT 'You must disable Trigger "ddlTestEvents" to drop, create or alter Views!' ROLLBACK ; GO After that I would check the sys.triggers and sys.trigger_events views to see what was inserted SELECT name,te.type,te.type_desc FROM sys.triggers t JOIN sys.trigger_events te on t. obje ...Show All

• Paul Baudouin I'm having issues with nested table...

  Hey gang, I'm having some issues with nested table. This is my setup. [ProductTable] is the case table, and [CustomersTable] is a nested table. I'm trying to organize my algorithms around products. [ProductTable]<---[CustomersTable] [ProductTable] table only has product ID, and it is key. [CustomersTable] table has variety of customer attributes (productID, customerID, location, demographics...) and CustomerRevenue is predict_only. ProductName is the key for the nested table. I keep getting this error when I'm processing the mining models (Logical Regression and Neural Net). Error (Data mining): In mining model, Estimate Neural Net, the algorithm does not allow table column as predictable. Error (Data mining): E ...Show All

• Evan Mulawski Ole DB Destination - Fast Load - Permissions

  All, If I use an OLE DB Destination with Fast Load, and enable check constraints, I would expect to see this work as BCP would in this scenario on 2005. However, instead, I get the error ALTER TABLE permissions required. I understand that when using BCP, if you disable check constraints and triggers, then you need alter permissions. But, when you explicitly enable these, then you do not need this permission. I would expect the same behaviour in SSIS, but I am not seeing it. Fast Load seems to always require ALTER TABLE permissions. Can anyone confirm/deny this Thanks, dcb99 I have a table where I have a simple constraint of having the value of a column less than a certain value. I can use ...Show All

• GoDaddy June CTP - Passing NULL value to a Sub-Report Parameter

  Passing NULL value to a Sub-Report Parameter fails with this message - "A parameter or data source credential is missing a value.  Prompting for this value has been disabled.  Supply a value or enable prompting." Anyone else seen this Thanks Paas the parameter to subreport . Syntax is paramField.ReportName="Transferee"; paramField--> ParameterField Transferee--> Sub report name Total Syntax is paramField = new ParameterField(); discreteVal= new ParameterDiscreteValue(); paramField.ParameterFieldName = "@CustId"; discreteVal.Value = 2463; paramField.CurrentValues.Add(discreteVal); paramFields.Add(paramField); paramField.ReportNa ...Show All

• ihendry01 UDM and Data Mart

  I'm very new to SSAS. I'm reading the book "Delivering Business Intelligence with Microsoft SQL Server 2005". In page 53 (if you got a copy), it mentions that "UDM is a structure that sits over the top of a data mart ... one of the major advantages of a UDM, however, is that it does not require a data mart. You can also build a UDM over one or more OLTP systems." This really confuse me. It claims this is possible but I can't find any further works on this. Afterwards, data mart is created for demonstration. So, is a data mart really needed I want to skip creating data mart because I hope to keep thing simple. I don't want to use the Integrated service to ETL my OLTP database into data mart structure if it's not so impor ...Show All

• mojoshaneman Custom Code for a Parameter

  I'm using a GAC-installed assembly as part of a Reporting Services (2005) report. The code does not need any permissions beyond execution. All it does it take today's date and calculate last week's start and end date. It's all just datetime manipulations. All methods are static. In the VS2005 report designer, I can do everything fine. The code runs as expected and defaults the parameters to the right date. When I upload the rdl to the Report Server, I get the message "Error during processing of ‘Start’ report parameter. (rsReportParameterProcessingError) ". If I override the "Start" parameter, it doesn't give me that error anymore. Start should be the Sunday of the previous week. I have deployed the signed ass ...Show All

• rmillerii A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

  I get the following error when trying to view my page. Can someone please help me with this error. What does it mean and what is the solution to it Here is the complete error message. - A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) See following post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=962333&SiteID=1 HTH Ming. Please check these two posts see whether it solves your problem http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=597008&SiteID=1 http://forums.microsoft.com/MSDN/ShowPo ...Show All

• Eric Hausig get date field with the format mm-yyyy i.e. '02-2007'

  Hi guys, How should I do, in order to retrieve the date field "Table1.ValueDate" with the format mm-yyyy Cast (Table1.ValueDate Thanks in advance, Aldo. If you're actually wanting to be able to use the month of the date in your calculations (rather than just asking a formatting question), then you might want to consider one of the standard ways of truncating dates. You may have seen: dateadd(day,0,datediff(day,0,TheDateInQuestion)) --which will happily remove the time portion. Well, if you want to get the month portion, you could do: dateadd(month,0,datediff(month,0,TheDateInQuestion)) And you can then use this for all those times when you need to find some aggregate based on the month, or somethin ...Show All

• Muzzzy Issue Exporting Date format to a delimited file.

  In exporting from a OLEDB connection to a flat file. In the originating table the field for DOB is in a varchar(10) format ex. 01/17/2007. The flat file connection destination is setup as a DT_STR. When you look at the OLEDB connection table preview you see it as 01/17/2007. When it is export to the delimited <CR><LF> <|> pipe delimited the format looks like this 01/17/2007 00:00:00. The issue would be resolved with a right ragged fixed width file. But this is not the requirement for the project format fot the file. I have tried delete and recreating the connections, and even tried doing a data conversation from the OLEDB connection to a char(10). Also, thourgh the transformation services with out any luck. On the flat ...Show All

• thukralz Calling procs on other databases

  Hi. I am currently working between sql server 2000 and 2005. I have written procs in 2005 using some new native features. I wish to remain using 2000 and just call and get return values from procs on 2005 Database. Procs on 2005 DB only access tables on that DB and vice versa. Is there a way to call stored procedures across Servers Cheers, Ewen Yes. Use the four part object name: server.database.schema.object Of course, security will have to be set up properly. Look up linked servers in books online. Setting it up is not terribly hard. Then use the four part names where you put the linked server name before the database name: server.database.schema/owner.procedureName ...Show All

• Uwe82 change @@SERVERNAME 2005 - Urgent please help !!!

  Hi There I have changed the servername of a sql server 2005 instance. Using sp_dropserver and sp_addserver as per BOL. However, after changing the servername i still see that : EWX-JDGSQLSRV1\SQLServer2005SQLAgentUser$EWX-JDGSQLSRV1$MSSQLSERVER EWX-JDGSQLSRV1\SQLServer2005MSSQLUser$EWX-JDGSQLSRV1$MSSQLSERVER EWX-JDGSQLSRV1\SQLServer2005MSFTEUser$EWX-JDGSQLSRV1$MSSQLSERVER built in logins still have the old server name. My big concern is that these will no longer work Also i am changing not only servernames but doamins, i cannot find anythign on chaning domains and all that must be done. Are the built in sql server logins still ok after i change the servername Even though they do not reflect the change Wjat els ...Show All

• chicagoclone SQL Server upgrade

  Hi, I am currently running a the Free version of SQL Server - however I know that in the future I will need to upgrade to the full SQL Server 2005 Licenced verision. Is it possible to upgrade from one to the other Are there any known issues For example will it keep any current databases as they are etc... Thanks Andrew I see, you can upgrade SQL Server Express editon to any other SQL Server 2005 edition any time. There are no restrictions. I assume you are talking about SQL Server 2005. In that case you can upgrade Evaluation edition to any licensed edition but it must happend before the evaluation edition expires. Once it expires there is no direct upgrade and you have to migrate data manually. ...Show All

• airwalker2000 How to make distributed query by SQL Express

  I am going to make a distributed query, but in the query design view I cannot add the tables from another server, why Thanks, i will try. hi, AFAIK, the designers only show objects local to the connected server (and database)... but you can easely insert the required code pointing to remote linked servers... regards ...Show All

• Jonas.S Uploading Time Tracker in Static IP

  Hi all, i need to upload time tracker in a static ip which doesnt have sql server, after the installation there in static ip, i receive the following error while trying to access Named Pipes Provider, error: 40 - Could not open a connection to SQL Remote Server 2005 need help Regards, Prasenna. K ...Show All