LIKE

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Make duplicate db? I need help with this. How do you backup or restore to a different instance on a different machine I am new to SQL Server. I can from my laptop see the server and access the files and do a backup(I believe the backup ran on the server and not on mine), but how do you get the db to my instance on my laptop Thanks DavidsLearning Tag: LIKE
  - 2
    - Error on Date Data During Insert Locale ID is English (United States) Tag: LIKE
  - 3
    - Data flow based on a DSV Hi, I just tried to add a new DSV by creating it inside my Intergation Project, but it gives me the same behaviour. I can not select a DSV as a source for my connection manager. The version I use is 2005.090.2047.00. Thought that the problem might be that it was a generated version (from within AX4) or that the copy paste action was the problem, see my answer to Phil. Hope you can help. Johan Tag: LIKE
  - 4
    - expression problem count disctinct Hi, When you talk about group field, you mean in a table The thing is i don't want to display the count distinct result in a table, but in a textbox (just to show as info how many different distinct articles i have with type 0). Afterwards in my table i do want to display every distinct article with some more details. Do you see what I want to achieve Greetings Vinnie Tag: LIKE
  - 5
    - How to configure Smo.Scripter to get desired sprocs Tag: LIKE
  - 6
    - Turning off validation Thanks Darren for the reply. I'm still a little confused though. The package validates at the beginning and then each time it is run it sound like. So if I am looping through the same DF task (setting source query and destination each time), it should validate several times per execution. Is that correct The package is saying it can't find the server when it executes the second time around. Somehow it works the first time, even though it goes through the same loop the first time. This tells me, at least the second time around, that it is trying to validate the DF task while the Script that dials is still working. Otherwise it would be dialed and have the connection. My question is what does "just before it starts to execute mean". Is there a set time before the DF task starts that it starts to validate (if I'm right in that it starts to validate while the script is dialiing, not after all the tasks before it are done.) Or theoretically should validation not be done until all tasks before the DF tasks are complete. That was why I was thinking I could put an extra step with delay before the DF, since then it would be validating while this task is going on, not while it is still dialing to get a connection to the server. Thanks, Kayda Tag: LIKE
  - 7
    - Question on merging partitions Hi, all experts here, Now I am confusing about the need to merge partitions and the significant benefits of merging them. As partitioning cube obviously helps improving cube processing time and improve query performance. But then what is the reason to merge partitions back to one single partition of a cube I am looking forward to hearing from you for your kind advices and thanks a lot in advance. With best regards, Yours sincerely, Tag: LIKE
  - 8
    - SP2 Upgrade Failure - 11032 - Unable to install Windows Installer MSP file from another engineer in my group - looks like there was some leftover from the old 2000 installation (which is no longer installed): I saw this section in the log ( always search for “return value 3” in any MSI logs): MSI (s) (9C:78) [20:33:17:978]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI7F3.tmp, Entrypoint: InstallFTERef FTECa.DLL: INFO: FTE: InstallFTERef(), Entering... FTECa.DLL: INFO: FTE: GetFTERefInstallParams: FTERef : * FTECa.DLL: ERROR: FTE: InstallFTERef: Fail to create FTERef file: E:\MSSQL\data\FTData\noiseCHS.txt, Err=3 MSI (s) (9C:FC) [20:33:18:322]: User policy value 'DisableRollback' is 0 MSI (s) (9C:FC) [20:33:18:322]: Machine policy value 'DisableRollback' is 0 Action ended 20:33:18: InstallFinalize. Return value 3. OS error 3 is file not found. This looked like a SQL 2000 upgrade artifact in the registry. I created a folder at the location, reran setup and it worked! Tag: LIKE
  - 9
    - converting sql server 2005 data into xml format How to convert table in database, in microsoft sql server 2005 into xml format Tag: LIKE
  - 10
    - Problem with package.Execute passing variables BMcDowell wrote: A copy of the error returned. Source: Bulk Insert Task Description: The result of the expression "@[User::TableName]" on property "DestinationTableName" cannot be written to the property. The expression was evaluated, but cannot be set on the property. I have not used bulk insert task; but the error suggests that 'DestinationTableName' property cannot be override via expression...It may be that the problem Tag: LIKE
  - 11
    - Conditional checks in SSIS. Use one Execute SQL to get the Max value from DB2, and one to get the Max value from DB1. Store the values in variables, as Jay described. Then have a data flow to do the actual inserts. Have a precendence constraint between the 2 Execute SQL tasks, and one between the 2nd Execute SQL and the data flow. Right-click on the precedence constraint between the 2nd Execute SQL and the data flow task, and change the Evaluation Operation to Expression and Constraint. Leave the Value as Success, and change the Expression to compare the variables you created (something like MaxIDFromDB1 > MaxIDFromDB2). Execution will only flow to the data flow if the expression evaluates to TRUE. Exec SQL ---> Exec SQL --(expression goes here)-> Data Flow Tag: LIKE
  - 12
    - Checkboxes in Reporting Services? There we go! Thanks man!!! I was setting an available value. Thanks so much!! Neil. Tag: LIKE
  - 13
    - Navigation from the header Hello I have a link on the header to jump to another report. It was working fine on test server but when deployed to production, is giving the followin error. Any suggestions Thanks Inder The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath) Tag: LIKE
  - 14
    - Problems trying to insert data into the database using excel Hi all, I have encountered a problem. In the past i run a sql query to select all the data from the excel file and insert them into my SQL database. However recently i encountered an error when i run the query. Msg 7399, Level 16, State 1, Line 4 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 4 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls". How i solve this error. Any ideas Thanks Tag: LIKE
  - 15
    - tempdb Log file - stop/start SQL Server to reset tempdb??? On a 24/7 availability system you size your tempdb for what is required to run the system. Generally if you are having to reduce it in size then you are taking away space that it needs during normal processing and it will need to reclaim that space (assuming it is available) later. If the space is not available then it will stop (at least the user process and possibly the SQL Server). In SQL Server 2005 tempdb is more heavily used and so generally needs more space than it did before. Here is a link to a Microsoft white paper that goes into more details. http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx It does include information on shrinking tempdb if that is what you decide to do (but it does recommend against it). Tag: LIKE
  - 16
    - Code to flatten a CellSet into a datatable Hi, Here's some code I've written which flattens a CellSet into a datatable. I looked for a long time to find similar code but could not find any. Can I please have some thoughts on optimisation/elegance etc... I'm a bit new to .NET so any advice would be great! Thanks. Code Snippet Public Function GetFlatData() As DataTable 'If (Me.Cells.Count = 1) Then ' Return New DataTable() 'End If Dim table As DataTable = New DataTable() Dim headers As ArrayList = New ArrayList() For a As Integer = 0 To (Me.Axes.Count - 1) For i As Integer = 0 To (Me.Axes(a).Set.Hierarchies.Count - 1) Dim h As Hierarchy = Me.Axes(a).Set.Hierarchies(i) If (Not h.Name.Contains("Measure")) Then table.Columns.Add(h.Name) End If Next i Next a Dim items As ArrayList = New ArrayList() For x As Int32 = 0 To (Me.Axes(0).Set.Tuples.Count - 1) Dim tx As Tuple = Me.Axes(0).Set.Tuples(x) Dim itemBase As CellItem = New CellItem() For Each mx As Member In tx.Members If (mx.LevelName.Contains("Measure")) Then If table.Columns.IndexOf(mx.Caption) = -1 Then table.Columns.Add(New DataColumn(mx.Caption, GetType(Double))) End If itemBase.AddMeasure(mx) Else itemBase.AddAttribute(mx) End If Next If (Me.Axes.Count > 1) Then For y As Int32 = 0 To (Me.Axes(1).Set.Tuples.Count - 1) Dim item As CellItem = itemBase.Clone(True) Dim ty As Tuple = Me.Axes(1).Set.Tuples(y) Dim memy As Member For Each memy In ty.Members If (memy.LevelName.Contains("Measure")) Then item.AddMeasure(memy) Else item.AddAttribute(memy) End If Next item.ValueCell = Me.Cells.Item((y * Me.Axes(0).Set.Tuples.Count) + x) 'item.ValueCell = Me.CellGrid(x, y) items.Add(item) Next Else ' for 1 axis cellsets itemBase.ValueCell = Me.Cells.Item(x) items.Add(itemBase) End If Next '' might have no measures need to cater For i As Integer = 0 To (items.Count - 1) Dim row As DataRow = table.NewRow() Dim attributes As ArrayList = (CType(items(i), CellItem)).Attributes For j As Integer = 0 To (attributes.Count - 1) Dim member As Member = CType(attributes(j), Member) row(j) = member.Caption Next Dim measures As ArrayList = (CType(items(i), CellItem)).Measures If Not measures Is Nothing Then ' each CellItem should only have one measure For j As Integer = 0 To (measures.Count - 1) Dim member As Member = CType(measures(j), Member) Dim value As Cell = (CType(items(i), CellItem)).ValueCell If Not (String.IsNullOrEmpty(value.Value)) Then 'need to set appropriate type accroding to cell 'table.Columns[member.Caption].DataType = value.CellProperties. row(member.Caption) = value.Value Else row(member.Caption) = DBNull.Value End If Next End If table.Rows.Add(row) Next Return table End Function #End Region #Region " Private Classes " Private Class CellItem Private _measures As ArrayList Private _attributes As ArrayList Private _valueCell As Cell Public Property Attributes() As ArrayList Get Return _attributes End Get Set(ByVal value As ArrayList) Me._attributes = value End Set End Property Public Property Measures() As ArrayList Get Return _measures End Get Set(ByVal value As ArrayList) Me._measures = value End Set End Property Public Property ValueCell() As Cell Get Return _valueCell End Get Set(ByVal Value As Cell) _valueCell = Value End Set End Property Public Sub New() _attributes = New ArrayList() _measures = New ArrayList() End Sub Public Sub New(ByVal attributes As ArrayList, ByVal measures As ArrayList, ByVal valueCell As Cell) Me.Attributes = attributes Me.Measures = measures Me.ValueCell = valueCell End Sub Public Sub AddAttribute(ByVal o As Object) _attributes.Add(o) End Sub Public Sub AddMeasure(ByVal o As Object) _measures.Add(o) End Sub Public Function Clone(ByVal isDeep As Boolean) As Object If (isDeep) Then Dim item As CellItem = New CellItem(Me.Attributes.Clone(), Me.Measures.Clone(), Me.ValueCell) Return item Else Return New CellItem(Me.Attributes, Me.Measures, Me.ValueCell) End If End Function Tag: LIKE
- Next
  - 1
    - How to specify the MSSQL.1 DATA folder in SQL Express? Thanks Jon. We do that already. My data is installed in x:\MSSQL2005\InstanceName\ MSSQL than adds: x:\MSSQL2005\InstanceName\MSSQL.1\MSSQL\DATA but if someoneelse has installed a different app I would get x:\MSSQL2005\InstanceName\MSSQL.2\MSSQL\DATA The problem is I don't have any control over the last part. Tag: LIKE
  - 2
    - Is Full-Text Index really that much overhead? As Rich has mentioned, A solid argument would be that an out-of-the-box solution already exists. It doesn't make sense to re-invent the wheel especially considering the time/labor costs associated with development, testing, and documentation. Equally, cursors carry a lot of overhead on the server but they do have their place. It wouldn't make sense for a DBA to argue that a developer can easily loop through the records without an equal amount of overhead. This simply isn't logical. Adam Tag: LIKE
  - 3
    - Hourly Data Would you expect to see the results broken down by day, or would you want to see the total number of rows for the 3 o'clock to 4 o'clock period (for example) for all days represented by a single row e.g. Either: Day 1, Hour 3, 564 Day 2, Hour 3, 989 Day 3, Hour 3, 43 etc... or a single row for hour 3 for all three days: Hour 3, 1596 Chris Tag: LIKE
  - 4
    - What happens when the 4 GB database size limit is reached? Thanks! But the database will still be usable (readable) after this exception occured It doesn't become corrupted by that, I hope Tag: LIKE
  - 5
    - Can I debug a SQL 2005 stored procedure with the SA account I want to know if I can debug stored procedures remotely with the SA account. I can not have Active Directory in my system right now. Thanks Tag: LIKE
  - 6
    - What permission required to DROP TABLE ? this will never work: " GRANT DROP TABLE TO username" because DROP is not grantable. This will work: USE dbname GRANT CREATE TABLE TO username EXECUTE AS USER = ' username ' go CREATE TABLE T1 (c1 int) go REVERT go GRANT CONTROL ON tablename TO username EXECUTE AS USER = ' username ' go DROP TABLE T1 go REVERT go hth, -Steven Gott S/DET SQL Server Tag: LIKE
  - 7
    - Clarification on product specification http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx The above link says the pros and cons of two SQL Server 2005 editions. Document says Compact Edition is not good for ‘When you need a multi-user database server ’. What is the meaning of multi-user database Does this means the database strictly will not support two database connections at a time -Thank you, Gish Tag: LIKE
  - 8
    - SP to search on any number of characters Thank you gentleman for your assistance. I now have a number of options from with which to choose. I discovered (after days of research & testing) another method that would allow me to pull only the data I needed. I had to use a JOIN Clause in my SP and it pulls only the data I type into a textbox control. Wallace Tag: LIKE
  - 9
    - Is there a way to parameterize lock type? Basically I want to avoid SQL code duplicates. The stored procedure needs to select some stuff before updating data. Selection can be done using other stored procedure, but to avoid deadlock I want to select data with UPDLOCK hint. I know that data are going to be updated, so locking them earlier just helps against deadlock. And if I can't parameterize it, I need to have two versions of SP with data selection: one that just selects data (for readonly purposes) and the other one that selects with update lock. Tag: LIKE
  - 10
    - Conflicts in Merge Replication Hello, Use the processing_order parameter of sp_addmergearticle stored proc, when adding articles to the publication. [ @processing_order = ] processing_order Indicates the processing order of articles in a merge publication. processing_order is int, with a default of 0. 0 specifies that the article is unordered, and any other value represents the ordinal value of the processing order for this article. Articles are processed in order from lowest to highest value. If two articles have the same value, processing order is determined by the order of the article nickname in the sysmergearticles (Transact-SQL) system table. For more information, see Specifying the Processing Order of Merge Articles. Thanks Udaya. Tag: LIKE
  - 11
    - cluster install 2nd node unavailable Can you check thru this http://msdn2.microsoft.com/en-us/library/ms179530.aspx link and confirm whether you have following in same fashion. Tag: LIKE
  - 12
    - Job interview question I have been asked by a person who is going to interview me to supply this informationl; ' Come prepared to be able to talk me through how to set up an SQL driven .NET website on a server. You are given a webroot folder containing root files such as the web.config and all the files for a .NET website and a data folder which contains an .mdf and .ldf files. Talk me through what each of these folders contain and what you would do with them in order to set up the website on a server such that you would be able to open a browser type the URL you have configured and visit that website.' I come from a Cisco background and no nothing about what she is asking. Is it unreasonable of me to expect to be able to gain this information in 2 days Can you tell me the best place to look for this knowledge Thanks for any help. Tag: LIKE
  - 13
    - Setting multi-value parameters using ReportExecutionService Does anyone know how to set multi-value parameters using ReportExecutionService in C# If I have rsExec = new ReportExecutionService2005. ReportExecutionService (); . . . ReportExecutionService2005. ParameterValue [] parameters = new ReportExecutionService2005. ParameterValue [2]; parameters[0] = new ReportExecutionService2005. ParameterValue (); parameters[0].Label = "Report_Begin_Date" ; parameters[0].Name = "Report_Begin_Date" ; parameters[0].Value = "4/15/2007" ; parameters[1] = new ReportExecutionService2005. ParameterValue (); parameters[1].Label = "SalesID" ; parameters[1].Name = "SalesID" ; parameters[1].Value = //Here, this parameter should accept multiple values like 200, 201, 202, etc. rsExec.SetExecutionParameters(parameters, "en-us" ); How would I set the SalesID to take multiple values Tag: LIKE
  - 14
    - Calculated Fields in the report Why are you trying to substitute COUNT(*) for 1 The point of SUM(CASE ... 1 ELSE 0 END) is to do a conditional count *for* you. You are summing 1 (not an expression) for each row that fits your condition. See Nothing to substitute and no reason to use COUNT() <s>. >L< Tag: LIKE
  - 15
    - Performance is degraded drastically after migrating to SQL Express 2005 from MSDE 2000 Hi, in sql2005 express you can use the same connectionstrings like in all other sql2005 editions. The following i use in a webproject and it works very fine: <connectionStrings> <clear/> <add name= "Sup" connectionString= "Server=.\SQLEXPRESS;Database=Support;Trusted_Connection=True; Asynchronous Processing=True;MultipleActiveResultsets=True;" providerName="System.Data.SqlClient"/> ... </connectionStrings> The "Server=.\" means the local machine. Here you can say every name where you will connect to. The "SQLEXPRESS" is the instance of the sql Server installed on the machine. Hope this helps Servus Klaus Tag: LIKE
  - 16
    - extract information from tables Hello Guys, my collegue left the job and I have been chosen to work on his assignments. He posted this question before and got the answer but I couldn't find a way to implement it in the program. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1726638&SiteID=1 I changed the database a bit as I couldn't understand his logic of putting both PayID and TransNo as this would be a linked table and should have many to many relationship Code Snippet TransactionID int Unchecked TransNo varchar(50) Checked RefNo nvarchar(50) Checked FundCodeID smallint Checked TransAmount decimal(18, 2) Checked Description varchar(100) Checked TransPayID (from TransPayLnk Table as foreign key) Tbl_TransPayLnk Code Snippet TransPayID int Unchecked TransNo varchar(50) Checked TransDate datetime Checked Operator char(5) Checked TerminalID tinyint Checked Flagged char(1) Unchecked Remarks text Checked RemarksDate datetime Checked TPayment decimal(18, 2) Checked Tbl_Payment Code Snippet PaymentID int Unchecked PayType varchar(50) Checked Amount decimal(18, 2) Checked TransPayID (Foreign Key from Tbl_TransPayLnk) My requirement would stay the same, I would need to put the data from these 3 tables into a single line without duplicating the records and I would need to display them in a DataGridView. P.S: Would it be possible to have Mixed when a TransPayID is matched in Tbl_payment with more then one record rather then brining cash and cheque. Thank you all for your help. Bye Gemma Tag: LIKE

Ben Amor Bassem

HI,I want the synthaxe of a query with "LIKE" knowing that the fields must contain strings
then a parametre then strings I tested with this synthaxe but it is not true:
New_VilleExtensionBase.New_name LIKE “%” + @param1 + “%”
How is that done

Top

Re: LIKE

Jarret

I think this will work for you.

New_VilleExtensionBase.New_name LIKE '%' + @param1 + '%'

Hope this helps.

Jarret

Top