Database

SELECT `RegNo`, Marks, @Position + 1 AS Position FROM results , (SELECT @Position:= 0) r ORDER BY Marks desc; It just needs that simple modification only

The number of accounts an agent may have is allocated by a manager, thus the table #MyTestCounts. Mongo: Mongo only pawn... in game of life.

MFC can use ODBC data sources: https://msdn.microsoft.com/en-us/library/w2c4cthk.aspx[^] MySQL has ODBC drivers for C++ (good for MFC): http://dev.mysql.com/downloads/connector/cpp/[^] What else you need? Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

If you can write a query to select the results, then it should be easy to get them in a new table. Right now, there are a few fields lacking - how would you know which student took which exam? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

A small note after some further research: There is an add-in to Visual Studio called "SQL Server Compact/SQLite Toolbox" which give you som really nice tools for working with those databases from within Visual Studio. One of those features is to update the SQL Server CE database from v.3.5 to v.4.0.

Proceed accordingly then ;) and best of luck.

You are correct, but still it wont work like that. Something was missing and after analasys I saw that the Start_Date field wasn't NULL but just empty. So this is what I changed to make it work: ,Datediff(SECOND, convert(datetime, ISNULL( NULLIF([START_DATE], '' ) , END_DATE) + ' ' + ISNULL( NULLIF([START_TIME], '' ) , END_TIME)), convert(datetime, [END_DATE] + ' ' + [END_TIME])) AS M_Time_Worked A big thank's to all for helping me and the responses where I learned from. Kind regards, Ambertje

Documentation[^]. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Help you with what, you have not asked a question?

There are multiple ways to do it. i would suggest you should review your data to identify how many other invalid characters you have after this just use the simple REPLACE() function to remove those. Furthermore, if you are planing to create a function for this then you can look into this Link. hope it helps.

If you are using SQL SERVER 2012 then what do you say about using File Table

Hello, I don't think it will allow you to change Computer column expression on the Fly... Instead add new column with new expression and name it as newColumn. Delete you old column and then rename newColumn to Original column name using below command. sp_RENAME 'Table_First.newColumn', 'YourOriginalColumnName' , 'COLUMN'

Please post only in English in these forums.

Change the single quote ' to an asterisk * in the count functions. eg count(*) Never underestimate the power of human stupidity RAH

Which part? There is no separate set of commands that work on "all" versions. You'll have to find the part that is deprecated and find some replacement. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

It all depends on the UI, aspx you would need to use javascript to get the modified sequence and pass it back to the server, that is what the asp forum is for. For desktop or silverlight UI you use the underlying collection to determine the sequence and write that to the database. This is not really a database problem but should have been asked in one of the UI forums for a better response. And coming to a database forum and asking for c# code is rather silly! Never underestimate the power of human stupidity RAH