wujtehacjusz

Whole point of normalisation is to never have tables like this... Don't think that it is possible to do this in SQL unless you know what is maximal number of remarks for a schedule (ie. not greater than 3). If this is true you can do a series of inserts …

Why would you want to load that much data? c# is not suited to handle this amounts of data. What kind of processing you want to do on this dataset? Maybe it can be done in T-SQL? Btw. it is probably wrong forum for this kind of question.

Yes it is possible. You can use ASP to do this. You can find more info here [url]http://www.plus2net.com/asp-tutorial/db-mssqlconn.php[/url]

If you have all this stuff in a table try: [code=sql] select '"'+name+'",' from ATABLE [/code]

You can always use join two tables using row_number()...

SOlving question asked by yourself? Odd...

Join the result of the query [code]SELECT min(Time),[Special Number] FROM table GROUP By [Special Number] [/code] with the original table. Something like this could work: [code]select t1.*, table.speed, table.power from ( [INDENT]SELECT min(Time) as Time,[Special Number] FROM table GROUP By [Special Number] [/INDENT] ) t1 inner join table t on …

Your table must have a primary key... use this to delete that required row. The row number will change depending on which column you order your table. Say that you have a table with id as primary key and date (you order your records according to date). You want to …

I think that you need to join query one with query two... try: [ICODE] SELECT t1.*, t2.actualVisits FROM ( [INDENT]SELECT hourStamp, SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage, SUM(CASE WHEN dateStamp BETWEEN DATEADD(d,DATEDIFF(d,0,GETDATE()),0) AND GETDATE() THEN 1 ELSE 0 END) as HourToday FROM …

You will need to be able to order the data in some way. Say you have a table T storing people birthdays with two following columns: personId, birthdayDate. To delete 5 top rows from that table you could do [CODE=sql]delete from T where personId in (select top 5 personId from …

It will work fine as long as one of the numbers in division is a float or similar. Try [code=SQL] select (cast(50 as float)/100)[/code] This will work with any numeric data.

Netbeans - it has everything you will ever need...

Hi! I have a problem with Dijkstar algorithm. At my university I was told that to use this algorithm I have to have: [LIST] [*]array of distances from starting node to all unreached nodes going only via node in set reached. [*]set of reached nodes (I pressume that it would …