Is your "timestamp column" a column with the timestamp datatype? It is simply a unique value within the database that automatically changes whenever the the row is updated. It does...

You need more details.

These appear to be basic sql questions. I recommend reading a book or taking a course.

It looks like emplID and password are the inputs to the stored procedure. You want the procedure to verify the credentials. If valid, you want the procedure to update userlogins...

You would put looping code like that into a user defined function, and be able to use it in a select statement returning many rows.

You need to refine your first question. Are you asking about implementing security, or are you asking for a query to return data for a particular person? The query is...

The forum messed up the spaces in the post; but you get the idea.

select

 replace(

  replace(

   replace(

    replace(

     'I ...

Assuming primary/unique key on UPR00100 is EmployID:

Create Trigger Tg_UpdateIndication On UPR00100

AS

IF UPDATE (LASTNAME) or update (FRSTNAME) or update(ADDERSS1) or update (CITY) or update (Phone1)

BEGIN

update UPR00100

set Update_Ind=1

from inserted

where (inserted.EmployID = UPR00100.EmployID)

END

Do you have a table listing departments for each company?

Assuming there are always 4 depts for each company as in your example:

SELECT counts.company_no, counts.dept_no, counts.count

FROM (

   SELECT dept_no =...

Generally use "is null" in a conditional.

Use isnull() to change the value from null to something else.

If null and 0 mean the same thing in your application, then isnull(@var,...

See previous thread.

I think this is a reporting issue, not a SQL issue.

Look for help with whatever tool you're using for reporting. What will be executing the two queries?

Still don't understand.

Post create table statements, insert statements to fill the tables with sample data, and what you want the table data to look like.

Your message has some ambiguities. But maybe this will get you started. I'm assuming Table2 is on the left (even) and Table1 is on the right (odd).

update Table1

set Notes =...

Do the work outside of sql server (jscript, vbscript, vb, etc.). Those languages are completely dynamic when looking at query results.

You could also use the sp_OAxxx procedures with ADO to...