here's my best guess; I had trouble identifying what is supposed to be the A alias, especially since it seems to appear twice.

SELECT

JOB.EMPLID,

JOB.FILE_NBR,

PER.NAME,

...

VIEW ANY DEFINITION would give them the ability to see proc code, but not edit it; here's some examples: you can also do it to a specific schema, so...

I'm a little weak on the UPDATE function, but i thought that if the column is included in the update statement, even if it is still the same value, the...

CLR is much faster with string manipulations. there are some things that cannot be done in TSQL

Regular expressions is one of the most common example, where it cannot be done...

gotcha...so you want to kill their connection if they use your the logon designated for your application and SQL Server Management Studio(or anything except your application:

the if statement would look...

you didn't quite post enough information...

you said Say that the user enters 'a a m' as the search terms. Given the following two simplified tables, how do I select Michael...

checkai (1/19/2010)

---

We have user names for applications that have higher security than we want our developers to have. However, the developers need the pwd to put into their apps to...

can you have each process add a variable to the procedure call? or at least one of them? they can discover which process from a parameter, but not really from...

So true!

by the time you take the time...

I use a case just like Lutz suggested; only difference is depending on what the data is capturing, I have a cut off date, so i don't accept dates...

there is a suite of views that you can search the "definition" column from,

for example this might get you started:

select *

from sys.all_sql_modules

where definition like '%myTableName%'

you can use this view...

its variable scope;

anything like variables or temp tables created during the execution of a stored procedure do not exist outside of the proc...that's why you can call the same proc...

there are prettier ways to do this, but does this give you some ideas?

DELETE FROM MyTable

WHERE orderid IN(SELECT orderID From Table1 WHERE orderID IS NOT...

this works with the example data you posted; dunno about the data types, but the code works:

==edit i built this based on the first psuedocode, you posted again prior to...

alex the logic is in your cursor; if you are doing something to one row, you can do the same thing to multiple rows; somewhere int here you've got what...