Or - design a SSIS package which will accept a dynamic parameter. As described here:

http://www.mssqltips.com/tip.asp?tip=1395

I use this in conjunction with very simplistic VB form apps, so that you can...

Keep in mind that the different placement would create altogether different query results in an OUTER JOIN scenario.

Jon Heck (4/2/2008)

---

I was contacted today by a staffing agency and was told that I looked like a good fit for a Data Analyst position. The agency and wanted...

peter.anderson (4/3/2008)

---

Hi,

We have a system that generates automatic letters for clients, with an entry in the database for each letter, with a unique letter ID - the PK (not an...

Lynn Pettis (4/3/2008)

---

Well, that last bit of info may be a bit old, but it was valid at my last employer. The reports were run on an automated schedule...

ramadesai108 (4/3/2008)

---

Keith,

Like I wrote earlier, if I fill the primary key column in the grid and then click on row above of below the current row...

Lynn Pettis (4/3/2008)

---

I also think it depends on the type of reports created as well. If the reports used by users are static, you may not need to count...

ALZDBA (4/3/2008)

---

Well, in case of large data-transfer I especialy would dislike using the clr.

Your sqlserver instance is at risk !

Check my reply on Jeff's article "Solving the "Running Total" &...

delta dirac (4/3/2008)

---

many thanks for all the answerers ,

but ,,,, as an advanced database file (the sql i mean) was it too hard to protect it like a box or...

Nick123 (4/3/2008)

---

Hi,

Please let me clear my existing set up and further requirements.

1.Sorry I have SQL server 2005 standard edition not Enterprise edition.

2.Our currenct production server have 4 processors.

3.Other server where...

Also - just to avoid recursive trigger calls - (stealing Andras' code)

CREATE TRIGGER [dbo].[Trigger_tbl_Process_Constants] ON dbo.tbl_Process_Constants

FOR UPDATE

AS

BEGIN

IF not(update(Date_Modified))

...

meaning....

update tableA

Set colA=Summary.Total

from TableA

inner join (select grpID, sum(amount) Total from TableB group by Grpid) Summary

where

TableA.ID=Summary.GrpID

...

Your aggregate calculation will need to be a separate sub-query. The aggregation operation itself can't be visible at the top level, or the data set will not be updateable...

Jeff Moden (4/3/2008)

---

Portability? Have you ever tried to make 100% portable code and still have it actually do something more than return data to a GUI with simple SELECTs?...

That might be an interesting challenge. Unless my memory is failing me - prior to SP2, Reporting services was a premium feature (meaning - you had to pay for...