There is no build in function that will encrypt data values.

This will be a large benefit for using managed code in sql 2005, but not available in sql out of...

No, there is no "Empty" value for a date in sql.

Null means not available, or not defined.

If you do not allow NULLS, then you must supply a date.

You can set...

Null in sql server is a "Special" Value,

Null means there is no value, Text files do not have this "Special" value. Sql has to represent it with "" blank string....

for the last year of records

Select OrderDate , OrderNumber , CustomerID , ItemID , SalesQty

From Order

Where OrderDate >= dateadd(yy,-1,getdate())

This pulls all records from exacly 1 year ago til now.

If you...

I was merely showing all date related functions from Books Online

I just pasted them in the thread.

The Capital "N" Before a string indicates the string is "Double Byte" Nvarchar, NChar, NText

The table structure is fine, but can you supply some sample data, and what your expected output is?

Seems to me you could perform a union. Calculate the default rate hours...

Can you please elaborate?

It will depend on what you want, calendar year to date, number of days

select datediff(dd, '01/01/2005', getdate())

The only date functions are.

Function Description Example

DATEDIFF( ) Calculates an...

You can set up a profiler trace watching only stored procedures, with results to table, then you can query the table. There is a small amount of overhead having this task...

To do this you must use sp_executesql

use pubs

declare @sql nvarchar(100),

@Table varchar(30),

@Output int

set @Table = 'authors'

set @sql = 'select @output = count(*) from ' + @Table

exec sp_executesql @sql,

Without knowing your entity definitions, or the relationships it is hard to say. As rgR'us notes you probably do not need the owner in table1.

Left my wallet in El...

I understand the need for a one size fits all view, but one of this size with all the left joins is definatelly not going to help performance. You'll find...

Install sql server client tools.! On sql serever installation CD. DOn't chose install server, select client tools only.

No license required (I Think)

What is the data type of your identity?

if its an integer than the max value is over 2 billion

That will take a long time to run out of numbers, even...

You cannot maintain this value thru a default.

If the value is used for sorting, then why must the item be sequential?

Thats fine if its a requirement, but requirements should tell...