select sum case when tt.coll is null then 1 else 0 end There are many ways as we can see:^) Hear,See,Learn,Understand,Practice Many can be good,but only ONE can be the best keep practicing

You need the MS SQL server enterprise manager there you will find a tool just to import and export data for just about anything. Hear,See,Learn,Understand,Practice Many can be good,but only ONE can be the best keep practicing

There are many ways to do this. The quit and dirty would be to pass the values via sessions or thru the url string. ex. myfirstpage.aspx?mybox1=value Hear,See,Learn,Understand,Practice Many can be good,but only ONE can be the best keep practicing

First You need to create an ODBC Connection in the machine plus depending on the type of database such as Oracle, MS SqL, Teradata, Access. For Oracle systems you need the oracle client plus the proper DSN path in the oracle DSN folder. For MS SQL you need the ODBC drivers plus the PATH for the server. Hope this help. Hear,See,Learn,Understand,Practice Many can be good,but only ONE can be the best keep practicing