SQL Server :: Stuck On Update Query / Identify That The First Letter In A Column In T1 Corresponds To One Letter In The Middle Of A String In A Column In T2 For Instance?
Nov 30, 2010
Heres the situation: I need update a column from my table (T1) from two other columns in a different table (T2).
My constraints are:
That I have to match the first 4 letters of a column in T2 to one column in T1 I have to identify that the first letter in a column in T1 corresponds to one letter in the middle of a string in a column in T2 For instance:
My Table (T1):
Order Type Combined
Place
0090 0001 YYXX 1YY
0091 1001 YYXX YYY
0092 1002 XXXX 2XX
Table 2 (T2):
Order Value
00900001YY XX
00911001YY XX
00921002XX XX
The Combined column in T1 is what i'm trying to complete. The T1.Place column contains the first character that I want to check for.
If it's a "1" then I want to make sure the 5th letter in T2.Order is a "0" If its a "Y" then I want to look for a "1001" If its a "2" then I want to make sure the 8th letter is a "2" in T2.Order
If all that matches then I was the last two letters in T2.Order + T2.Value to be combined and put into the appropiate spot in T1.Combined
Here's what I have:
[Code]....
I know it's a little complex, but i'm really stuck on it and any help would be greatly appreciated.
View 12 Replies
Similar Messages:
Jul 26, 2010
I am trying to get the modalPopup to work. Don't get any errors, the panel popsup as is supposed to, but the background doesn't gray out and the background of the panel doesn't display correctly either (it is black). The background of the main page doesn't change. To make sure I wasn't doing something wrong, I downloaded the samplcode (vb) from the AJAX website, and created a completely new web page, css file, .vb file, etc. Still have the same issue. I am using the latest version of ajaxcontroltookit ( 4.1.40412.0), VS 2010 RC, and VB)
View 8 Replies
Oct 14, 2010
I think this is a little tricky problem, but I need to solve it somehow. I have a texbox in my asp.net page. I want to show all names when a user types in a letter in that textbox, whatever names starting with that letter. the names are from a list generated by other function, pulled out from active directory. So for example: User types in "a" in a textbox then automactically names "aron" "asron" "amanda" in the list shows, and user can select one of those names.
View 4 Replies
Jan 6, 2011
I want to maintain the consistency of my database, I want the first letter and every letter after a space to be capitalized before the record can be entered into the database. Currently my validator expression (^[A-Z]+[a-zA-Z]*[0-9]*[^f
v]*$) can achieve only the first capital letter and it can't check on the letter after every space, so what is the expression to achieve that?
View 3 Replies
Jul 14, 2010
In asp.net,When I type letter in textbox, textbox doesn't show this letter and save in variable and when i type digit in textbox, textbox shows this digit and store in another variable. How should i do?
View 4 Replies
Aug 24, 2010
i want to take a string and check the first character for being a letter, upper or lower doesn't matter, but it shouldn't be special, a space, a line break, anything
View 3 Replies
Apr 11, 2010
I have a 3 column layout using table-less design.
[code]....
The CSS:
#left {width: 200px;float:left;display:inline;}
#content {width: 600px;float:left;display:inline;padding: 0 10px;}
#right {width: 160px;float:left;display:inline;}
I am using a web application, and I can't change the layout. By can't change, I mean the div's with left/content/right cannot be removed.
On some pages, both the left and right columns are completely empty. And I want the #content div to expand more than the 600px.
is this possible, without altering the HTML?
View 1 Replies
Dec 8, 2010
My string is:
1 STATE OF GOA THROUGH CHIEF
I want the output to be like
1 State of goa through chief
How can I keep the first letter capital and convert other to small? I had used .ToLower(), but it converts all the letters to small.
View 3 Replies
Dec 21, 2010
I have done this using templates but now I was wondering if its possible to use DataFormatString property of gridview's asp:boundfield to capitalize the first letter of the string
<aspBoundField HeaderText="Brand" DataField="brand" DataFormatString = "(?????)"/>
View 6 Replies
Mar 18, 2011
I have a table with three fileds userID, userName, userPassword.I have 100 rows in that table, now I want to update the userPassword column with new random generated string password.
View 1 Replies
Nov 23, 2010
This is my first class ever buildt (I am a real beginner) in C#. My aim is to "Sanitize a string". The class should do: trim an input make the first letter upper case. Is there a way to better code it? Would it make sense to use a PARAMETER for a method like: CapitalizeFirstLetterTrim(string x) when I initiate an object I need write a lot of code like below, any other way to make it shorter?
UserInputSanitizer myInput = new UserInputSanitizer();
myInput.Input = " ciao world";
string ouput = myInput.CapitalizeFirstLetterTrim();
Useful resource http://msdn.microsoft.com/en-us/library/bb311042.aspx
----------- CLASS
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace WebProject.Core.Utilities
{
public class UserInputSanitizer
{
// Backing variables
private string _input;
// Properties
public string Input
{
set { _input = value; }
}
private string _output;
// Backing variables
// Properties
public string Output
{
get { return _output; }
}
public string CapitalizeFirstLetterTrim()
{
// Trim
_input.Trim();
// Make First letter UpperCase and the rest levae lower case
_output = _input.Substring(0, 1).ToUpper() + _input.Substring(1);
return Output;
}
}
}
View 5 Replies
Mar 22, 2010
I want you to help me to use a cod that convert number to letter .
For example :
2000 $ : Two
Thousand dollars
View 8 Replies
Aug 10, 2010
I have a table converted from Access and the identity keys were lost. Now I need to make the id column the identity column, but it already has a lot of null values, how do I auto generate integer values for the null rows? The row ids are incremented, so if there is a way to auto increment the ids
View 7 Replies
Apr 1, 2011
I want to update multiple column of a table using subquery ...My sample code is shown below
[Code]....
its throwing syntax error...I dont know where i commiting mistake.
View 1 Replies
Nov 9, 2010
in asp.net c#. I have a DetailsView with a TextBox and I want the input data be saved always with the FIRST LETTER IN CAPITAL. Example:
"red" --> "Red"
"red house" --> " Red house"
View 7 Replies
Mar 21, 2010
I browsed through [URL] but could not find a regular expression that only checks if the first letter is a capital A. Am I on the right track with something like: ^([A])+/
View 7 Replies
May 24, 2010
i have a username= LICTowner.
i need to get the prefix from the word LICTowner i.e LICT.
how to split the word and get the 4 letter prefix.
in asp.net using C#
View 6 Replies
Mar 11, 2010
declare @FinallyGrandTotal float
declare @total float
set @total = 45.3699
set @FinallyGrandTotal = @total
in the above code ther is a total price 45.3699
I want add to FinallyGrandTotal this but with just 2 letters after the dot
that mean @FinallyGrandTotal = 45.3699
45.36 and not 45.3699
View 4 Replies
Apr 9, 2010
having a table with column having null values
how to identify row of a column contains null value?
i tried isnull,nullif properties but such functions im getting emptied rows
View 4 Replies
Apr 20, 2010
how to set an access key for controls using the associated label but I can't figure out how to underline the appropriate letter so the users know which key to use.
View 4 Replies
Jun 20, 2010
How do I change my dropdownlist so the first letter of the month are in upper? - And would like my text [Mounth] to be at the top of the dropdownlist when it is active. Right now is on the bottom. Hope can help these small things.
[Code]....
View 2 Replies
Aug 11, 2010
I have an ASP.NET GridView in a Web Form. This GridView using a SqlDataSource and utilizes paging and searching. For the sake of reference, here is the trimmed down version of it:
<asp:SqlDataSource ID="myDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:DB %>"
SelectCommand="SELECT p.[ID], p.[Name], p.[Email], l.[State], l.[City] FROM [Person] p, [Location] l WHERE p.[LocationID]=l.[ID] ORDER BY p.[Name]"
UpdateCommand="UPDATE [Person] SET [Email] = @Email WHERE [ID] = @ID"
/>
<asp:GridView ID="myGridView" runat="server" DataSourceID="myDataSource"
AllowPaging="true" AllowSorting="true" PageSize="25" AutoGenerateEditButton="true"
[Code]....
The data source has a lot of records. At least 25,000. Because of this, I want to allow the user to filter by state. I want to provide a drop down list with a list of states. When a user changes the drop down list, the results in the grid view will be filtered by the selected state. However, I do not know how to do this with a SqlDataSource.
View 1 Replies
Aug 19, 2010
Regex for Alphanumeric with length (must start with a letter A or C)?
View 2 Replies
Sep 24, 2010
We need to send out about 10.000 letters each month. They will be sent via postal services so I have to print them out with a new label/address on each letter. The envelope does have a window so the letter will be printed with the address.
All addresses will be found in a MSSQL database. I know how to make a SQL connection. I really need some input on how I would start doing this. The letter will be a twosided letter with the address in the upper right corner. How can I make a connection so that it loops trough the database for address and adds one by one. It should also add a new letter/page for each address found in the database.
View 1 Replies
Jun 8, 2013
I want to convert first letter of each word to capital n remaining all letter to lowercase..how should i code in c# to do so..
View 1 Replies
