*&^%$#@. thanks! can't seem to count today:)

Try using just the server IP instead of name from the client. If that doesn't work - try a regular ping from the client to the server.

I still didn't...

Marcus Farrugia (10/10/2007)

---

lol...tell me what you really think. the 'or's' apply to the conditions within the bracketed statement, not to the whole where clause. except for the npa...

don't forgetting indexing (a strong + for #2). you'd be relegated to row scans/table scans to find the ones you want (for a where clause, for ordering, etc....)

Finally -...

Also - your "multiple UI version" argues for separate databases if the version change requires a change to the DDL.

I also don't like being on WHERE clause away...

You always connect to an instance - it's a matter of whether you've made a NAMED instance or not. You should be able connect to either

If you have a firewall...

Difference in behavior. Access displays data the instant it has enough to fill one screen; SQL QA waits to have the WHOLE thing.

Try hitting the "scroll to the end"...

Carla Wilson (10/10/2007)

---

A few months ago, President Bush said he wanted to reduce fossil fuel consumption by 20%. That could be easy - work from home just one day...

Assuming you handle the nulls correctly (meaning the fields actually HAVE a value and it's a valid value), you could also try this one on:

...

select dateadd(dd,daypublished-1,dateadd(mm,monthpublished-1,dateadd(yy,yearpublished-1900,0)) as fulldatetime

...

When built right in the right circumstances, CLR functions perform very well (better than UDF's for that matter). Just about anything string-related (rising to the level of requiring a...

This was a recent hot topic - take a look here:

http://www.sqlservercentral.com/Forums/Topic403180-338-1.aspx

For what it's worth - not sure what's causing your overflow error (unless there's a divide by 0 erro going...

Maybe the caffeine just wore off - but why are you adding up increments of 100?

....

sum(Case when Answer=1 then 100.0 else 0 end),

....

Be careful with developing apps with developer edition. MS was very tricky there, since it's got all options turned ON (it's essentially a clone of enterprise edition). It...

Kenneth Wilhelmsson (10/10/2007)

---

I'm not sure I'm getting what the real problem is, but... it seems to be about ordering...?

That is, the problem is that a given order is expected, and...

The better way will likely be to pull the .lowpart and .highpart separately. Also - are you trying to convert it to bigint or datetime?

SQL datetime doesn't deal in...