Hey now! where the heck did THAT come from??? :hehe::w00t:

Sheesh - travel home to see the wife, and get smacked around on the boards...:)

..which would mean indexing isn't covering that ORDER...

sarchen21 (5/15/2008)

---

The triggers mentioned here is for the SQL itself.

the issue here is how to create a trigger on deletion which should add record into the temporary table which doen...

Unless 2007 has introduced something I am not aware of - Access doesn't have triggers.

1. mark the parameter as multi-valued, and DON't include an "all" in your drop down list. it will do that for you.

2. multi-valued parameters come through as comma-separated lists...

Are you logging in using Windows authentication or SQL Server auth?

If you're using SQL auth, then the BULK INSERT is run under the context of the SQL Server service account,...

Larry Kruse (5/14/2008)

---

Matt - you were pretty close, but the suggestion you offered would result in a count of 1 if there were any values in the VISA/MasterCard/GiftCard column...what I...

Loner (5/15/2008)

---

I am a contractor not the company's DBA. It is a small company helping customer to build ecommerce website. They use SQL Server to store customers' information. ...

ALZDBA (5/15/2008)

---

Did you also apply Cumulative update 5 ?

I wouldn't advise CU6 because it has some start/stop issues with SSCM

(Unless you actualy want some fixes it contains)

- Are you using...

You're getting nulls when the employee doesn't have any hours in the secondary table ps_al_chk_hrs_ern.

You need to put an isnull in the main SELECT as well....

SELECT

...

peitech (5/15/2008)

---

OK, so one can add

USE

At the top of a script and it will automatically use the DB you have specified, however, can this be extended...

Have you locked pages in memory? See this document:

http://support.microsoft.com/kb/918483

In the case above - you're calling with a value for @DayOffset (the parameter), not @days (the variable). Being a little nitpicky, but it's useful to see the difference. ...

You've defined a variable, but not a parameter (variable is internal only to the SP, Parameters pass stuff IN or OUT).

You should also avoid the * in here...

TheSQLGuru (5/15/2008)

---

Spot-on Mario!

Oh, and for this one "It's as if people naively think the tool itself will solve all their problems with no tuning necessary. I've witnessed this all too...