Monty

Glad you were able to fix it as I still haven't found what I was looking for.

There is more to what you are asking that you haven't told us. If two processes are attempting to update the same record, you should get one process being...

First, you should know by now what you need to post and how to post it. If not, read the first article I reference below in my signature block.

That...

SQLRNNR (8/7/2012)

---

Lynn Pettis (8/7/2012)

---

I don't know, but I'm really getting tired of questions wanting answers but not getting enough information to for me to even start to give a decent...

I don't know, but I'm really getting tired of questions wanting answers but not getting enough information to for me to even start to give a decent answer. And...

gerard-593414 (8/7/2012)

---

Hy Lynn. Thanks for replying.

The sample I gave ws just a very simple sample to illustrate the error.

There are in fact 8 parameters input as :

@Type, @WhichFieldQuery,@CustomerFrom, @CustomerTo, @TranFrom,@TranTo,...

Gianluca Sartori (8/7/2012)

---

A sliding window partitioning strategy could help here.

Dan Guzman has a couple of nice posts on the subject:

http://weblogs.sqlteam.com/DANG/archive/2008/08/30/Sliding-Window-Table-Partitioning.aspx

http://weblogs.sqlteam.com/dang/archive/2008/09.aspx

Setting up the partition scheme and rebuilding your indexes on the...

Does it matter who is using which workstation?

chaitukadivella (8/7/2012)

---

This works fine when the table is in default schema that is dbo. Can you specify how we can make this query work when the table is in some...

chaitukadivella (8/7/2012)

---

This works fine when the table is in default schema that is dbo. Can you specify how we can make this query work when the table is in some...

Also, computing date ranges becomes easier if you use a closed end comparision on the lower end and an open end comparision on the upper end.

For example, you want all...

Mohammedr_mcts (8/7/2012)

---

Hi,

When SQL Server 2000 and SQL Server 2005 clients request SQL Server resources on a named instance, the client network library sends a UDP message to the server using...

I'd have to say enlisted. At a previous employer we were looking at new technologies in an effort to replace a COBOL/ISAM based application (that application is still...

Something like this?

with SampleData as ( -- this cte simply provides the sample data for the query

select

strval

from

(values ('0008.22816'),('069.3142'))dt(strval))

select

strval,

...