In Access is my guess.

GilaMonster (2/26/2009)

---

Steve Jones - Editor (2/26/2009)

---

I'm just glad we have a consistent URL and I don't need to Google for this....

I also wouldn't worry about posting a question that may have already been answered somewhere else on SSC. You will either get a direct response to your question, or...

Steve Jones - Editor (2/26/2009)

---

I'm just glad we have a consistent URL and I don't need to Google for this. Not...

This will miss records with a datetime > '2009-01-31 23:59:59.000' and < '2009-02-01 00:00:00.000'.

The upper bound of this constraint really should be [ServiceDate] < '2009-02-01 00:00:00.000'.

I think there was a little FORTRAN and GW-Basic thrown in there as well...

If you have a command-line interfface to programs like WinZip, PKZip, GZip, 7Zip; you can use an Execute Process Task in SSIS to use one of the previously mentioned programs...

This works in an environment using a case-insensitive collation:

FROM Master.dbo.SysColumns sc1,

Master.dbo.SysColumns sc2

But it will fail in an environment using...

How about something like this?

with cteStaffYear as (

select

case

when a.staff = 6 then 'EM'

...

GilaMonster (2/26/2009)

---

Each line in the stats profile corresponds to an operator in the query. If it were...

jcrawf02 (2/25/2009)

---

SET NOCOUNT OFF before your SELECT will get rid of the rows affected. Not sure about the dashes, somebody else posted about that here recently, don't know if there...

Before you continue, could you please answer Gails questions? You could be missing something very important because of tunnel vision.

For the DBA to perform most of his/her work, there are times that they need SysAdmin rights. With this, all data is accessible. What this points to is...

You know, geeks can be quite humurous. Too bad we're the only ones that seem to understand our humor! 😛

HyperBac also has a utility for creating a native backup file from its compressed and encrypted/compressed files should you need to restore a backup file to server that does not...