assuming your Transactions table has a column named [TransactionDate], and that date represents the date you are looking for, this query will

get all transactions from midnight until the second...

Visual Studio can create a cache file for reports , so it skips getting the data from the server during a report preview. if the data changed, or the cache...

additionally, how about a scheduled job that looks for more than one post per second per user, and deletes the ones that were spammed based on that criteria?

phingers (9/19/2014)

---

unfortunately it could be someone who logs in under the same credentials as me.

The db mail idea is good, although in the same way as disabling the...

i had to do something similar, where the Visual Studio Project was deleted on a developers machine. The RDL's and all the data sources etc are stored in the...

well i know how to get the order of dependencies : if you limit the results to just Tables, that is the order of foreign key hierarchys...but then you have...

my powershells cript has similarities, butis a little different on that like for .Fill;

i don't have void or[void] anywhere.

i'm also filling a dataset, and not a datatable.

$SQLDataSet = New-Object System.Data.DataSet;

$SqlDataAdapter.Fill($SQLDataSet,...

since it's a named instance, i think it might be a SQL express instance...which has TCP/IP disabled by default.

do you know if it's an express instance?

if it is, first you...

i use CLR extensively, and for a lot of different reasons.

Here's a list of the things i use it for: