certainly possible, but you need to generate a list of all possible dates;

A Tally Table is one of the easiest ways to do that;

here's just one way to do it:

create...

a parameter declared like DECLARE @var NVARCHAR or DECLARE @var2 VARCHAR has a size of ONE character...I think that's what Phil is going after...bad definition in the Stored procedure.

you would...

ok i just tested this, but i made some assumptions;

when you say "

I THINK you are saying "If I pass this string 'd;c;b;a;e', i want the companies ordered in that...

saifulislam6720 (3/1/2013)

---

Hello Guys i think that If you want to see, at the time if someone is signed in twice and obtaining the same information look at the hosting server...

Oh yea,the only guys that remember it all, i...

Sigerson (3/1/2013)

---

This is a related question, hoping someone on this thread can answer it.

I've had a working bcp process for months that creates a CSV file on a network drive....

Great job on supplying the DDL and Sample data;

probably a copy paste error, but two of the dates have the month "22", so i couldn't get it loaded all teh...

Raghunath Garlapati (2/28/2013)

---

Thanks for your reply!!!

We have around 1500 tables and 15000 columns. My concern is not about the increase in DB size(memory).

I am more interested to know that...

extended properties don't have any significant impact on the database size; it's not describing per-row data, but rather schema data.

the other thing to remember is that objects that are not...

The query you posted is using the same index stats to determine when the LAST time a table was accessed. you had asked for the most frequently used, which my...

something like this seems pretty close for a fast query:

SELECT

DB_NAME(database_id) AS TheDatabase,

OBJECT_NAME(object_id,database_id) As TheTableName,

SUM(user_seeks) AS user_seeks,

SUM(user_scans) AS user_scans,

SUM(user_lookups) AS user_lookups,

...

Steve Jones - SSC Editor (2/27/2013)

---

Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across this:...

or did you mean the last non-null column, regardless of the datetime value? my example above finds the highest date, regardless of which column.

in that case, assuming your app files...

great job on giving us the setup DDL and Data.

Your data has all the same datetimes, so it'll probably look better when you compare the example with real data.

this seems...

wow save that 35K for bonuses!

my first link for creating a free VPN between networks:

http://www.wikihow.com/Set-Up-a-Virtual-Private-Network-with-Windows

another possibility might include secure FTP to throw files on endpoints accessible to both servers.