you'll have to decide which photo to choose. for the example below, i chose the photo with the highest ID value.

select PR.*, PH.*

from utbProduct PR

...

you'll either have to use the report viewer control in your own app, or create a custom control to be used to present/collect the date parameters.

you'll have to specify a fixed number of locations. otherwise, you're trying to write a query that may have 8 columns sometimes...

although you may no like them, seperate logins are a simple solution to this problem. give them all the same passwod and let your app connect as the company's...

C D Brinkerhoff (5/8/2008)

---

Figured it out ....

IF EXISTS (SELECT creatorid FROM Inserted WHERE creatorid IS NOT NULL)

BEGIN

IF NOT EXISTS (SELECT 1 FROM Inserted AS i JOIN dbo.Users...

access supports vb functions like iif() in queries. so, you'll have to rewrite them as transact-sql.

you should consider adding those two columns to the table and creating a trigger to automatically calculate them. as your data grows, a query that calculates mileage and time...

BIDS aka Biz Intel Design Studio (when I'm too lazy to type) aka SQL Server Business Intelligence Design Studio is included with SQL Server and built on Visual Studio 2005....

at first glance, i don't think you need dynamic sql. try something like this:

CREATE FUNCTION fnGetBoColumns

(

@in_txnidvarchar(50),

@in_bo_namevarchar(255)

)

RETURNS

@tblBoColumns TABLE

(

[tnxid]nvarchar(50),

[bo]nvarchar(255),

[column]nvarchar(1000)

)

AS

BEGIN

...

placing the proc in a common database and qualifying the db name (exec common..proc) would achieve the same result without the drawbacks of having the proc in master.

user defined procs in master. ewww!

if you're using Biz Intel Design Studio, it should detect the @tg-2 parameter and create a corresponding tg report parameter. but, i've noticed that sometimes it can get confused.

edit...

this should get you started:

select

[Unique Code], [Date],

min(case when [Product Type] like '%Property%'

then [Premium] end) as [P&C Premium],

...

Reporting Services Scripter (RSScripter) is the best and most flexible tool to use.

http://www.sqldbatips.com/showarticle.asp?ID=62

http://www.sqldbatips.com/samples/code/RSScripter/readme.htm

select (quarter - 1) / 2 as half,

cast(min(quarter) as char(1)) +'-'+ cast(max(quarter) as char(1)),

sum(people)

from your_table

group by (quarter - 1) / 2)