Gova,

Are you all set now?

Let's see... here's some nicely formed test data that Gova provided...

DECLARE @myTable TABLE

(

DataDate DATETIME,

DataVale INT

)

INSERT @myTable

SELECT '07/01/2007', 100 UNION

SELECT '07/08/2007', 120 UNION

SELECT '07/15/2007', 150 UNION

SELECT '07/22/2007', 190 UNION

SELECT '07/29/2007', 210...

Go back and look at the original post... it's all there even though there may have been a bit of confusion, at first... if it wasn't, I wouldn't have been...

Gova did all that, Lynn...   Even provided a table with data inserts..

I suppose that there wouldn't be so much overhead associated with an INSTEAD OF trigger... but, ya gotta be a bit careful how you write them (from what I understand)...

Gova...

This'll do it.  I use a Tally table (simple well indexed table of sequential numbers) for such a thing... if you don't have one, here's how to make one.  It's a...

Our DBA's took the easy way... everyone is part of a "role" and we grant privs, by table, by role.

The only problem with that is that read only tables don't...

Katie brings up a really good point and it really got me thinking about something that aggravates the hell out of me about both my peers and my subordinates...

I'm normally...

You bet... just remember that the "Simple" recovery mode will NOT allow you to recover a damaged DB to a point in time.  The only difference between the 3 recovery...

Not sure that's it, Peter... he lists

Now, what I need is the missing ranges.

1  01-Feb-2006  14-Jun-2006

2  01-Nov-2006  31-Nov-2006

2. 10-Oct-2006  31-Oct-2006

But, 01 - 30 Nov show up in both tables......

If you want to copy an entire database with all schema, keys, and data,... why not just do a restore from a backup???

>>Now, what I need is the missing ranges.

How do you figure that November 1 through 30 of 2006 is a missing date when it clearly appears in both tables for the...

>>I need a pure sql code to complete this issue

Why?

A count of rows from all the tables in a database for the year 1995...

Why?

Where are the tabs located in the text file?