I am not the one getting the tatoo. I am mearly helping a friend out. Getting a word tatooed onto your body is not my idea of a good tatoo - especially when it is your name (even if it is in chinese symbols). Why would you want that??? In case you forget what your name is???
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
LOL...
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
That is where i got it... :-D It is not that i don't trust google... i just wanted to make sure that "family" is really what is seen here. This is for a tatoo... I don't want it to say one thing and be under the assumption that it is saying family and all the arabic people are pointing with laughter knowing that it is saying something completely different :-) Thank you.
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Hi All, Sorry about posting this type of question here. Would anyone be able to translate the follwing... عائلة What does this word mean? Arabic - this is such an interesting writing language.
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
thank you... i will look into it.
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Hi all, I am trying to select values from a table to display them next to each other instead of underneath each other. Here is my attempt: SELECT A.Owner, A.Amount, B.Amount FROM Payment_History A JOIN Payment_History B ON A.Owner = B.Owner AND A.Number <> B.Number WHERE A.Owner = 49622 I have been google-ing it for a while now but so far this is my best attempt. The problem however is that the return twice (there are only two record for this member but some might have up to 15) like this: Owner Amount Amount 49622 11585.678 23143.57 49622 23143.57 11585.678 Please help my get the values to look like this Owner Amount Amount 49622 11585.678 23143.57 Only once like this... Thank you in advance...
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Thank you, That did the trick... :-)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
thank you... if this works... it would be a great start to a great weekend :-)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
hi all, I am trying to copy the records from one table to another like this... INSERT INTO [Claims].[dbo].[DocumentData] ([DocumentId] ,[DocumentData] ,[DocumentName] ,[ContentType] ,[LastUser] ,[LastDate]) VALUES (SELECT DocumentQueueId, DocumentData, DocumentName, ContentType, AssignedTo, GetDate() FROM DocumentQueue WHERE (AssignedTo = 'nbad\SlabbertH')) yet i get an error: Msg 156, Level 15, State 1, Line 14 Incorrect syntax near the keyword 'SELECT'. Msg 102, Level 15, State 1, Line 14 Incorrect syntax near ')'. what is the correct syntax for copying the records from one table to another? After i copied the records to the other table i will truncate the previouse table....
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
hi all, How would one go about replacing a character in a string with a space where the character is not in the range of a-z or A-Z or 0-9 ??? the following Code did not have the planned outcome... Dim cleanString As String = [String].Empty Dim reg As New Text.RegularExpressions.Regex("[A-Z]|[a-z]|[0-9]") Dim coll As Text.RegularExpressions.MatchCollection = reg.Matches(LineText, ) For i As Integer = 0 To LineText.Length - 1 MsgBox(coll(i).Value) If (coll(i).Value = [String].Empty) Then cleanString = cleanString + " " Else cleanString = cleanString + coll(i).Value End If Next the result was not pritty.... it removed spaces as well... how do i keep spaces and replace (NOT REMOVE) other characters with a space??? Thank you in advance.
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
wow, thanks... that was super fast.... :-D
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Hi, I beleive this sample code is in C#: string cleanString = String.Empty; Regex reg = new Regex("[A-Z]|[a-z]"); MatchCollection coll = reg.Matches(<MyStringGoesHere>); for(int i = 0; i < coll.Count; i++) { cleanString = cleanString + coll[i].Value; } See, i want to remove all characters that do not fall in the A-Z or a-z OR 0-9 category AND replace it with a space... example test123t3er = test t er Am i wrong in saying that the Regex reg = Regex("[A-Z]|[a-z]") CAN IT BE: Regex reg = Regex("[A-Z]|[a-z]|[0-9]") ??? AND the cleanString = cleanString + coll[i].Value; CAN I DO A TEST: IF(coll[i].Value == String.Empty) THEN cleanString = cleanString + " "; ELSE cleanString = cleanString + coll[i].Value ???? - in this way i add space if the character is not in the above category???? So please help me convert the very top section of code and i will build from there... Thank you in advance...
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Hi, I beleive this sample code is in C#: string cleanString = String.Empty; Regex reg = new Regex("[A-Z]|[a-z]"); MatchCollection coll = reg.Matches(); for(int i = 0; i < coll.Count; i++) { cleanString = cleanString + coll[i].Value; } See, i want to remove all characters that do not fall in the A-Z or a-z OR 0-9 category AND replace it with a space... example test123t3er = test t er Am i wrong in saying that the Regex reg = Regex("[A-Z]|[a-z]") CAN IT BE: Regex reg = Regex("[A-Z]|[a-z]|[0-9]") ??? AND the cleanString = cleanString + coll[i].Value; CAN I DO A TEST: IF(coll[i].Value == String.Empty) THEN cleanString = cleanString + " " ELSE cleanString = cleanString + coll[i].Value ???? - in this way i add space if the character is not in the above category???? So please help me convert the very top section of code and i will build from there... Thank you in advance...
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
So sorry, i thought i clicked on the sql link... my appologies...
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Hi all, i have a problem with job scheduling... I have a ssis package (2 actually)... i need this package to loop over and over again. (this package monitors a folder on a server and waits for a specifiec file type before reading the values in that file into the database and formatting the data and ultimately creates a new file with the same name, replacing the old file). Currently i have 2 packages doing this one job... each package ends with a "Execute Package" task. So, Package A would execute Package B at the end and then Package B would execute Package A at the end. (this puts my Job in an infanite loop, which is what i wanted...) BUT now i noticed that each time the package executes the next package, the "Running Packages" (as seen when you log onto the "Integration Services" on the server in SQL Server 2005) gets one extra package... (i presume this takes up memory). So this can't be good in the long run. So what i need help with is the following... 1. I need to put both packages into one package. (i know how to do this.) 2. I need to schedule the package in a job to execute every time the job ends successfully. I need help with the number 2 please... i dont know how to schedule a job to execute as soon as it successfully ended??? Thank you in advance. (any suggestions will be greatly appreciated.)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
i am going to run this vb.net code in a ssis package (script task)... i will be running this package in a scheduled job on SQL... so i dont think the user will be able to add bits to the query... this is just to keep our db up to date with their live database. The user wont see the results of these queries as it does not return any values to them... i only updates our database if the staging tables (that are populated by means of triggers) have any values available. (if i am wrong please correct me) Thank you anyway :-)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
So now i can just change the connectionString to point to another server (i just used the same server to test on.) :)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Sorry... Here is what i have and it is working fine now :-) Dim DS As System.Data.DataSet Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection Dim connectionString As String = "Initial Catalog=DBName;Data Source=ServerName;Integrated Security=SSPI;" Dim cn As SqlConnection = New SqlConnection(connectionString) Dim strSqlCommand As SqlCommand = Nothing ' Set Up the Connection String. MyConnection = New System.Data.OleDb.OleDbConnection( _ "provider=SQLOLEDB; database=DBName; " & _ "Integrated Security=SSPI; server=ServerName;") ' Set Up the Command to be executed. MyCommand = New System.Data.OleDb.OleDbDataAdapter( _ "SELECT * FROM StagingGeneric ORDER BY StagingDate", MyConnection) ' Fill the DataSet with the returned Values from the Database. DS = New System.Data.DataSet() MyCommand.Fill(DS, "StagingGeneric") ' Close The Connection To The DataBase. MyConnection.Close() ' Get Data Table Dim dt As DataTable = DS.Tables("StagingGeneric") ' For Each Row In The Data Row Check What Action To Follow For Each row As DataRow In dt.Rows 'MsgBox(Convert.ToString(row(3))) If Convert.ToString(row(3)) = "U" Then Dim LastContribDate As String = "''" If (Len(Convert.ToString(row(1))) > 9) Then LastContribDate = Left(Convert.ToString(row(1)), 10) End If Dim StageDate As String = "''" If (Len(Convert.ToString(row(4))) > 9) Then StageDate = Left(Convert.ToString(row(4)), 10) End If cn.Open() strSqlCommand = New SqlCommand("UPDATE stagingGenericTest SET" _ + " [Member_Number] = '" + Convert.ToString(row(0)) _ + "', [LastContributionDate] = " + LastContribDate _ + ", [PaymentStatus] = '" + Convert.ToString(row(2)) _ + "', [Action] = '" + Convert.ToString(row(3)) _ + "', [StagingDate] = " + StageDate _ + " WHERE [Member_Number] = '" + Convert.ToString(row(0)) + "'", cn) strSqlCommand.ExecuteNonQuery() cn.Close() ElseIf Convert.ToString(row(3)) = "I" Then Dim LastContribDate As Stri
NEVER MIND... I got it all figured out :-)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Okay, you wont beleive it but i figured it out... Now can someone please show me or point me to a link on how to read from a Dataset Once it has the records from the database in it???
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison