Search results for query: *

The next code display a dataset in an xml format. Could some one provide a technique to create an xml file out of this. using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; namespace XMLBond_Hub { class Program {...

Need some help to Generate an XML file from SQL server by using a sql statement or store procedure with c#. Thanks

This store procedure generate ramdom numbers but there is a slight probability that it could generates duplicate numbers. Can some one help me to modified it so at the time it is inserted in a table field it could verify if the same number exist.In case it exist generate another number verify...

Any help will be appreciated ID text 1 RTS_US SalesCov for HGU_SEC 2 GRT_UK SalesCov for All Euro 3 JJJ_US SalesCov for All Euro 4 COM_US SalesCov for HGU_SEC From the previous record I need an output like this I need to create an additional colum CODE and the value has to be...

id code 1 ABC_GB 2 DCF_GB 3 RTF_US NEED HELP TOto change the records that contain _GB to _US

ID Account Client DealerNam MSEG Tier 01 3949 ALLIUK ABN S_HG 3 02 3949 ALLIUK ABN S_HG 3 03 3949 ALLIUK TRB S_HG 3 04 3949 ALLIUK CRO S_HG 3 05 4000 Ahold CUS M_KG 3 06 4000 Ahold CUS...

I need some help to modify the following query QUERY I Select distinct trunc(sessions.starttime) as date, comp.CompanyID, comp.HC, sessions.userid from S_USERSESSION sessions, S_USER users, S_COMPANY comp where sessions.userid = users.userid and users.companyid = comp.companyid and...

Select distinct trunc(sessions.starttime) as date, comp.name, comp.HC, sessions.ctype, count (sessions.userid) from S_USERSESSION sessions, S_USER users, S_COMPANY comp where sessions.userid = users.userid and users.companyid = comp.companyid and sessions.starttime > trunc(sysdate) - 10 AND...

Select distinct trunc(sessions.starttime) as date, comp.name, comp.HC, sessions.ctype, count (sessions.userid) from S_USERSESSION sessions, S_USER users, S_COMPANY comp where sessions.userid = users.userid and users.companyid = comp.companyid and sessions.starttime > trunc(sysdate) - 10 AND...

The folloing query return the query I am looking for however the performance is not too goog. Could some one provide some technical advise how to improve performance. select f. s_name_1, g.company_name, g. s_name_1, k.full_name, j.p_name, e.edit_date, e.status...

I need to exclude records on Record1 from record 2 base on the maximun date Record1 ID Product Date 1 New Issue 2005-11-14 2 US High Grade 2005-11-17 Record 2 ID Product Date 1 New Issue 2005-11-02 1 New Issue 2005-11-04 1 New...

This is just a sample it could be thounsand records like this. What I am looking is to detect the most recent date if and only if the status was pending. For example the result from the sample should return 1 New Issue 2005-11-23 10:54:24.113 Pending 3 third 2005-11-23 10:54:24.177...

I need to find at what date a product was changed from status pending to any other status. id pname date status 1 New Issue 2005-10-23 10:25:17.483 Pending 1 New Issue 2005-11-23 10:43:02.963 Accepted 1 New Issue 2005-11-23 10:53:03.237 Denied 1...

I need some advice to decide in buying VS 2005 Team system or VS 2005 Professional version. I suppose the VS 2005 Team system is simmilar to VS 2003 Enterprise version. Could some one help me to clarify about it. Thanks

I have atable in Oracle and another in Postgre. The only think that ties these 2 tables is an ID, well I need to bring some data from Postgre base on the ID we have in Oracle and display this on the browser using PHP or HTML. There is a way to create a query joinning this two different resources...

I need some help to: ID USERNAME MESSage 1 nrj hello(nrj)there is a.. 2 pqt hola(nrj) today we had 3 nrj Try one more(nrj)time I need the following resul ID USERNAME MESSage STATUS 1 nrj hello(nrj)there SENT...

I need some help to: ID USERNAME MESSage 1 nrj hello(nrj)there is a.. 2 pqt hola(nrj) today we had 3 nrj Try one more(nrj)time I need the following resul ID USERNAME MESSage STATUS 1 nrj hello(nrj)there SENT...

Some one have an idea how to improve performance using this function that runs over 2680 records. alter FUNCTION dbo.ConcatRows ( @input int ) RETURNS varchar(8000) AS BEGIN DECLARE @Output varchar(4000) SELECT @Output = COALESCE(@Output, '') + Cast(' ' as varchar(10))+...

I have the follwing: afsfffdfREMARKSdddddd returned on my record and I need to detect for REMARK and replace all what I have before with empty spaces so my final result will be REMARKSdddddd Note: I have not control of the size of the record Remarks could be in any positions and it is warranty...

I have the follwing: afsfffdfREMARKSdddddd returned on my record and I need to detect for REMARK and replace all what I have before with empty spaces so my final result will be REMARKSdddddd Thanks