Database

Cant you just use ID in the record from table itself? Coding C# ExciteTemplate

I came across Magic Software back in the early 90's, I have to say (at the time) it was very inmpressive but too expensive for the company I was employed by at the time. I haven't come across it since, so I assumed like many other companies, it had gone under. Great product, dodgy name :) Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

What happenned to your migrate from Access to SQL - what you are trying is not the best way of doing it. If you assume that SQL Server can read a datatable written as an xml file you could read the table into the client C# and wtrite it out using datatable.writexml(filename)

I would help but I have never used MSDE, isn't this a forerunner to sql server express? Looks like some likely responses with this search[^]

Start 'SQL Server Enterprise Manager" Right click on your server and choose properties Select the Security tab and do you configuration. Wout Louwers

Size is the size of mdf and ldf file in 8K pages. Divide the value by 128 to get the size in MB. It might come same with/without data depending upon the amount of data your DB holds. It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

This is how it is being done in sql server 2000.first from enterprise manager right click on the database. 2)choose new database and create a new database with the name of your sql server database. 3)Right click on the new database created and from tasks choose import data. 4)A dialog box will appear.you have to specify the datasource there,which is microsoft access in your case.Then just follow the instructions and you will get your database migrated.

General form: update TABLENAME set FIELDNAME = VALUE where WHERECLAUSE eg: update tblEmployeeOvertime set Overtime = Overtime + 2 where Emp_ID = 1 I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

Mycroft Holmes wrote: decant database platform Is that one that you pour from a bottle? rofl... I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

ap·pend [ ə pénd ] (past and past participle ap·pend·ed, present participle ap·pend·ing, 3rd person present singular ap·pends) transitive verb Definition: 1. add extra information: to add extra information to something, especially to a document 2. add authorized signature: to add an authorized signature to a bill or an official agreement as a final part of the ratification or agreement process ( formal ) All principals to the sale must append their signatures. 3. attach something: to attach or fasten something to something else [Mid-17th century. < Latin appendere "hang upon" < pendere "hang"] No, you will not have duplicate records unless your database does. "My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

_Damian S_ wrote: Whether there is anything else wrong time will tell :laugh: "My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

Mustafa Ismail Mustafa wrote: appealing Appealing AAAaahhhh runs screaming from the room Appart from the fact that I don't think express supports linked servers, maitaining and deploying the solution would be plain nasty. Go for the addition thread doing the write back.

For years I used the same sort of thing, then I went to where IsNull(@StudentID,StudentID ) = StudentID but apparently COALESCE is preferable to isnull - not sure why in this instance. Its certainly good where you have several possible values, such as select coalesce(val1,val2,val3) as mainvalue Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Assuming that it was a typo (which it must be since there was no option for "this is crap and if I can't pick this error up I shouldn't be using SQL"), then answer E is correct. I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

Try posting your code and connection string.

Thank You Have a nice day

I don't think I can help you. I'm not experienced with SQL Report. I'm much better at Crystal Report in Visual Studio 2005 Professional.

And just using MAX doesn't work? SELECT A.BILL, A.BILLER, MAX(A.VERSION_NO) AS VERSION_NO, A.CODE, A.NAME,A.SEGMENT_CODE, A.COMMENT,B.BILL AS BILL, B.BILLER AS DW_BILLER, B.MCN AS DW_MCN, B.SO AS DW_SO, B.BG AS DW_BG, B.CODE AS DW_CODE, B.NAME AS DW_NAME,B.SEGMENT_CODE AS DW_SEGMENT_CODE FROM WEB_REF A, WEB_CUST B WHERE A.BILL=B.BILL AND A.BILLER=B.BILLER ORDER BY A.BILL My advice is free, and you may get what you paid for.