Search results for query: *

Looks like it returns the first day of the month for the date you pass in. Change mydate to 10/17/2010 and run. You will get 10/1/2010.

update goals set emp_property = 'Westin' where emp_property = 'The Westin'

Thanks to both of you for your suggestions!!

I am doing work for a client who uses SQL Server 2000. I told them I need to log into the server as the Windows user the SQL Service is running as so that I can set up some drive mappings and such that they need the server to have. However, they informed me they lost the password and have no...

Ohhh... Well, following your logic from above it would be something like this (I'm assuming deprtmnt is your PK): CREATE TRIGGER [trgDeleteUPR40300_kml] ON [dbo].[UPR40300] for delete AS delete from gpviews.dbo.upr40300 where dbase='two' and deprtmnt in (select deprtmnt from deleted)

If you're trying to do the same thing, joining to the deleted table instead of the inserted table should give you what you need. You also don't need the "If Update" logic. Just the update statement itself.

If you're doing the same thing regardless of update or delete you could just do this: CREATE TRIGGER [trgUpdateUPR40300_kml] ON [dbo].[UPR40300] for update, delete If you need it do something different you'd want to create a separate trigger starting like this: CREATE TRIGGER...

You say, "when that field is changed on the front end" but your trigger appears to be an insert trigger only. Therefore it only fires when the row is inserted: CREATE TRIGGER [trgUpdateUPR40300_kml] ON [dbo].[UPR40300] for insert Try this: CREATE TRIGGER [trgUpdateUPR40300_kml] ON...

What happens when you run: exec sp_helpreplicationdboption go How many changes do you need to make? If it's only a couple you can do something like this on a replicated DB: alter table address add XCoord_bak decimal(8,5) GO update address set XCoord_bak = XCoord GO exec sp_repldropcolumn...

Try running sp_removedbreplication on the db in question.

Perfect! Thanks!

I have a table called "CLAIMS". It contains these fields among others: MemberID ClaimID PaidAmt ProviderID ServiceDt PaidDt A ClaimID can be adjusted and contain multiple lines (for example, a claim is paid at $59, then a second line may take back the amount ($-59) and a third line may repay...

Not trying to be picky but that above trigger would not work if you had a multi-row update. You'd need to do something like this: CREATE TRIGGER Test_Update ON bob FOR UPDATE AS insert into bob2 (idnumber, n) SELECT idnumber, n FROM Deleted Craig

Good point. Nice catch. Craig

I'm not sure what your customers are doing with their data but one option would be to create a view of the table in question and then you can name each field whatever you wish. Then have the customers access the view. Of course, if you're talking about some sort of front end app that...

declare @v varchar(50), @pv varchar(50), @name1 varchar(20), @name2 varchar(20) select @v = 'Mr Dunne and Mrs Dunne' if @v like 'mr%and mrs%' begin select @pv = replace(@v, 'mr ', '') select @name1 = left(@pv, patindex('% %', @pv) - 1) select @name2 = reverse(left(reverse(@pv)...

This usually occurs during transactional replication when the Primary Key value of the row being updated does not exist in the subscriber. So the upd SP can't find anything to update.

vongrunt's is more elegant than mine, but since I typed it already I'll post it anyway... So if data exists for BedNo1/Time1 in TableA is it always true that data wouldn't exist for BedNo1/Time1 in TableB? If that's the case, then what I would do is to make a view that's a union of the two...

select staffno, datadate, sum(case when worktype = 'a' then data1 else 0 end) as adata1, sum(case when worktype = 'a' then data2 else 0 end) as adata2, sum(case when worktype = 'b' then data1 else 0 end) as bdata1, sum(case when worktype = 'b' then data2 else 0 end) as bdata2, sum(case when...

Does this make it any clearer? create table my_comments (pkid int not null identity(1,1), comments text) GO set nocount on declare @ptrval binary(16), @current_comment_len int, @new_comment varchar(8000), @pkid int select @pkid = 1 --or whatever you need it to be to test select...