Recent content by CTl06

I use sql 2005 and identifer that make records in group is other field Recordid SartDate EndDate Id 1 01/01/2010 01/02/2010 10 2 01/02/2010 01/05/2010 10 3 01/02/010 01/06/2010 10 -- Correct start dt is recordid 2 enddate 4...

Borissov, Sorry, I did not mean to say that the RecordId is always requence.. The record id is identity seed but not all the group of records with bad date happen in the sequence.. for example: 1 01/01/2010 01/02/2010 100 01/02/2010 01/05/2010--correct date is start date...

bborissov, Most of the time record enddate is incorrect and yes there is always a recordid in sequence.

Hello all, I am trying to fix data in the database that incorrect record start date and sometime having incorrect record enddate. Can you please help me what is the best way to fix this data in SQL. Here are examples of problem data. Scenario #1: Recordid SartDate EndDate 1...

Thanks for your suggestions and your help guys..

this is application custom application that we bought on from another company.. it is a piece of Junk.

George based on that query it is always give me one row. but data should always return me multiple rows example. Rowid Value 1 William 2 John 3 CA 4 89788 5 Los Angeles. 6 John 7 Doe 8 TX 9 Dallas 10 9999999 Expected results: First...

George, I know, this is database from an application that we bought on to our company.

How do I do so I can assign each value with a column it. when i run the query it will return as below First Last City State John William Los Angeles CA thanks

Hello all, I have a table with data in the format below Rowid Value 1 William 2 John 3 CA 4 89788 5 Los Angeles. What is the best way of writing aquery that flat this record out to one row. Example John William CA 89788 etc. thank you much for your help.

Hello all, I got this error from msbuild when excecute Nunit test cases, but I know why it is error out. I have no clue where to start fixing problem. Thank you much. CT Unhandled Exception: System.NullReferenceException: Object reference not set to an instance of an object. at...

KDavie how to do I check whether tcp port is listening or not? Thank you for your response.

Hello all, I am keep having this problem when hitting the Webservice from remotely. Below is my error message. I have try turn off firewall, account access but no help. Please help if you have any ideas why? TheCollectiveTest.tcLayerTests.test_DTO_AddLayer_entity : System.Net.WebException ...

there always sixty row regargless new or old. The reason I don't want to use the autofilter because I want to split into indidividual workbook. each workbook will contain 60 rows of record. i hope this makes sense.

The reason i want to chop up the data is because every sixty rows is a set of record pertain to an individual. I want to split ups so I can send it to the individual with excel spreadsheet just have their data.