>>For those of you working/have worked as a DBA or SQL developer, what are the most crucial technologies to learn?

If you are in a small shop I would say data...

Hmmm.... I'll give it a shot and report back. I'm really looking for the type of display where there is a circle with an embedded letter, similar to @ but...

>>I think I understand the problem now. He wants the [Sort] columns for all rows with a number equal to or greater to the "moved" row to be incremented.

...

I believe the OP is looking for an Update statement of the 'Sort' column in his table, not delete/inserts. So the physical order wouldn't matter, only the value of the...

Oh sorry I see the distinction. The interface is not sending back the entire dataset with the new rankings but instead just the 'changes'.

Sounds like an interface issue not a tsql issue if I am understanding correctly, that is, allow a user to re-order a list and then save the new order back...

Or COALESCE

SELECT COALESCE(SUM(SomeValue),0) FROM

http://databases.aspfaq.com/database/coalesce-vs-isnull-sql.html

I would consider SSRS to be a front-end/application. It allows the users to interact.

Read up on parameters:

http://msdn.microsoft.com/en-us/library/dd220464.aspx

Look at the dynamic data source bit here:

http://msdn.microsoft.com/en-us/library/ms156018.aspx

This also looks...

Read this thread.

http://stackoverflow.com/questions/3943823/sql-server-how-to-get-a-database-name-as-a-parameter-in-a-stored-procedure

>>First step is to create drop down menu for

You need some type of application/front-end to create drop down lists.

If you had an application the drop...

Oh a WAN, then linked tables and bound forms is not the way to go. Shouldn't be a problem on a solid LAN but a WAN changes the whole conversation.

Yeah, I wouldn't over think it. Use linked tables and bound forms for data entry.

For reporting you could look at executing stored procedures.

I would also consider DSN less connections.

>>but...

Depends on how the report is setup.

The credentials can be embedded in the crystal report in which case he just needs to be able to access the interface where he...

Did you put an index on AW_POST_DATE before you changed your query? If the field is indexed and you are querying from it I'm surprised there wasn't improvement.

Do you control the load of the data? How is it done?

I would start be analyzing your data, MAX and LEN would tell you the most characters a particular field.

Then...

Getting

"A remote table cannot be used as a DML target in a statement which includes an OUTPUT clause or a nested DML statement."

INSERT INTO DataUpdateCapture (mydate)

SELECT * FROM

(

INSERT...