pefrect. that worked fine. thanks

OK

i have created the linked servers on the server (SQL2005) and the links work fine. I am using Express 2005 where the links did work but no longer work. I've...

this works perfectly thanks

thanks

however, i need it to be dynamic so it runs on the first of every month. it's only an issue when its a new year.

Phil Parkin (12/3/2011)

Yes, if there exists a user with sufficient...

thanks both. i now understand update() and columns_update()

I found/modified this script which does the job...almost.

--

--DROP TRIGGER tr_SalesHistory

CREATE TRIGGER tr_SalesHistory ON SalesHistory

FOR UPDATE, INSERT

AS

BEGIN

DECLARE...

thanks that worked great.

following on from that (maybe a new post?) can i return the column name that was updated?

thanks

ok, think i've sussed it.

I switched the section..

IF (SELECT count(StockCode) FROM inserted i WHERE StockCode LIKE 'Y%') >= 1

SET NOCOUNT ON

BEGIN

...to be....

IF (SELECT count(StockCode) FROM inserted i...

my laughing gland has burst and i can see a long stint in intensive care ahead. 😛

i mean something like..

select * from openquery('select * from thisTable where date >= '...

can i break out of the openquery and use tsql syntax??

wow. a little more complicated than i'd expected. trying to get my head around this now. i'll let you know if it works out. thanks.

thanks all (special thanks to the messiah),

yes i know the design is crap. it's from an old proteus db which it causing me serious headaches.

i've finally had to create a...

hi

the reason i wanted this...

select * from Sales.SalesOrderHeader

where OrderDate between 01/01/2004 and 31/12/2004

...is because i'm trying out SSRS using BIDS. i wanted the date to be a parameter value from...

thanks both

this now works fine....

declare @startDate as smalldatetime

declare @endDate as smalldatetime

set @startDate = '2004-01-01'

set @endDate = '2004-12-31'

select * from Sales.SalesOrderHeader

where OrderDate >= @startDate and OrderDate < @endDate

hi

firstly, love this series. great job.

I'm working my way through level 2 atm. i am using sql 2005, am i right in thinking that the Report Data Pane only...