Hi All, I want to get the result according to comma seperated value in field. First let me explain the table and their data I have one table which contain following fields and data file sequence || Cat_Id || Sequence 4,1,5,8,9,10,20 || 41 || 2 18,17,19,24,25 || 48 || 9 19,21,22,23,24,25,26 || 49 || 10 above is the sample data structure which contains the data in above format. Now I want to create a query which rerurn the value of file_sequence field in following format 4,1,5,8,9,10,20,18,17,19,24,25,21,22,26 Here one thing Which I want to notify 1. above table is result of a query which is sorted on the base of Sequence 2. Now we pick the result of field_sequence from the start in the same order. 3. now we pick the 4,1,5,8,9,10,20 then 18,17,19,24,25 and then 21,22,26 4. duplicate value removed (in above example 19,24,25 are duplicate) so in this way I want to get the comma seperated value 4,1,5,8,9,10,20,18,17,19,24,25,21,22,26 Please suggest/guide how can i achieve this result

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Hi all, in my database table , i have one field (say field1) which contains the value like 1,2,3,10,11,20, a, b,c , 30, 40. I want to write a query which sore the result on the base of field1 and output should be like 1 2 3 10 11 20 30 40 a b c whether it is possible through query or i need to adjust in code ?

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

HI Jorgen, My problem is solved. please check this thread. Thanks for suggest new way of update and Insert. I was not aware of this way.

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Thanks a ton Varsha Your suggestion works well Now It takes only 8 - 9 seconds

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

HI Jorgen, I think this is not the cause for error. since it only not include the country in Grouping.

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

HI Jorgen thanks a lot for you suggestion. View option is not applicable for my requirement. since I need to update the data in table. Also i tried the Merge option as you suggested but with a little modification and it is the original query MERGE INTO issdetails_new lp USING ( SELECT Max( MktCloseDate ) , secid,country, PriceDate, OPEN , High, Low, Close, Ask, Last, Bid, BidSize, AskSize, TradedVolume, MktCloseDate, Volflag, TradedValue, TotalTrades, COMMENT , LocalCode FROM hist_prices GROUP BY secid, PriceDate, OPEN , High, Low, Close, Ask, Last, Bid, BidSize, AskSize, TradedVolume, MktCloseDate, Volflag, TradedValue, TotalTrades, COMMENT , LocalCode ) AS h ON (lp.Secid = h.Secid and lp.country=h.country) WHEN MATCHED THEN UPDATE SET lp.PriceDate = h.PriceDate, lp.open = h.open, lp.Low = h.Low, lp.high = h.high, lp.close = h.close, lp.ask = h.ask, lp.last = h.last, lp.bid = h.bid, lp.bidsize = h.bidsize, lp.asksize = h.asksize, lp.TradedVolume = h.TradedVolume, lp.MktCloseDate = h.MktCloseDate, lp.Volflag = h.Volflag, lp.TradedValue = h.TradedValue, lp.TotalTrades = h.TotalTrades, lp.Comment = h.Comment, lp.LocalCode = h.LocalCode but it gives me following error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MERGE INTO issdetails_new lp USING ( SELECT Max(MktCloseDate),secid,Pric' at line 1 Please suggest where i am doing wrong.

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Hi Varsha, i update the query as you suggested. and following is the original query UPDATE issdetails_new a, ( SELECT secid, country, PriceDate, OPEN , High, Low, Close, Ask, midval, Last, Bid, BidSize, AskSize, TradedVolume, MktCloseDate, Volflag, TradedValue, TotalTrades, COMMENT , LocalCode FROM hist_prices WHERE MktCloseDate = ( SELECT max( MktCloseDate ) FROM hist_prices ) ) AS b SET a.PriceDate = b.PriceDate, a.Open = b.Open, a.High = b.High, a.Low = b.Low, a.Close = b.Close, a.Midval = b.Midval, a.Ask = b.Ask, a.Last = b.Last, a.Bid = b.Bid, a.BidSize = b.BidSize, a.AskSize = b.AskSize, a.TradedVolume = b.TradedVolume, a.MktCloseDate = b.MktCloseDate, a.Volflag = b.Volflag, a.TradedValue = b.TradedValue, a.TotalTrades = b.TotalTrades, a.Comment = b.Comment, a.LocalCode = b.LocalCode WHERE a.SecId = b.SecId AND a.Country = b.Country Its works well. Thanks a lot but there are one more problem in table issdetails, there are 9500 records and in table hist_prices there are 41,50,000 records so it takes 11 -13 minute for update the table issdetails. Any option to reduce the execution time ? Please suggest

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Hi Varsha, i tried as following

UPDATE LatestPrice SET price = LatestPricesFromHistory.price,
FROM ( SELECT *
FROM history
WHERE Date1 = (
SELECT max( Date1 )
FROM history ) ) AS LatestPricesFromHistory
WHERE LatestPrice.Sid = LatestPricesFromHistory.SId and LatestPrice.Country = LatestPricesFromHistory.Country

but it give me following error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'From { select * from history where Date1=(select max(Date1) from history' at line 1. Please suggest

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Hi All, I want to update multiple columns of multiple rows of one table. Single/Multiple column update for single/Multiple row is quite easy but i want to update the rows of one table on the basis of rows of other table. Here I demonstrate that what i want with single query Table1 - History Fields and Data Date SId Country Price High Low ........ 1 Dec 1 US 2 3 1 values... 1 Dec 2 US 3 4 2 values... 1 Dec 3 US 4 5 3 values... 1 Dec 4 US 5 6 4 values... 2 Dec 1 US 7 8 5 values... 2 Dec 2 US 8 9 6 values... 2 Dec 3 US 9 10 7 values... 2 Dec 4 US 10 11 8 values... Table2 _ LatestPrice Fields and Data SId Country Price High Low ........ 1 US 1 2 1 values... 2 US 1 2 1 values... 3 US 1 2 1 values... 4 US 1 2 1 values... I want to update the LatestPrice table data on the base of field SID and Country from History table data.Here i pick the only highest date data from History table. Now i want to update data in LatestPrice table. so there are two approaches One way is the pick one by one record from resultset and update the LatestPrice on the base of field SID and Country. so there are mulitple queries depends on the no. of records in resultset Other way is write singe query in this way that they find automatically SId and Country and update the data. So i was unable to write single query for update the Data. Please suggest that how can i do this taks any help will be appreciated

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

There is a sub menu Publish in Build Menu of Visula studio

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Hi All, Can anyone help me out to find any free dll for asymmetric encryption for larger (non plain text like zip files, pdf's etc.) data. Currently availble classes in .NET for asymetric encryption is limited to plain text ( not more than 100 bytes) data only. My need is to encrypt/decrypt larger zip(of pdf fies) data in Asymmetric method. Any suggestions is appreciated. Thanks

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

hi all, i want to build a query but not succesful i have two table named A and B A table has field id(N), title(Varchar) B table has field mid(N), id(N) so i want to id, title from A table and count of id from B table let me explain with data Table A data

1 title1
2 title2
3 title3

Table B data

1 1
2 1
3 1
4 1
5 2
6 2
7 2
8 3
9 3

so i want to following result

id title count
1 title1 4
2 title2 3
3 title3 2

Please suggest how can build this query?

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

hi all, i want to restart the Window mobile after the successfully installation of my application. For install the application, i create the cab file which install the application on device. this cab works well. but i also want to restart the system so Please suggest how can i restart the device. any sample source code or link is greatly appreciated

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) Company - ISOL, India Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

hi all, i am creating a outlook plugIn . i sent a mail with Read Receipt property (using MailItem.ReadReceiptRequested=True). so whenever a new item come in Inbox, then how can i identify that this is mail or receipt?

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Sujit Mandal wrote:

1.where the mdf file located(is there any folder which is contain .mdf)

mdf and ldf file is located on shared folder (for example c:\abc or E:\abc) folder abc is shared which i create programmatically

Sujit Mandal wrote:

2.when u r creating .bkp file always use overwrite existing file option.

i already check whether there are any file with same name. if yes, then first remove it and after that i create backup file

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

hi all, in my application, i use MSSQL express 2005 as backend. when i create backup file from one server (say A) and restore it on same server (A), then it works well. but if i restore the Backup file of Server A to another server (say B), then it give error as following "The Backup set Holds a backup of a database other than the existing 'DatabaseName' database. RESTORE DATABASE is terminating abnormally." on both server instance name and database name is same please suggest how can i resolve this error

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

try following Dim QueryText As String dim fieldName as string ="Field1" Dim command As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand() QueryText ="delete from table where @field is NULL" command.CommandText = QueryText command.Parameters.Add("@field", SqlDbType.Varchar, fieldName.length).Value = fieldName

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Paramu1973 wrote:

Dim Save_3 As String = "Delete from gnlmst where gnl_code is null"

whether you try like following Dim Save_3 As String = "Delete from gnlmst where @gnl_code is NULL" DAD.DeleteCommand = New SqlCommand(Save_3, con) With DAD.DeleteCommand.Parameters Add("@gnl_code", SqlDbType.VarChar, 50).Value = "gnl_code" End With

rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

hi all, i want to import contact list from Gmail,Yahoo or Hotmail which is provided with email and password . i know there are such a method since i see this functionality in different sites. can anybody provide me some code snippet or useful link

Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

first of all many many thanks. 5 from me and sorry for late reply since i am busy with some other project.so i do not reply you This query works well. one more thing whether you have any idea of SQLite. since i just check and run this query in sqlite. but i don't know the syntax which is similar to above syntax (as you suggest)

Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11