Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How Do I Remove Dashes In This String..


Hi,

  In a extract that i have the SS# is as 123-45-6789 how do i remove the dashes in the string and have the final expression of 123456789.

 

thanks

Karen


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Erro Running A Query If Dashes Present In The String
Hi all,I have a table in the DB which holds ISBN book nubers .. which, as you knowhave dashes (examlple: 0-98765-8-9).When I run a query from an ASP page to find the number, it doesn't returnanything:sISBN = "0-98765-8-9"OpenSQL(select URL from ISBN_Redirect where ISBN=" & sISBN )Can you give me a hind of what I am doing wrong?Thanks so much in advance.S

View Replies !   View Related
How To Remove Characters In String
There are unwanted characters(''','/','&'.. etc) in column.
I need to remove these characters

View Replies !   View Related
Remove Last Comma From The String
Hi All,
 
I have one field with different values like
 
F1
A,B,C,
D,E
G,H,I,
 
My requirement is  to remove the last comma from that string. I need the output should look like
 
F1
A,B,C
D,E
G,H,I
 
thanks,
Mears

View Replies !   View Related
Function To Remove Accent In String
Hi,Does anyone have a function which replaces accent chars from a stringwith the non-accented equivalent? For example 'hôpital' should return'hopital'.Thank you in advance.

View Replies !   View Related
Remove Unwanted Character From String
In SQL How do you take a field like the phone field and replace the unwanted Character Like - ( ).

View Replies !   View Related
Remove The String In Front Of Street
street_name
---------------------
1A HAYES ST
11a yONU STREET


i need to parse off watever is in front of the street_name. anyone
has any approach>?

street_name
-------------
HAYES ST
yonu street

View Replies !   View Related
Which Function Should I Use To Remove Alphabet In A String?
 

Hi all
 
Which function should I use to remove alphabet in a string?
 
For example, 60a , 50b, 34s, 34k. I want to remove the suffix alphabet. I tried to use filter but it return an array. i want the return value to be string or int to display.
 
Thanks
Bryan 

View Replies !   View Related
Remove Html Tags From A String!!!
 

I have a column of string which has html tags attached to it. How can I remove them..other than manually going and doing it? Any funtions?

Thanks!!

Tanya

View Replies !   View Related
Remove A Comment String From Text Field
I have a field that contains some text.  Each field will have none or atleast one comment in it. A comment can be a string of any length with *** on both sides. Ex: ***comment***

 
Declare @Test_tbl Table(TextField Text)
Insert Into @Test_tbl
        Select 'Some text ***comment*** some more text' Union all
        Select 'Other text ***another comment*** more and more text' Union all
        Select '***Comment*** some text ***More Comments***' Union all
        Select 'some text with no comment'


I need the output be ...

TextField
--------------
Some text some more text
Other text more and more text
some text
some text with no comment

 
 
 
Thanks in advance.

View Replies !   View Related
How To Remove Non-Numeric Or Non-alphameric Characters From A String In Sql Server 2005
Hi to all,
I am having a string like  (234) 522-4342.
i have to remove the non numeric characters from the above string.
Please help me in this regards.
Thanks in advance.
M.ArulMani
 
 

View Replies !   View Related
How To Remove Non-Numeric Or Non-alphameric Characters From A String In Sql Server 2005
Hi to all,
I am having a string like  (234) 522-4342.
i have to remove the non numeric characters from the above string.
Please help me in this regards.
Thanks in advance.
M.ArulMani
 
 

View Replies !   View Related
Dashes In DB Name
We have 2 3rd party databases on MSSQL 2000 that the respective applications created on the SQL Server. When the application created the DB's it used the NetBIOS computer name of the application server. Our NetBIOS names have dashes in them.

For example:
Server name: APP-SVR
Database Name Created: Application_APP-SVR

This is not realla a problem until I try to use the database name in query analyzer with a USE command, or if I want to prefix the object with the DB.OWNER and Query Analyzer sees the dash as an operator.

My question is this:
Why can I use the dropdown in query analyzer to choose the database but not issue a USE command to the DB? What does that dropdown do that a USE command is not doing??? What's the difference??

View Replies !   View Related
T-SQL And Dashes
Hi!
 
I run a query that returns strings that look like this: 08-07, 06-07,04-05 etc.  But when I copy the query outuput from Management Studion in SS2005 into Excel 2003, strings get converted into custom dates such as 8-Jun, 9-Jul, 4-May etc in Excel.  Is there anthing I can do in T-SQL to prevent this conversion?  The strings are set as char(5) datatype in a T-SQL view.
 
Thanks.

View Replies !   View Related
Adding Dashes To Ssn
Can anyone help with this. IF i have a ssn like 123459636 and i want to insert dashes into it how would i do that. Results would be 123-45-9636
The second problem is that some of the ssn dont have zero in them so some look like 1234567 i would have to pad with zero then trim from the right to 9 digits then insert the dashes not sure how to do that

results would be 001-23-4567

View Replies !   View Related
How To Query For A Column Value That Contains Dashes
Hi,I have a large table with a 'datetime' column that has date and timevalues in it. The data is in this format:2007-10-02 09:54:00.000The table is called 'profile' and the column 'msgdate'I want to return only rows that match a specific date. So far I havethe following query working:select * from profile where msgdate like '%2007%'This returns all rows that start with '2007'. However I cannot seem toge the syntax that will allow me to return a specific date, e.g.2007-10-02I have researched this, trying all sorts of queries with escapecharacters/sequences because of the dash character, but I cannot getit to return anything. Most of my queries have ran without error, itsjust that no data is returned.James

View Replies !   View Related
Variable Values Containing Dashes
Ok. Here is a weird problem.

I have a package which contains a variable with the value of a UNC sharename. The hostname in the share contains dashes.

I am trying to create a SQL Agent entry to execute said package. Because the package is now in production I want to pass in a new value for the sharename variable. I use the SQL @@SERVERNAME variable to build the package command. (Notice the BlotterUploadFolder variable at the end.)

SELECT @command = N'/FILE "\' + @@SERVERNAME + 'PackagesMiddleOfficeReconcilliationImportManualBlotter_AccountTransfers.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /CONNECTION MiddleOfficeDb;"Data Source=' + @@SERVERNAME + ';Initial Catalog=MiddleOffice;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;" /SET package.variables[BlotterUploadFolder].Value;\' + @@SERVERNAME + 'ManualBlottersUploads'

If I print the @command variable right after setting it, I get what I expect.

/FILE "\PRD-NY-DB-01PackagesMiddleOfficeReconcilliationImportManualBlotter_AccountTransfers.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /CONNECTION MiddleOfficeDb;"Data Source=PRD-NY-DB-01;Initial Catalog=MiddleOffice;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;" /SET package.variables[BlotterUploadFolder].Value;\PRD-NY-DB-01ManualBlottersUploads

If I cut-paste this into cmd window and execute it with DTExec.exe the package works fine. But when I run the schedule task it causes an error. When I go into the Job Properties dialog to look at the step, I see the value (in the "Set values" table) set to \PRD instead of \PRD-NY-DB-01.

If I modify the SELECT command above to put double-quotes around the value, the value is correct in the Job Properties dialog but causes an error when I exec it with DTExec.

/FILE "\PRD-NY-DB-01PackagesMiddleOfficeReconcilliationImportManualBlotter_AccountTransfers.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /CONNECTION MiddleOfficeDb;"Data Source=PRD-NY-DB-01;Initial Catalog=MiddleOffice;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;" /SET package.variables[BlotterUploadFolder].Value;"\PRD-NY-DB-01ManualBlottersUploads"

causes the error

Option "-NY" is not valid.

Hopefully somebody has an idea of what is going on.

Thanks.

- Jason

View Replies !   View Related
How Can I Bulk Insert Dashes?
when i do a bulk insert with dashes (i.e. one - two), i get the character u with two dots above it ( Ü ) in place of all the dashes? can't seem to figure out why. the field terminator is a comma ( , ).
 
i'm inserting just text with dashes into char(75) field.
 
can someone explain and provide a solution? i would greatly appreciate it!
 
my script is quite simple, maybe i'm missing something.
 



Code Snippet
 
bulk insert testtable
from '\localc$adjust.txt'
with (fieldterminator = ',')
 
 


thanks!

View Replies !   View Related
Finding Dashes/hyphens In A Column.
Hi,I'm having trouble running the following query:select * from message where text_body like ' ----------%'ie, five spaces followed by at least ten hyphens. The query doesn'tcomplete, so eventually I cancel it. If I remove the hyphens from thequery ("... like ' %'") then it runs fine (though it doesn't findthe correct data).Am I confusing SQL Server by using a wildcard or regular expression?(I'm using SQL Server 2000 - 8.99.760).Thanks in advance for any helpRichard

View Replies !   View Related
Inserting To Table With Dashes In Fieldnames
Hello,I have had a request, one of our tables is used as a report and I have beenasked that all fieldnames for months have dashes in them,like Jan-05 instead of Jan05 and so on...Now what we have is a CURSOR which loops through all values in another tablegenerating these fieldnames, like 'Jan-05', Feb-05' etc..Then the table definition is modified so these months display as fieldnames.That is fine,Except later it calls another stored procedure which inserts values fromanother table into this one.INSERT INTO TableNameSELECT *FROM TablenameObviously this is failing because the newly amended table now has dashes inthe fieldnames now.Now as the fieldnames are created dynamically I cannot simply do INSERTTablename ([Jan-05], [feb-5]) etc, as one would normally do,How could I do this bearing in mind its not always going to be 12 months weuse,Basically I am asking how can I modify this INSERT statement so it takesinto account the fieldnames with dashes in themBearing in mind I don't know what the fieldnames are called as they arecreated dynamically by a CURSOR in a different routine.And its not always 12 months.have you any ideas?and the dashes are requiredJayne

View Replies !   View Related
Scheduling A Package With Variables Containing Spaces Or Dashes Fails
Using the "set values" tab, I am trying to set the values of package variables to strings that contain spaces and/or dashes. If I run the package using the integrations services server, it runs perfectly. If I schedule the package on SQL Server agent, I get the following error.

 

"Executed as user: GBPSQLServer. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Option "-restofstring" is not valid.  The command line parameters are invalid.  The step failed."

 

Looking at the command line generated by the SQL Agent interface, the value is quoted using double quotes like this:

 

/SQL "PackageName" /SERVER SQL1  /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET "Package.Variables[LogFolder].Value";"\remoteservernameinetpub he-restofstring
estofstring" /REPORTING E

 

It seems that the command line parser is not recognising the quotes, or maybe the slashes are throwing it off, or sql server agent is doing something funny to the command line before it executes it.

 

Anybody got any ideas?

View Replies !   View Related
BUG: SSIS Imported Package Errors With 'Guid Should Contain 32 Digits With 4 Dashes'
I have imported a package using SSIS into the Maintenance Plan folder from another server. 

It imports fine, but when i Modify the package then click save I get the following error : 'Guid should contain 32 digits with 4 dashes'.

This has been reported on other forums without resolution.

 

Pete

 

 

View Replies !   View Related
How Do I Clean Up The SQL Server (ctp) From ADD/REMOVE Program Without The Change/remove Button
I have uninstalled the CTP version of the SQL Server express so that I can install the released version but CTP version is still listed in the add/remove program list but without the change/remove button. I have been to different sites to find information on cleaning this up and I have ran all the uninstall tool I can find but the problem still prevails. I cannot install the released version without completely getting rid of the CTP version. Please help anyone.

Thanks

deebeez1

View Replies !   View Related
Unable To Remove SQL Instance In Add/Remove Program
I need help,

I am having a hard time removing my SQL instance inside the Add/Remove program.  After i select the SQL Instance name and then I tried to remove it but it won't allow me to delete it.  There isn't any error message or whatsoever.  Actually, when i try to log it in my SQL Management studio, that certain sql instance name is not existing according to the message box.  Is there any way to remove the Sql Instance in my system?

I appreciate your help, Thanks

IS Support

View Replies !   View Related
SQL Server Management Studio: Can Not Remove AdventureWorksDB In &&"Add Or Remove Programs&&" Of Control Panel
Hi all,

I tried to remove AdventureWorksDB in the "Add or Remove Programs" of Contol Panel and I got the following errors: (1) AdventureWorksDB     Error 1326: Error getting file security: CProgram FilesMicrosoft SQL ServerMSSQL1MSSQLGetLastError: 5.      |OK|   and (2) Add or Remove Programs   Fatal Error during installation (after I clicked the |OK| button).   Please help and tell me how I can solve this problem.

Thanks in advance,

Scott  Chang 

View Replies !   View Related
Employing XML Formatted String Data Rather Than Normal String(char(), Nchar() Or Varchar() Values
Hello,
Is there a way of passing in an xml formatted string or text to the report through a data set and have the textbox or table in which it displays keep the formatting specified in the xml string rather than in the textbox properties?
 
Thanks.

View Replies !   View Related
String Or Binary Data Would Be Truncated. (only For 1700 Character String?)
I am trying to insert a row into a table of Microsoft SQL Server 2000.

There are various columns.















[SNO] [numeric](3, 0) NOT NULL ,
[DATT] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
[DATTA] [char] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
[CODECS] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,

The [DATTA] column is causing a problem. Even if I am trying to put only 1700 character string into [DATTA], the java code throws the following exception:-



StaleConnecti A CONM7007I: Mapping the following
SQLException, with ErrorCode 0 and SQLState 08S01, to a
StaleConnectionException: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Connection reset

      at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)


Why is it throwing an exception even though the sum-total of this row doesn't exceed 8000 characters?

Can anyone please tell me what's wrong?

View Replies !   View Related
Adding String To Database, But Name Of String Is Added, Not Data
Hello, I am tring to add a string my database.  Info is added, but it is the name of the string, not the data contained within.  What am I doing wrong?  The text "Company" and "currentUserID" is showing up in my database, but I need the info contained within the string.  All help is appreciated!
 
 
Imports System.Data
Imports System.Data.Common
Imports System.Data.SqlClientPartial Class _DefaultInherits System.Web.UI.Page
 
Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs) Handles CreateUserWizard1.CreatedUser
'Database ConnectionDim con As New SqlConnection("Data Source = .SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|ASPNETDB.mdf;user instance=true")
'First Command DataDim Company As String = ((CType(CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Company"), TextBox)).Text)
Dim insertSQL1 As StringDim currentUserID As String = ((CType(CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("UserName"), TextBox)).Text)
insertSQL1 = "INSERT INTO Company (CompanyName, UserID) VALUES ('Company', 'currentUserID')"Dim cmd1 As New SqlCommand(insertSQL1, con)
'2nd Command Data
Dim selectSQL As String
selectSQL = "SELECT companyKey FROM Company WHERE UserID = 'currentUserID'"Dim cmd2 As New SqlCommand(selectSQL, con)
Dim reader As SqlDataReader
'3rd Command Data
Dim insertSQL2 As String
insertSQL2 = "INSERT INTO Company_Membership (CompanyKey, UserID) VALUES ('CompanyKey', 'currentUserID')"Dim cmd3 As New SqlCommand(insertSQL2, con)
'First CommandDim added As Integer = 0
Try
con.Open()
added = cmd1.ExecuteNonQuery()
lblResults.Text = added.ToString() & " records inserted."Catch err As Exception
lblResults.Text = "Error inserting record."
lblResults.Text &= err.Message
Finally
con.Close()
End Try
'2nd Command
Try
con.Open()
reader = cmd2.ExecuteReader()Do While reader.Read()
Dim CompanyKey = reader("CompanyKey").ToString()
Loop
reader.Close()Catch err As Exception
lbl1Results.Text = "Error selecting record."
lbl1Results.Text &= err.Message
Finally
con.Close()
End Try
'3rd Command
Try
con.Open()
added = cmd3.ExecuteNonQuery()
lbl2Results.Text = added.ToString() & " records inserted."Catch err As Exception
lbl2Results.Text = "Error inserting record."
lbl2Results.Text &= err.Message
Finally
con.Close()End Try
 
 
 End Sub
End Class

View Replies !   View Related
Help: About Ms Sql Query, How Can I Check If A Part String Exists In A String?
Hello to all,
I have a problem with ms sql query. I hope that somebody can help me. 
i have a table "Relationships". There are two Fields (IDMember und RelationshipIDs) in this table. IDMember is the Owner ID (type: integer) und RelationshipIDs saves all partners of this Owner ( type: varchar(1000)).  Example Datas for Table Relationships:                               IDMember     Relationships              .
                                                                                                                3387            (2345, 2388,4567,....)
                                                                                                                4567           (8990, 7865, 3387...)
i wirte a query to check if there is Relationship between two members.
Query: 
Declare @IDM int; Declare @IDO int; Set @IDM = 3387, @IDO = 4567;
select *
from Relationship where (IDMember = @IDM) and ( cast(@ID0 as char(100)) in
(select Relationship .[RelationshipIDs] from Relationship where IDMember = @IDM))
 
But I get nothing by this query.
Can Someone tell me where is the problem? Thanks
 
Best Regards
Pinsha

View Replies !   View Related
Capitalize A Text String/String Function Related
Hi Folks:

How can I capitalize a string like 'JOHN DOE' into
'John Doe' with one SQL statement. SQL does provide
string function like LOWER(char_expr) which would
change the whole text string to 'john doe' and I don't
want that.
So far, in order to do that, I have to use a front-end
development language like 'Omnis' which has a
string function 'cap()' to capitalize the whole string,
then update the back-end SQL with the new string.
Thank you in advance for your time and advice.

David Nguyen

View Replies !   View Related
Need Help With String Manipulation - Splitting 1 String Into Multiple Columns
Hello All,

I'm a non-programmer and an SQL newbie.  I'm trying to create a printer usage report using LogParser and SQL database.  I managed to export data from the print server's event log into a table in an SQL2005 database. 

There are 3 main columns in the table (PrintJob) - Server (the print server name), TimeWritten (timestamp of each print job), String (eventlog message containing all the info I need).  My problem is I need to split the String column which is a varchar(255) delimited by | (pipe).  Example:

2|Microsoft Word - รายà¸?ารรับ.doc|Sukanlaya|HMb1_SD_LJ2420|IP_192.10.1.53|82720|1

The first value is the job number, which I don't need.  The second value is the printed document name.  The third value is the owner of the printed document.  The fourth value is the printer name.  The fifth value is the printer port, which I don't need.  The sixth value is the size in bytes of the printed document, which I don't need.  The seventh value is the number of page(s) printed.

How I can copy data in this table (PrintJob) into another table (PrinterUsage) and split the String column into 4 columns (Document, Owner, Printer, Pages) along with the Server and TimeWritten columns in the destination table?

In Excel, I would use combination of FIND(text_to_be_found, within_text, start_num) and MID(text, start_num, num_char).  But CHARINDEX() in T-SQL only starts from the beginning of the string, right?  I've been looking at some of the user-defind-function's and I can't find anything like Excel's FIND(). 

Or if anyone can think of a better "native" way to do this in T-SQL, I've be very grateful for the help or suggestion.

Thanks a bunch in advance,

Chutikorn

 

View Replies !   View Related
Input String -&> Table -&> Output String?
I have a nasty situation in SQL Server 7.0. I have a table, in whichone column contains a string-delimited list of IDs pointing to anothertable, called "Ratings" (Ratings is small, containing less than tenvalues, but is subject to change.) For example:[ratingID/descr]1/Bronze2/Silver3/Gold4/PlatinumWhen I record rows in my table, they look something like this:[uniqueid/ratingIDs/etc...]1/2, 4/...2/null/...3/1, 2, 3/...My dilemma is that I can't efficiently read rows in my table, match thestring of ratingIDs with the values in the Ratings table, and returnthat in a reasonable fashion to my jsp. My current stored proceduredoes the following:1) Query my table with the specified criteria, returning ratingIDs as acolumn2) Split the tokens in ratingIDs into a table3) Join this small table with the Ratings table4) Use a CURSOR to iterate through the rows and append it to a string5) Return the string.My query then returns...1/"Silver, Platinum"2/""3/"Bronze, Silver, Gold"And is easy to output.This is super SLOW! Queries on ~100 rows that took <1 sec now take 12secs. Should I:a) Create a junction table to store the IDs initially (I didn't thinkthis would be necessary because the Ratings table has so few values)b) Create a stored procedure that does a "SELECT * FROM Ratings," putthe ratings in a hashtable/map, and match the values up in Java, sinceJava is better for string manipulation?c) Search for alternate SQL syntax, although I don't believe there isanything useful for this problem pre-SQL Server 2005.Thanks!Adam

View Replies !   View Related
Find In String And Return Part Of String
I am trying to find a way to find a certian character in a string and then select everything after that character.

for example i would look for the position of the underscore and then need to return everthing after it so in this case

yes_no

i would return no

View Replies !   View Related
Procedure Or Query To Make A Comma-separated String From One Table And Update Another Table's Field With This String.
We have the following two tables :

Link  ( GroupID int , MemberID int )
Member ( MemberID int , MemberName varchar(50), GroupID varchar(255) )

The Link table contains the records showing which Member is in which Group. One particular Member can be in
multiple Groups and also a particular Group may have multiple Members.

The Member table contains the Member's ID, Member's Name, and a Group ID field (that will contains comma-separated
Groups ID, showing in which Groups the particular Member is in).

We have the Link table ready, and the Member table' with first two fields is also ready. What we have to do now is to
fill the GroupID field of the Member table, from the Link Table.

For instance,

Read all the GroupID field from the Link table against a MemberID, make a comma-separated string of the GroupID,
then update the GroupID field of the corresponding Member in the Member table.

Please help me with a sql query or procedures that will do this job. I am using SQL SERVER 2000.

View Replies !   View Related
Converting String To Unicode String In T-SQL
Hi,We have stored proc name proc_test(str nvarchar(30)). So far this prochas been invoked from a .NET application assuming that only Englishcharacter strings will be passed to it. The calls are likeproc_test('XYZ')We now have a requirement for passing Chinese strings as well. Ratherthan changing the calls throughout the application, we would like tohandle it in the stored procedure so that it treats the string as aunicode string. Can we apply some function to the parameter to convertit to unicode so that we don't have to call with an N prefixed to thestring?Thanks,Yash

View Replies !   View Related
Remove
In one of the column which i import , all records have the
This means the enter button on that line... how to replace or remove

Eg ::

Month @ 7:30 p.m. Location: ass nue Westmont

View Replies !   View Related
Please Help To Remove (-)
 
Please help to remove (-)
The EM_TERMINATION_DATE column have records with no data.
I am using the following below script to format the dates.
The problem is : the format with (-) between yyyy-mm-dd retrive NULL records with (-) see the output. How to fix it?
Here is my ouput:
EM_TERMINATION_DATE
2006-03-15
    -  - 
    -  - 
    -  - 
    -  - 

Here is my script:

select

cast(left(EM_TERMINATION_DATE, 4) as varchar(4))

+ '-' +

Cast(right(EM_TERMINATION_DATE, 4) as varchar(2))

+ '-' +

Cast(left(Right(EM_TERMINATION_DATE,2), 2) as varchar(2))as TERM_DT

FROM EMF

View Replies !   View Related
Remove Trailing Zero
Would someone mind helping me with formatting a string please??
I have a column DECIMAL(4,2).  In a stored proc I am selecting this field and converting it to varchar so I can append certain characters to it (this is really irrelevant to my question).  However, before appending the characters, I need to remove zeros after the decimal point.
Examples:
3.00 should be 3
3.20 should be 3.2
3.05 should be 3.05
etc
 

View Replies !   View Related
How To Remove The Sqlcachedependancy ?
I had sqlcachedependancy installed. But now I cannot uninstall it?
1.  I unregistered:
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe -E -S localhost-d DNN1 -dd
2.  I remove the Dependencry.Start() from my application_start
' System.Data.SqlClient.SqlDependency.Start(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)
3. I removed the cache section from my web.config
4. I removed the outputcache statements from my aspx pages.
<!--<%@ OutputCache Duration="1" VaryByParam="*" SqlDependency="CommandNotification" %>-->
However, I still get the next error:




File


Error  
When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance.
 What to do?
 Any help or advice is appreciated.
Jelle
 
 

View Replies !   View Related
Remove Sql Express
Hi,
I don't need sql express, never use it and I would like to remove it. Is it possible without loosing important functionalities in VWD? Is that true that cannot compile the applications (ctrl+f5) anymore?

View Replies !   View Related
Remove Spaces
How can you remove spaces in the middle of a string, RTRIM and LTRIM does not work

View Replies !   View Related
Need To Remove The Year
here is what i have

SELECT FName, LName, CONVERT(VARCHAR(40),Birth,110)
FROM members
WHERE DatePart(month,Birth) = DatePart(month,getDate())

i would like to remove the year from the date. is their a way i can do that.

View Replies !   View Related
Remove Logs
How can i decrease logs of my database or remove them? its size is 4.5 GB and the size of my database is 15MB?

Thanx
Mohsen

View Replies !   View Related
Remove Foreign Key
Hi

Can anyone tell me how I can remove a foreign key in a SQL database?

Thanks in advance

View Replies !   View Related
Remove Double Value
HyNever use/practice SQL a lot, (vb... more, have free msde 2000) .2 questionsA)is it simple to write a T-SQL query for having 2) at result startingfrom 1) .B)how to test dynamically sql with parmaeter ( using vb ADO)1) before querycolumA columBd e <-samee d <-samee ee d <-same2)after querycolumA columBd e or e de e

View Replies !   View Related
How To Remove Lock?
From Sql-server enterprise manager : Management-Current Activity-Locks/Process ID, I found several locks, which preventing some of application working property.

So, I want to remove locks manually.
How Can I do this?

View Replies !   View Related
How To Remove Replication?
Hi, all.
I have two server(Svr01, Svr02) that are replicated each other (Merge replication).
Svr01 must be Publisher distributor.. but, by mistake Svr02 is set to distributor, publisher. (Publisher/distributor are on the same comp..)

I want to fix this..
How?

I think I have to remove replication on both side and Reset from the first.
but, I don't know how to remove replication either..

Please reply with any thougt....

View Replies !   View Related
How To Remove 1:1 Relationships
I have an asset schema problem which I'm not too sure how to resolve....

I have an asset table which stores values common to all asset types. I have created seperate asset type tables(VehicleAssetDetail, PropertyAssetDetail, InvestmentAssetDetail) to store their specific details.

This in turn creates 1:1 relationships between "Asset" table and the respective detail tables.

If I were to store all the details in the "Asset" table it would cause a lot of redundancy bearing in my mind there are about four other asset type details I have excluded from the schema.

Are the 1:1 relationships bad? If they are, how do I resolve them without throwing all the columns from the asset details tables into the Asset table?

Attached is a 15Kb gif image of the schema. I'd really appreciate any help with this... :)
Thanks.

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved