there may be a more streamlined way to do it, but this works:

--results:

BDayYearBegin dob ...

mostly your problem is your design is not using an identity...but it is also procedurally based, and not thinking in terms of SET based solutions.

what if i were to insert...

why are you using a GETNEWKEY functionality to generate a number for your PK column instead of allowing an identity column to generate the value for you? the identity property...

it's fairly easy; you just need to add a linked server, and then select using 4 part naming conventions:

EXEC master.dbo.sp_addlinkedserver @server = N'ANOTHERSERVER\INSTANCENAME', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'ANOTHERSERVER\INSTANCENAME', @locallogin...

crap someone else asked this exact same question a while ago and i answered it;

is this a homework question?

http://www.sqlservercentral.com/Forums/Topic968341-131-1.aspx

SQL Server thinks of arrays as tables, so it doesn't have an array data type....

to decode a string from a delimited list to a table, you can use one of...

it depends on the job. way to many reasons to fail.

a job can be poorly written, try to access databases or database objects that don't exist(anymore? maybe someone dropped a...

it's possible, but let me explain the pitfalls.

once i have a username and password with access to a database, i can use any application to get there...SSMS, a program i...

for me, the master database doesn't have anything of interest besides logins;

i would restore a master database as a user db so i could extract logins, if they were...

Without looking at your trigger, I'm thinking there may be a better or faster way to do whatever you are doing in your trigger;

if your trigger...

the database engine and a lot of the support files must be installed on the %system% drive; after installation, you can move all the mdf/ldf files(alter database with move )...

well, what is the name of the table inside the foxpro database? is it dirmsarf,...

yes that was what i was refering to, i could/should have been more precise, sorry;

with a COUNT, the OutputList has no values, select a field instead to see stuff in...

believe it or not, NOT declaring objects with 4 part naming actually increases the overhead, admittedly by a very very tiny bit; The SQL Engine has to lookup (or infer)...

Mr.SQL DBA (8/31/2010)

---

Hi SSC Experts,

From the front end application a numeric value of 10 digits with datatype varchar(max) ex:9247497829 like Phone Number

is entered by the front end user and is...