Label in parameter

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - XQUERY / XPATH versus nodes containing ":"-character Hi, all. I'm having problems using XPATH / XQUERY versus input containing ":" in the node names. Example: Code Snippet <MyData:Output xmlns:MyData=" www.myprovider .com"> <MyData:Provider> <MyData:Property MyData:Name="FirstName">Joe</MyData:Property> </MyData:Provider> </MyData:Output> T-SQL (breaks): Code Snippet SELECT XMLContents.query('/MyData:Output/MyData:Provider') FROM dbo.Some_Table __________________________________________________________ XQuery [dbo.Some_Table.XMLContents.query()]: The name "MyData" does not denote a namespace. However, if I remove all the "MyData:" references from code and data, it works fine. I don't have an option of getting the incoming data changed; is there a way to escape the character to get this code to work Tag: Label in parameter
  - 2
    - SQL Server vs. XML Configurations I have 2 connections in the package. One is development.sa and the other is development.ssisconfigurations.sa. I have the configuration set to define the development.sa properties, which I want to use for a number of the packages i create. My guess is that I am just missing something obvious, but it does not seem like I am. Sam Tag: Label in parameter
  - 3
    - converting to numeric (6,3) Hey guys, I am trying to achive the following: Truncate the values 1680.390000000000000000 to numeric (6,3) All works ok until i hit a value over 1000, (as above) The code i was using is: cos1 = 1680.390000000000000000000 CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3)) I have tried a few others, but nothing seems to work.. I get the following error. "Arithmatic Overflow" Has anyone got any suggestions Thanks guys, Scotty Tag: Label in parameter
  - 4
    - Datasource Views and Teradata I'm trying to to use SSAS 05 w/ our Teradata warehouse (VERSION 05.01.02.70 RELEASE V2R.05.01.02.40) and I'm having a problem creating datasource views. My issue is that the wizard returns every view and table in the warehouse (tens of thousands) which takes over 10 minutes . I can't seem to limit it to only the database I'm intersted in using. I've tried using the restrict schema option but then no objects are returned. Any ideas on how to do this Can you create the datasource views without the wizard Thanks. Tag: Label in parameter
  - 5
    - Understanding code created by SSIS import/export Wizard I can't seem to find these options in any of the designer areas otherwise I would have done that. I assume the logic is in the transfer tasks or somewhere in the foreach loop but there aren't setting for these specific options. I can't tell where it's getting its list of tables to transfer for the export/import either.From what I can tell the settings for deleting or appending rows during the import and allowing identity insert are stored somewhere else. Tag: Label in parameter
  - 6
    - SQL Server 2005 Service Pack 2 - RTM - WHEN??? Hi, Does anybody know how many CTPs will be provided before the RTM will be delivered Thanks Tag: Label in parameter
  - 7
    - Parameterized Queries Just getting started using SSce and having a few problems What I want to do is something like this... Dim Code As Integer Dim Description As String = txtDescription.Text.Trim Dim conn As SqlCeConnection = ConnectToLocalDatabase() Dim ssql As New System.Text.StringBuilder ssql.AppendLine( "INSERT INTO T_Titles (Description)" ) ssql.AppendLine( "VALUES(@Description)" ) ssql.AppendLine( "SELECT @Code = @@IDENTITY" ) Dim cmd As New SqlCeCommand(ssql.ToString, conn) Dim sqlCode As New SqlCeParameter( "@Code" , 0) sqlCode.Direction = ParameterDirection.InputOutput cmd.Parameters.Add(sqlCode) cmd.Parameters.Add( New SqlCeParameter( "@Description" , Description)) cmd.ExecuteNonQuery() Code = CInt (sqlCode.Value) ********************************************************************** The above code doesnt work. Firstly I am not sure if I can execute the two statements in one go. Secondly, I am not sure if output parameters are supported. I have been working with SQL Server since 6.5 but have always used sprocs and am feeling a little lost here without them. Any help getting started would be greatly appreciated. Thanks Tag: Label in parameter
  - 8
    - Users and Roles script In 2005, is there a way to automate this I'd like to be able to do this automatically periodically: 1) Script out the development users and their roles in my development database 2) Backup the production database and restore the it to the development database 3) Re-synch the existing users (sp_change_users_login), drop any obsolete users (sp_dropuser), and add any development users with roles back on Does anyone have a script that can help me achieve this Tag: Label in parameter
  - 9
    - how to extract this text? I have options_field contains a lot of data.. here are examples: DT·NB·NM·ANI=80088080 39139662 ANI=80088080 36637576 ·DNIS=80088080·DT·NB·NM·UNIT ANI=80088080 39188390 ·ANI=8008808017403125·DNIS=80088080·DT·NB·NM·UNIT ANI=80088080 39653135 ·ALIAS·DNIS=80088080·DT·NB·NM·UNIT ALIAS·ANI=80088080 39169467 ·ANI=8008808017326875·UNIT·NM·NB·DT·DNIS=80088080 DT·NB·NM·DNIS=80088080·ANI=80088080 36331200 ·ANI=80088080 39318646 I want to extract every 39 and 36 mobile numbers in the ANI. All numbers are 8digits as highlighted ad some records will have more than mobile number while some won't have any mobile number listed. so the result should be 39139662 36637576 39188390 39653135 39169467 36331200 - 39318646 Tag: Label in parameter
  - 10
    - Differences in varchar size usage, declaring the maximum available of 8000 characters Cool work there, I got you. For the table, I think it's pretty straightforward where it is only storing the exact string (length) with some overhead. So for variable/parameter in memory, the memory space is actually a dynamic one (where it can grow or something else), but SQL Server is smart enough to allocate a size that should optimize the situation. I guess my understanding should be correct, right I use both SQL Server 2000 and SQL Server 2005. Thanks, it helps. Eugene Tag: Label in parameter
  - 11
    - Daylight Saving Time DST 2007 Problems Yes. That's right. Tag: Label in parameter
  - 12
    - end conversation : security context could not be retrieved what is the event subclass Tag: Label in parameter
  - 13
    - Unicode causes Dimension build failure? Yes, I guess so. Have you tried using a Chinese collation Tag: Label in parameter
  - 14
    - Change member properties order in excel 2007 pivot table Hi everyone, i am trying to change the member properties order in a excel 2007 pivot table but it wont work... I've found how i should do it according to Microsoft Office web site ( http://office.microsoft.com/en-us/excel/HA101777521033.aspx , see : Display member properties as data in a PivotTable report ) but even if i follow the instruction by the letter it is not working... I've searched a lot but i can't find anything on this... Anybody's having the same issues or know a way around it I'm using SSAS 2005 SP2 and Excel 2007 Thank you very much! Tag: Label in parameter
  - 15
    - SQL Server 2005 Limitation: Having many attributes for Neural Network You should make the attributes you want to predict case level attributes and put all of the other attributes in a nested table which will be input only. For example "Friendly" and "Rich" will be case level attributes with values 0 or 1 and the other attributes will just be nested keys, e.g. something like this. CREATE MINING STRUCTURE DatingStructure ( [UserID] LONG KEY, Friendly LONG DISCRETE, Rich LONG DISCRETE, Attributes TABLE ( Attribute TEXT KEY ) ) ALTER MINING STRUCTURE DatingStructure ADD MINING MODEL DatingModel ( UserID, Friendly PREDICT, Rich PREDICT, Attributes (Attribute) ) USING Microsoft_Neural_Nets You will need two tables - one that has the UserId and the first two columns for each case, and the second that is a transactional table containing a column for the UserId and the Attribute name. Note that if you have the same user twice, you will need a different userid for each one to represent that user. Eg. Simon1 and Simon2 or whatever. Usually you can make a compound key by appending two columns (e.g. the name and the date). The only requirement is that the UserID in the case table and the UserID in the nested table match. Tag: Label in parameter
  - 16
    - readonly custom property I was able to do that. But that's not user friendly since it's not really readonly. Tag: Label in parameter
- Next
  - 1
    - SSIS performance Hi bkallich, The runtime has decreased a lot. The whole package is executing in 13 mins. Thanks for the help! Vipul Tag: Label in parameter
  - 2
    - - DeWayne, Sorry for the inconvenience, Restarted SQL Server (and SQL Server Agent) ,the mapi email profiles created earlier still not available. Can you please help me Tag: Label in parameter
  - 3
    - Problem in Configuring ASPState DB for .NET 2.0 Hi, In the current production environment we have web applications running in asp.net 1.1 (win 2003 server) which uses ASPState DB for the session management. We are in the process of migrating few of the web application in asp.net 2.0. We would like to use the same ASPState DB for both 1.1 and 2.0 applications for maintaining the session. Problem that we are facing: After going through couple of article for configuring the ASPState DB, We ran the InstallPersistSqlState.sql of .net 2.0 framework (log information is given below). Though the sql has updated the existing ASPState DB with the stored procedure corresponding to asp.net 2.0, still we get the following error Exception: System.Web.HttpException Message: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above. For certain reasons, we are not able to use aspnetreg_sql.exe for setting up the ASPState database. Is there something that I am missing when I run InstallPersistSqlState.sql alone. Appreciate your help. Thanks, Siva PS: We ran the InstallPersistSqlState.sql in the local sqlserver2000 (residing in winxp) and it works fine. Result Log: Run 'aspnet_regsql.exe - ' for details. -------------------------------------------------- --------------------------------------------------- Completed execution of UninstallPersistSqlState.SQL --------------------------------------------------- ------------------------------------------------ Starting execution of InstallPersistSqlState.SQL ------------------------------------------------ -------------------------------------------------- Note: This file is included for backward compatibility only. You should use aspnet_regsql.exe to install and uninstall SQL session state. Run 'aspnet_regsql.exe - ' for details. -------------------------------------------------- The CREATE DATABASE process is allocating 0.63 MB on disk 'ASPState'. The CREATE DATABASE process is allocating 0.49 MB on disk 'ASPState_log'. If the job does not exist, an error from msdb.dbo.sp_delete_job is expected. Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61 The specified @job_name ('ASPState_Job_DeleteExpiredSessions') does not exist. (1 row(s) affected) Type added. (1 row(s) affected) Type added. (1 row(s) affected) Type added. (1 row(s) affected) Type added. (1 row(s) affected) Type added. If the category already exists, an error from msdb.dbo.sp_add_category is expected. Server: Msg 14261, Level 16, State 1, Procedure sp_add_category, Line 32 The specified @name ('[Uncategorized (Local)]') already exists. ------------------------------------------------- Completed execution of InstallPersistSqlState.SQL ------------------------------------------------- Tag: Label in parameter
  - 4
    - Restoring Differentials from 2000 to 2005 Yes David. I did think of DTS/SSIS, however the volume of data thats going to be transferred and the speed at which it will be completed made me decide against it. I have around 2000 odd tables in my database and some of these tables have millions of records. A full restore of this db with my current hardware spec would be completed in 40 min(with differentials, this time would be cut to around 10). I am not sure, to be honest, this time can be beaten by DTS or SSIS..Please correct me as i am not an expert of SSIS and the limited experience i had with DTS made me dread this option... sk Tag: Label in parameter
  - 5
    - Drive allocation Thanks, your input has been helpful. Tag: Label in parameter
  - 6
    - summing semi-additive attribute Hi, I have a fact table with this structure: Service Job Technician Model Parts Amount SJ1 Tech1 Model1 Part1 200 SJ1 Tech1 Model1 Part2 400 SJ2 Tech2 Model2 Part1 500 SJ3 Tech3 Model3 Part1 600 SJ3 Tech3 Model3 Part2 100 I want to count the no. of Service Jobs. For this case, 3 service jobs. How can i do that cherriesh Tag: Label in parameter
  - 7
    - formating a text field using regular expression Thanks for your help, you got me to thinking and I realized I put the expression into the format field for the textbox instead of the value field. Once it was in the value field everything works fine now. thanks again. Tag: Label in parameter
  - 8
    - Help with an Outer Join Take a look at your WHERE clause: SELECT qad.NEW_USERS, qad.TRANSACTIONS, CONVERT( VARCHAR, qad.DATA_DATE, 101) DATA_DATE, qas.QA_SCORE FROM QA_SCORES qas FULL OUTER JOIN QA_DATA qad ON (qas.EMPLOYEE_ID = qad.EMPLOYEE_ID AND qas.QA_DATE >= @startDate AND qas.QA_DATE < @endDate) WHERE qad.DATA_DATE >= @startDate AND qad.DATA_DATE < @endDate ORDER BY qad.DATA_DATE This where clause will apply to all rows that are returned from the FROM clause. So you will not receive qas rows where the qad.DATA_DATE is not greater than @startDate. So any null rows would be eliminated from the set. You can put the WHERE clause stuff up in the ON clause and this won't affect how rows match in the qas set. Tag: Label in parameter
  - 9
    - SQL Express database in published web site I have been working with Visual Studio 2005 and the Personal Web Site Starter Kit. All is well and working. My problem is that after the database is updated (as in uploading photos and album creation) and the original web site is edited and republished, the web site database is overwritten and all the work is lost. What is the proceedure to either copy the web database to the development site on my computer so updates will not be lost, or a method of publishing that will not loose the up to date content on the web server I would much prefer to be able to copy the database to my development computer as adding tables to the database is something that needs to be done. Any help on this would be appreciated. Thanks Tag: Label in parameter
  - 10
    - Transfer Login: Source Server Can not be same as destination server Hi! I have two servers. Server A and Server B Both the servers are in different domains and both have different names. Server A runs a clustered sql server (sql 2005 standard sp1) Server B also runs a clustered sql server (sql 2005 enterprise sp1) Both server A and Server B has same virtual server name X. So, when I try to copy all the logins from server A to Server B using Transfer Login task in ssis, I gert the following error- "Source Server Can not be same as destination server" I am using IP addresses to connect to both the servers. How do i solve this issue now Thanks Tag: Label in parameter
  - 11
    - A Simple Problem. But.... Hi Dale, I am making a call center application in two or three agents make outbound calls to customers. If there are 100 calls to be made then each of my agent sees these 100 entries and makes multiple calls to the same customer. I want that when an agent logs in then it should some fixed number of entries(say 25) and when another agent logs in then it should see entries not fetched earlier. In this way each agent will have different number for outbound call. I am not locking the records per se. In my main table I have a primary key. When I fetch the records I make an entry in the temp table for that records. For other agent I fetch the records that are not in temp table. Tag: Label in parameter
  - 12
    - Excel 2007 AcquireConnection error I'm creating a small test package that copies a value from an Excel 2007 worksheet into a SQL 2005 database (SP2). When I do an Execute Task, I get the following error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager \\lorip\MandEScorecards\SQLQueryExample.xlsx failed with error code 0xC0202009. However, if I do a "Preview" in the Editor for this same Excel Source task that fails, the data comes up as I would expect. What am I missing Thanks in advance! Tag: Label in parameter
  - 13
    - Join and heavy tables Hi Team, I have a query about the way join works when it comes to dealing with heavily populated tables. I have two tables tableA and tableB each containing lakhs of records but one table is containing less records. The realistic count will be (TableA 100000, TableB 80000). Now when I am performing a join which table should on the left hand side and which table should be on the right hand side Which of the following query should i prefer select * from TableA join Tableb on TableA.column = TableB.column Or Select * from TableA join Tableb on TableB.column = TableA.column Or Select * from TableB join TableA on TableB.column = TableA.column Does it matter if we replace the table names in the join clause and replace it back in the on clause. How does the parser perform the join Thanks in Advance, Vihang Tag: Label in parameter
  - 14
    - Updating an ADO recordset... I'm updating an ADO recordset inside VB6... We just moved the database from SQL Server 2000 to SS2205.... The following code has worked a long-time now when it tries to update the record with SS2205 on the back-end I get a run-time error '3219' Operation is not allowed in this context... Here is the Open statement... SampleRecordset.Open "Select * from samplereleased_view", SampleConnection, adOpenDynamic, adLockOptimistic, adCmdText Here is the line it errors on... SampleRecordset.Update Any thoughts on this issue would be great! Thanks-David Tag: Label in parameter
  - 15
    - SQL 2005 - Migration from SQL2000 / LEFT OUTER JOIN HI, thanks for the tipp. So I run these statements against SQL2005: Code Snippet USE xxxx GO DBCC UPDATEUSAGE ( 0 ) GO USE xxxx GO DBCC CHECKDB WITH DATA_PURITY GO USE xxxx GO DBCC CHECKDB GO Everything fine, no error message. But the query still takes about 6 min! Thanks Sascha Tag: Label in parameter
  - 16
    - How group column to show side-by-side? This is nasty question but... How can I take the following data from a table: ID ItemNumber Type 1 9830302 CD 2 9830302 Cassette And run a select statement to get me: ID ItemNumber Type 1 9830302 CD/Cassette Thanks, Ron Tag: Label in parameter

Cissi

Hello!

Is it possible to create a row of "labels" in a multi-value parameter list

i mean something like this:

Name, Age

JJ, 12

PP, 10

Thanks

//C

Top

Re: Label in parameter

Andy Potter

Is your parameter query driven Do something like this:

SELECT Name + ', ' + Age as ParameterLabel from Table

Use the field ParameterLabel for the Label of your parameter.

Top

Re: Label in parameter

Cissi

Thanks for quick answer!

Yes it's query driven. I'll try to do as you wrote.

//C

Top