|
Do you have text or ntext columns in this table? because as I remember, distinct won't work fine with them.
|
|
|
|
|
can we use stored procedure in user defined function ?????
This is haneef.............................................................
|
|
|
|
|
Have you tried it? If so, and it works the answer is yes else no.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi expets, I created a datagrid column as a templete column.It is a textbox field.So how i validate that templete column(textbox)?
CheeN
|
|
|
|
|
try the C# forum!
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I should have guessed, you already did.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
i want to create a trigger to copy value inserted to another column on another table i have tried the following but failed.
invoice_summary >> table to copy from
Invoice_details >> table to copy to
create trigger Insert_InvoiceNum on dbo.invoice_summary
for insert
AS
begin
insert into Invoice_details select Invoice_num from inserted
go
regards
|
|
|
|
|
How has it failed?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
error
Server: Msg 170, Level 15, State 1, Procedure Insert_InvoiceNum, Line 5
Line 5: Incorrect syntax near 'inserted'.
|
|
|
|
|
I suspect your InvoiceDetails table has more than 1 column so you need to specify why column to insert the value to
insert into Invoice_details(Invoice_num) select Invoice_num from inserted
Bob
Ashfield Consultants Ltd
|
|
|
|
|
same error raised
incorrect syntax near 'inserted'
|
|
|
|
|
can you post your table definitions? It might be a bit more obvious where the problem is.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Try placing an end before the "go".
Each time you have a BEGIN, you need an END.
|
|
|
|
|
it succeeded
but the insert value affected all rows i want it to affect 1 row only (new row)
hers is trigger syntax
create trigger InsertInvoice on dbo.Invoice_Summary
for insert
As
begin
insert into Invoice_details.Invoice_num select Invoice_num from Inserted
end
go
example :
insert into invoice_summary (P_name) values ('N1')
results:
the row insert to invoice_summary with Invoice_num 80
problem :
all invoice numbers in the invoice_details(invoice_num) is 80
should 1 row only added with that value
regards
|
|
|
|
|
Never overlook the obvious! Good spot.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thanks .. but still have problem
|
|
|
|
|
|
It depends on many things like nyumber of records, what you are going to do with them etc etc. The best way to find out is to try it - its a quick job to knock up 2 versions of the proc and test it.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Trying to install TFS, and after solving a plethora of annoying issues, I've reached an issue that google provides ineffective answers for.
TFS needs to be able to access the WSS, however, WSS needs to be able to configure the DB, providing it with all the neccessary parameters, it (or SQL Server) decides that the service does not have sufficient priviliges, indeed the quoted message reads:
"CREATE DATABASE permission denied in database 'master'. (Error code: 262)"
Does anyone have a clue how to work this out?
Solved, but still TFS won't install
"Every time Lotus Notes starts up, somewhere a puppy, a kitten, a lamb, and a baby seal are killed. Lotus Notes is a conspiracy by the forces of Satan to drive us over the brink into madness. The CRC-32 for each file in the installation includes the numbers 666." Gary Wheeler
"You're an idiot." John Simmons, THE Outlaw programmer
"I realised that all of my best anecdotes started with "So there we were, pissed". Pete O'Hanlon
modified on Sunday, June 1, 2008 6:22 PM
|
|
|
|
|
|
Got the email, thanks. I've been buried under with work and studying, my apologies.
My gratitude as well for the email
Actually, its on 2003 SP1, a VM even.
Its a serious pain. Now, I'm having problems integrating the Sql Server Reporting services with WSS. Its a bugger.
"Every time Lotus Notes starts up, somewhere a puppy, a kitten, a lamb, and a baby seal are killed. Lotus Notes is a conspiracy by the forces of Satan to drive us over the brink into madness. The CRC-32 for each file in the installation includes the numbers 666." Gary Wheeler
"You're an idiot." John Simmons, THE Outlaw programmer
"I realised that all of my best anecdotes started with "So there we were, pissed". Pete O'Hanlon
|
|
|
|
|
I'm not much of one with SQL, and I'm not sure if this is possible, but it seemed to me that it would be better to do it this way if it is than to split it into several queries.
I'm making a page usage site for my ASP.NET page, and I want to store statistics for what browser is being used, which OS, etc. So I have a table with 2 fields: BrowserName and Sessions. I want to make a query that if the BrowserName exists, then it increments Sessions, otherwise it adds the BrowserName and sets Sessions to 1. Switching between Update/Insert in particular has left me clueless.
Thanks in advance!
|
|
|
|
|
Hello, this is a sample stored procedure that does what you need, I assume that you use MS SQL
This is just one way of doing it.
create proc InsertOrUpdateCount(@Browsername varchar)
as
update tablename
Set Sessions=session+1
where BrowserName = @Browsername
if @@rowcount=0 --no updates so the record does not exist
insert into tablename (BrowserName ,Sessions) values (@Browsername,1)
|
|
|
|
|
when i write code <sp_dropmergearticle @publication = 'RepTest'
, @article = 't1'
, @ignore_distributor = 1
, @force_invalidate_snapshot = 0>
i received error
error : <Cannot drop article 't1' from publication 'RepTest' because its snapshot has been run and this publication could have active subscriptions.
>
please help
|
|
|
|
|
Have you tried to remove the snapshot?
|
|
|
|