I haven't really used them myself, but I'm wondering if this is a case to use the "with cube" or "with rollup" features. Can anyone else provide some more insight...

Yeah, I know it won't work with multiple days, which is why I said "Add some date filters". I should mention adding group bys as well. This was just some...

I'd take a different approach

use test

go

Create Table Punches(empid int, time_in Datetime, time_out datetime)

insert INTO Punches(empid, time_in, time_out)

Select 1, '3/10/2008 08:00 AM', '3/10/2008 10:00 AM' union all

Select 1, '3/10/2008 10:15 AM',...

I'm not sure this is possible without a timeout. You'll notice that if you put an invalid server name into a connection string builder dialog box, you'll wait for some...

My thought is the less processing the better. I'd leave the files in the directory structure as is, but only store the path to the image in the DB. then,...

I script them to a text file and press Ctrl+F

When you select all raw data in your table, do you have any null values in either Miles_Total or Gallons_FillUp fields? if so, remember that NULL values propagate. IOW,...

Lets say your statuses are single character.

Lets also say that your valid statuses are A, B, C, and D

You could pass in a single varchar variable with the ones...

you've got several options for numeric data types:

tinyint, smallint, int, bigint.

Look them up in the docs to see what ranges of numbers they hold to make the best decision.

you'll need a sqlconnection and sqlcommand object. You may add parameters to the sqlcommand object to get data in, and you can retrieve results into either a dataset or...

Any code samples?

Part of the problem is that Excel insists on deleting leading zeros for you.

I found a workaround here:

The solution is to create a file with a .csv extension, and format...

If you try to manually type that value into an open Excel spreadsheet, you'll see the same behavior. Excel interprets it as a number, so it truncates the leading zeroes....

SQL Server will generate these for your field and table names just in case they contain an invalid character.

For example, your table name can contain spaces (IMHO a ver bad...

Hmmm...first of all, you are posting a question in a SQL SERVER message board, which is completely different from Visual Studio 2008. A quick google search for "VB.NET tutorial" turns...