|
Hi all,
I uploaded some data to SQL Server 2008 from Excel.The table has 4 Fields,After upload the data to Database some of the data in fourth fields are NULL.I need to update the data from first as follows
Field1 , Field2 , Field3 , Field4
ABC_XYZ_123 , Office , 432322 , Null
XYV_PVC_321 , House , 908000 , 321
MBV_DHC_908 , House , 751232 , 908
MNP_BNM_876 , Office , 125152 , 876
As mentioned above,I need to update first row with 123 which already have in first field.
please help me to find to query for solvng above issue.
thanks
|
|
|
|
|
here it is
UPDATE mytable
SET field4 =
(SELECT RIGHT(mt.field1,CHARINDEX('_',mt.field1)-1)
FROM mytable mt
WHERE mt.field1 = mytable.field1
)
SELECT * FROM mytable
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.cacttus.com
|
|
|
|
|
thanks for you reply.let me try with it
|
|
|
|
|
That should works without problem, I tested it and it worked.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.cacttus.com
|
|
|
|
|
Hello,
I tried with above query.But it extracting 10 Digits.I dont know why.I have some datas in Field4 like this "74_125352" actually i need 125352.
modified on Sunday, May 8, 2011 1:46 AM
|
|
|
|
|
I'm trying to install MSSQL EXPRESS 2008 on my companies work computer.
I have the local admin right,just not the super admin. it gives me this not enough permission error.
When I did finally successfully install the MSSQL. It just that it gives these errors
2011-04-28 11:50:32.05 spid51 Error: 17204, Severity: 16, State: 1.
2011-04-28 11:50:32.05 spid51 FCB::Open failed: Could not open file e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1. OS error: 3(The system cannot find the path specified.).
2011-04-28 11:50:32.05 spid51 Error: 17207, Severity: 16, State: 1.
2011-04-28 11:50:32.05 spid51 FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.
I did do some searching online. It says that this is caused because i wasn't able to finish the installation.
Is there any way to fix this or install the MSSQL? Since I'm just a normal dude in this company. There's no way I can get the super admin right. or even create another user account. Any help?
#EDIT all installation is directed to c:\ only. But it seems the default is e:\ weird setting presuming everyone has an E:\
modified on Thursday, April 28, 2011 4:29 AM
|
|
|
|
|
Just some ideas:
*I have had trouble with compression turned on. Once I turned off compression, my SQL installation went smoothly.
*Perhaps you had an external drive (e.g., flash drive or USB hard drive) plugged in during the install? Maybe it's a network drive that has since been disconnected?
I recommend uninstalling and installing again. If you don't have the permission to perform the install, have an administrator at your company install the software for you.
Also, run chkdsk to ensure your hard drive does not have any errors on it. This page explains some possible causes of the error. One reason might be that some files got corrupted or are not available (e.g., on a disconnected drive).
|
|
|
|
|
AspDotNetDev wrote: *I have had trouble with compression turned on. Once I turned off compression, my SQL installation went smoothly.
Where can i turn off the compression?
AspDotNetDev wrote: *Perhaps you had an external drive (e.g., flash drive or USB hard drive) plugged in during the install? Maybe it's a network drive that has since been disconnected?
Nope no external drive was installed and the network was on s:\ , so i don't think it will be e:\.
AspDotNetDev wrote: If you don't have the permission to perform the install, have an administrator at your company install the software for you.
I don't know if local admin right is enough to perform the install. I mean i can edit registry or change computer settings. I just can't create a new account. And asking the people in IT is like begging for mercy, I'd really like to avoid that until necessary.
AspDotNetDev wrote: Also, run chkdsk to ensure your hard drive does not have any errors on it.
Nope no errors.
|
|
|
|
|
loveangel888 wrote: Where can i turn off the compression?
I am speaking of NTFS compression. Right click the root drive (C:\ I suppose) and ensure "compress this drive to save disk space" is unchecked. Also, any folders that SQL installs to (e.g., Program Files) should also be uncompressed.
|
|
|
|
|
Well I checked them just now and I don't see this option anywhere. I suppose its not open by default .
BTW the file name I used to install is SQLEXPRWT_x86_ENU.exe
*EDITED NVM I found it , it wasn't opened
|
|
|
|
|
What drive are you installing from? a CD?
Also, did you run the install as administrator?
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
S Douglas wrote: What drive are you installing from? a CD?
From C:\ a downloaded File at Microsoft.
S Douglas wrote: Also, did you run the install as administrator?
My account is the local admin account. Except create account, I basically have right to everything ( I think ).
|
|
|
|
|
loveangel888 wrote: From C:\ a downloaded File at Microsoft.
Was it an installer file (EXE, MSI) or a virtual disk (ISO)? Speaking of, do you have drive emulator software that may have been enabled at some point (e.g., Alcohol 120% emulates DVD-ROM drives)?
|
|
|
|
|
right click installer, run as adminitrator. sql needs to install stuff that has to run as the local admin, which sounds like you have permissions to do so.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
Yes, But the part that worries me, is will the installation create an Account of it self. Which if it does, then that's probably the reason why I cannot install the whole thing.
nevertheless i will try out to run as later as i'm working on other stuffs now. Will report result later  .
|
|
|
|
|
OK.. I found the reason. It seems I don't have the debug right for the programs in my account. As a result I won't be able to install MSSQL into the computer. This kinda sucks. And I found a KB about it. It seems this happens a lot in big companies.
|
|
|
|
|
Perhaps you could use a different database.
|
|
|
|
|
Hello All ,
I am getting the error message while opening the application.
2011-04-25 20:04:18,786 ERROR [[/adassetupdater]] Exception sending context initialized event to listener instance of class com.drutt.opensurf.tpim.servlet.Configuratio
nLoader
java.lang.RuntimeException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at com.drutt.util.jdbc.PooledConnectionManager.ensureCapacity(PooledConnectionManager.java:275)
at com.drutt.util.jdbc.PooledConnectionManager.configure(PooledConnectionManager.java:165)
at com.drutt.util.ConfigurationImpl$FactoryImpl.create(ConfigurationImpl.java:679)
at com.drutt.mgen.arch.impl.AbstractManager.configure(AbstractManager.java:85)
at com.drutt.util.ConfigurationImpl$FactoryImpl.create(ConfigurationImpl.java:679)
at com.drutt.util.ConfigurationImpl$Record.createInstance(ConfigurationImpl.java:873)
Ish Kumar Kapila
|
|
|
|
|
It seems there is something wrong with the connection string. Can you verify if it is correct?
|
|
|
|
|
It is giving error
could not connect to the portal database. Please us the following string to connect
jdbc:oracle:thin:msdp/msdp@192.168.56.1:1521:orcl
do not use where to use this and of no help 
Ish Kumar Kapila
|
|
|
|
|
Is that a correct IP? Try connecting using serverName@DomainName instead. Was there any change made to the database server recently?
|
|
|
|
|
No change was made , and can u tell me where to use the format you mentioned.
Ish Kumar Kapila
|
|
|
|
|
Are you writing code or running an application provided by someone else?
If you yourself are writing code then either you wrote some java code that created a JDBC connection or you configured a JEE server/container to do the same.
Thus you know where the connection string is or you need to find out.
If instead you are running an application (one you did not create) then you need to contact the vendor of the application and/or read the documentation of the application to determine how to correctly use it.
The error message indicates that the connection string, which is something you should be familar with in the first case is not set to value that allows it to establish a connection OR there is a network problem between the client box and the database box.
|
|
|
|
|
Maybe you should first check if the listener for the oracle database has started yet.
Then the connection string.
|
|
|
|
|
i m conectiond sql server using ILEDB using database header file ALTDBCLI.H, and geting the getInterface()!=0 error while updating the row in the sql server database, row is updated but described error occures
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
