Lowell (9/18/2009)

---

In my opinion, functions are OK if you are getting a single row of data. but if you are getting more than one row, a functions should be replaced...

Lynn Pettis (9/18/2009)

---

Building on this, empid isn't even in the index, so sounds like a good possibility for...

Jeff Moden (9/17/2009)

---

Matt Whitfield (9/17/2009)

---

That doesn't sound like enough time to recover from being...

If the picture is to not allow ANY server component, even local, then, no - how could SQL Server be involved?

At best you would have to use something like XML...

I am reminded something a recruiter friend mentioned to me: You need a job to find a job.

Like Gus mentioned, the first thing you should do is come to...

David.Maron (9/15/2009)

---

The problems with sourcesafe, subversion are:

1. Changes can be made outside of the source control because they are based on flat files and there is no link to the...

Use the database as it should be. Generate ALL of the MAC addresses in one shot, and assign them as needed.

From what you have listed there - looks like...

Switch to using the OUTPUT clause instead. It WILL be a single statement and won't have the vulnerabilities that @@identity has.

Insert MyTable(Mycolumns)

Output inserted.MyIdentity

select MyColumnValue

In the sense that every table should have a primary key, yes, a mapping table SHOULD have a primary key.

Whether it should be a separate column or can be implemented...

jcrawf02 (9/14/2009)

---

Kit G (9/10/2009)

---

This particular coconut/swallow reference is from Monty Python...

If I were to guess....

Karnak

I'm betting it's not so much the font itself that is unclear, as is the image saving process (which might be skewing/stretching the images to accomodate a specific size).

You may...

use testing

select 'Sam' name1, '09/10/2009 15:20:39.000' endts, 3 unk, 11024 duration

into #matt

go

;with MattCTE as (

select datediff(second,dateadd(hour,datediff(hour,0,endts),0),endts) basesecs,

dateadd(hour,datediff(hour,0,endts),0) basehour,

*

from #matt)

select

case when (duration-basesecs-(n-1)*3600)>3600 then 3600 else (duration-basesecs-(n-1)*3600) end secsspent,

dateadd(hour,(-1*n),basehour) timeslice,

endts,unk,duration from...

bob.willsie (9/10/2009)

---

Ah. Got it. Thanks Matt.

Am I correct in assuming that forcing it to be pass-thru is only useful if all the tables being joined reside on...

bob.willsie (9/10/2009)

---

Hmm. I just popped into Access 2003 opened an existing query in SQL design mode, right clicked and selected Properties. However, I don't see that anything that...