Hi

Little explanation:

An UNIQUE INDEX (independent if CLUSTERED or NONCLUSTERED for the moment) is a unique key.

Simplified a table is like a list of objects. You are able to create indexes...

Hi Bob!

Thanks a lot for the English education! 🙂

Greets

Flo

Maybe it's a problem with your custom OLEDB provider "Advantage OLE DB Provider".

Did you try the Microsoft provider:

EXECUTE sp_addlinkedserver 'dbf', '', 'MSDASQL', 'dBase Files', Null, Null, 'C:\dbf Folder'

Source: http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/b67db83d-4074-4ca9-839b-a1724382b215/

Hope this...

dwierenga (4/9/2009)

---

It seems like all the function calls are a bit overkill IMO, unless I'm missing how they handle some edge-case.

A simple

ORDER BY len(column), column usually works for me...

Hi sward

The error message

Your code:

The error message...

If you want to provide a table (list) to a procedure, this will be a new feature in SSE2k8 but is not available in SSE2k5.

Further information here:

http://www.sqlservercentral.com/Forums/Topic693851-149-1.aspx

-- DELETED ---

Please no cross posts... All further posts please here:

http://www.sqlservercentral.com/Forums/Topic693903-1291-1.aspx

Search this site for "auditing triggers". Here you can find some great articles by GSquared:

http://www.sqlservercentral.com/Authors/Articles/GSquared/475322/

Greets

Flo

Hi

Use the Tally table to handle this:

DECLARE @t TABLE (Reference VARCHAR(30), PaymentDate DATETIME, Amount MONEY)

INSERT INTO @t (

Reference,

...

Gift Peddie (4/9/2009)

---

Sorry, I misunderstood you. I thought the current time-zone will be provided from client side not from server. If the client is a web application the time-zone can...

Gift Peddie (4/9/2009)

---

Timezone is based on politics so there was none in...

Jeff Moden (4/9/2009)

---

The purple "windows" that your code is in on this thread is the "old" style and it worked well especially for people to copy from. The new...

Always a good reason for a post! 😉

Try this:

ISNULL(NULLIF(PATINDEX('%[^A-Z]%', NameTrim),0), LEN(NameTrim))

which means: if...