Thanks to kruti's insight, i think i see your problem.

your datasource makes no sense to anyone, so noone can really help.

I'm assuming that this is a list of names/family members,...

I may be mis-understanding the question, but INSERT is really well explained in Books On Line;

if the table exists, it simply

INSERT INTO TABLENAME(columnList)

select columnlist from someTable

to create thetable "on...

find any column that has been tied to a rule:

select

object_name(syscolumns.id) as tablename,

syscolumns.name as columnname,

object_name(syscolumns.domain) as RuleName,

syscomments.TEXT as RuleDefinition

from syscolumns

inner...

if you can make them use a stored procedure, you can use EXECUTE AS, so it runs under sa even though they invoke it;

is it more likely the users just...

the between looks fine, but the rest of your WHERE statement has me puzzled:

where delivery_date BETWEEN '04/15/2009' and '04/22/2009'

and driver = e.emp_cd

and (driver = 'ATK' or '%' =...

glad it worked for you!

I know i was surprised way back when when i found out views could be updated; I always thought of a view a s read only...

lame example, but it all works:

USE TEMPDB

CREATE TABLE MyContacts(contactid int identity(1,1) not null primary key,ContactName varchar(30),OTHERFIELD INT)

insert into MyContacts(ContactName)

SELECT 'Bugs Bunny' UNION ALL

SELECT 'Homer Simpson' UNION ALL

SELECT...

that's the point...when a view is updatable, if you update the view, you are really updating the tables underneath the view.

the view is just a stored select statement, but as...

the view itself may be updatable...

UPDATE MYVIEW SET ContactName='Bob' Where ContactId=1 And ContactName='BOBBY'

can you tell us if that works? it really depends on the view...

you cannot do that;

While some programs, like SQLPlus for Oracle, interpret certain commands to change the connection or to direct the input to a file, SSMS and Query Analyzer only...

peace2007 here is what i use.

it is a stored procedure i wrote, which creates a trace.

It creates a trace and a view in the MASTER database; it includes a...

fairly straight forward. You need to take advantage of the OUTPUT command. this simple functionality kicks butt when playing with more than one row.

build a temp table to catch the...

since you are just setting the ReportId to a string plus the autoid, you could make the column a calculated field and be done with it:

Alter Table TestingWork ADD NewReportId...

kewl; once you post the actual functions, we'll be able to help; offhand, it looks like it could be replaced with a view that joins all your columns with joins...

need more detail;

is there 24 different formulas, one for each column in your customer table, or is it the same calculation, but placed in 24 functions? show us two of...