another alternative might be

SELECT *

, ROW_NUMBER() OVER ( ORDER...

- What's the actual error message your apps receive ?

- Can it be applying win updates on a dns server ( including reboot ) somewhere in your chain causes this...

-- removed xpost notice because Steve already pointed the other thread --

Good job, Steve

Sheer luxury :Wow:

at least if you compare it to most of us :blink:

:w00t:

gary.morey (1/24/2011)

---

I have 2 tables. The first table has a SessionID and other columns. There will be multiple SessionID's with the same value in this table.

The second table has a...

A primary key _MUST_ be unique !

none of the columns can be NULLable and the combination of all columns must be unique.

Can you elaborate a bit on your "normalization criteria"...

I already had the impression such...

Grant Fritchey (1/24/2011)

---

Based on most of the comments, I'm alone on this one, but what the heck, I'll stick my neck out.

I'm not crazy about it. I don't like the...

books online topic "FROM (Transact-SQL) " states

[ FROM { <table_source> } [ ,...n ] ]

<table_source> ::=

{

table_or_view_name [ [ AS ]...

please adjust your size settings and preview the result before posting:crazy:

enjoying star wars episodeIII for the moment. scene = the assembly of darth vader :w00t:

Michael Valentine Jones (1/21/2011)

---

I think the big mistake that beginners make with triggers is using them at all. They see them as a sort of event driven solution, and...

Lutz covered it perfectly :w00t:

Further info can be found in books online topic "Using Table Aliases"

Just assign an alias to your nested query expression and it will be OK

select count (*) from

(select codaux,nomaux from aqua.softland.cwtauxi

except

select codaux,nomaux from 0718.softland.cwtauxi) as x

- why all your columns by default should be NOT NULL ! unless you really really really need to know no value has been provided (and the datatype default doesn't...