Oops, I should have...

Go here: http://www.microsoft.com/sql/technologies/security/default.mspx

Dugi (3/28/2008)

---

I have the table with over 1 500 000 records and I want to update this table just in one column and I will write the original code what...

I haven't done Access in years, however, I believe that combining COUNT, IIF and NULL's could work for you. Try something like this:

SELECT Field4

, COUNT(TATCal)...

Maybe someone has setup one of those function key macros? I don't really know how that's done, so maybe someone who does can jump in?

that is true, but your will note that the title of the forum group is "SQL Server 2005". There is a different...

Adam Haines (3/27/2008)

---

I feel obliged, for the sake of accuracy, to point out that although your co-workers steps for adding a column to a table bear an eerie similarity to...

I'm not to good with the XML tricks myself. Here's another way to do it:

Instead of:

[font="Courier New"](Select Col1 from Table1 Where {conditions}) as Col_A[/font]

Try:

[font="Courier New"](Select Min(Col1) from Table1...

Let us know how it works.

Write your own stored procedure that does both. Call that procedure.

Process Explorer - free tool from Microsoft.

Kevin Durham (3/27/2008)

---

Someone has written a sproc that outputs a CHAR(22) value, called a ControlNumber, that is the result of concatenating several integers together (the first and last are NEVER...

K. Brian Kelley (3/27/2008)

---

The problem isn't price. It's...

Thanks, Chirag.

Write the INSERT like so:

[font="Courier New"]INSERT...