I need to write a query which would give me result like this:
name Code1 code2 code3 ect
J Doe 10 2 3
J Smith 8 5 4
and so on...
I have a table which holds a name and this code.
there is muptiple entry of each code with each person i need to find out how many...
arial
Last Activity: Aug 20 '09, 11:03 PM
Joined: Sep 12 '07
Location:
-
Longitude/ latitude
Lat = 32788580 and Lon = 117097500
This is how I have long/latitude saved in my database table.
I need like this,
Lat --32.78858º
Long ---117.0975º .
I know this conversion but I don't know how can apply this conversion to each of my datarow and then put it into xml.
So, my xml file put longitude and latitude as shown below.... -
Convert into degree decimal
hi all,
I am stuck with another problem now. I got my xml of my sql database using asp.net c#. but now one of my column hold logitutude value in varchar format like; 117088752, which I had to convert into degree decimal format and export into xml.
can someone help me on this?
Thank You,Leave a comment:
-
convert .bak file into xml using c#
Hi all,
I have a sql .bak file which i need to convert into xml file.
can someone help with this?
pointing out to some tutorial or some suggetion on how to start?
Thak you, -
Hi,
Can I apply Trace to a perticular database Table?
Also, is there a way to look for view in Trace like Store Procedure?
waiting for any suggestion.
Thank you,Leave a comment:
-
Thank you all for help. My problem is solved.
Thank you,Leave a comment:
-
Hi all,
Back to my problem.
I will to save numeric value in separate string as well as the characters.
like,,,,,12345 abcdefh
I need string1 = "12345" and string2 = "abcdefh"
Any idea how can i do this?Leave a comment:
-
Trace on sql table
Hi all,
I have a sql server 2000. and i have one of the table in my database is getting value from some store procedure or view.
This database is developed by someone else and we don't have any documentation.
what my problem is i am trying to find out how data is getting dump into that table by which process.
Can any one suggetion me how can i find out this?
Also, i am a new... -
Thank you all for all your suggetion.
like chel-1 said i need to make sure it works both way,
123 abc and abnd 345 edf.
I will give a try to your suggetion and let you all know what happens.
Thank You,Leave a comment:
-
substring numeric value of a string
Hi all,
I need some help from you expert. I need to extract numeric value of a string.
for ext: string str = "1234 absc st" or it can be "123 hello world"
or "1234567 asp.net"
How can i only get the numeric part of the string?
Please help and give me some suggestions.
Thank you, -
i can't figured it out so, here i am providing my trigger as well store procedure.
this is my trigger which is on table dbo.wrk
once records gets into dbo.wrk this trigger fires up and moves data to dbo.glass by executing store procedure and here is the store procedure:...Code:create trigger trigger_qcheck on [dbo].[Q_CHECK_WORK] for insert as exec [dbo].[SDFD_CheckAndLoad]
Leave a comment:
-
Thank CK. I will check on my triggers. well at the moment my table has about 85 datafields.
and data i have is my test data about 2000 but it will grow once i solved this problem and launch this app.
Thank you,Leave a comment:
-
problem with MS sql server 2000 database table
Hi you all experts,
Here, I am running into strenge situation. I have ms sql server 2000 database and one of the table is acting strenge. I have trigger placed on this table to move data to the other table witin same database after validating the data.
data goes to the first table through my smart phone using sync process.
well at some point of time that table look likes locking up and no data can make... -
Thank you Delerna .
I will follow your instructions. and I am using MS server 2000.
Thank You,Leave a comment:
-
Execute store procedure
Hi all,
I need some ergent help from you expert.
I have a MS sql store procedure which I like to get execute autometically everyday at midnight.
Can anyone suggest or help on how to accomplish this?
Thank You, -
I am not very familier with trace. What I am trying to do is,
some how I can monitor the activity on this table?
Data gets into this table through a cable sync from a treo device.
After sometimes, data just doesn't get into the table.
I have two sets of table with same schema:
First one i called working table and second one I called a final data.
I have store procedure...Leave a comment:
-
SQL Trace
Hi all,
I am new to SQL sever 2000 and database.
I need to write a trace to monitor what is going on with one of my database table?
How can I trace the activity of this perticular table?
Can someone help me with this and point out to a good tutorial for a beginner?
I will really appreciate all your help.
Thank You, -
Actually its a two different system, unit with M series and B series.
Database is already designed and in place on different server.
I am doing a front end app. to pull up the data using a common application.
So, that why I need to make a value of textbox to match with atleast one unit table. meaning I think I have to search a whole unit table to see if there is a match. If it is not in that table then...Leave a comment:
-
Thank You Balaji U,
I can't use combo box as, my list is really big and it will grow over the time.
So, I like user to typed in their unit and bring up the records for that perticular unit.
Please suggest something without combo box.
Thank You,Leave a comment:
-
match up textbox value to database tabel
Hi all,
I need some suggetion.
click on "Submit"...Code:I have two different database. 1) Has information about all M series unit like m1,m2 etc 2) second one has information about all B series unit like b1,bls1,bls12 etc. here, I have table called Unit which store all b series unit. and I have .net form with a textbox. user can add a unit number like m1,b12 ect.
No activity results to display
Leave a comment: