Search results for query: *

I have a store procedure and this store procedure must be robust enough to handle a fault in the middle of processing, which would cause it to terminate before completing. This means that it either needs to be self restarting, or able to be restarted in such a way that it doesn't "double...

update org_links SET ENDUSER_CNT = active_ur, SET ACTIVE_ACCNTS_CNT = active_accounts FROM #temp, #temp2 WHERE #temp.org_id = org_links.org_id, #temp2.org_id = org_links.org_id Mistake that I'm getting is Error 156: "Incorrect sintax near a keyword SET"

How to create temporary table and how to put information into it?

1. The following query will take records from Person & Party tables that are in Production Database and display numbers of the ACTIVE /*in this table 1 means active user..*/users per organization. select org_id, count (person.party_id) as num_us from production.dbo.person person inner...

select month(ord_date),(select daysinmonth(month(ord_date)) from ord where ord_date>'1/2/02' group by month(ord_date) returns this error Server: Msg 8120, Level 16, State 1, Line 3 Column 'ord.ORD_DATE' is invalid in the select list because it is not contained in either an aggregate function...

I need to create a Store Procedure that checks that will create "year" records only when there is a data in the record. Basically when i will be adding (puting something to the record) store procedure will automaticaly update year field based on this record... P.S. "Year"--...

Hi All, I need to create two table with records(it's not a problem) , but i would like to set up a stored procedure in order to take weekly iformation from on table and insert (or update) in another.. Stored Procedure has to work automaticaly (without me running it..)...

Hi All Can please somebody tell me where can i specify size=5, font=&quot;New Roman&quot; to the words that inside <option> Where should i insert the code, and what code? Thanks a lot Bob <FORM...

How can I create a text field with a button &quot;search&quot; on the Web. The thing is I will need to retrive a records from my SQL table and when I will be clicking Search I want fields top show up on my page from this table.. Thanks a lot, Bob

Hi All! I'm new to asp and I have a question.. I have table in SQl 7.0 and and with ASP I made a connection with this table.. In internet Explore I created drop down box and in this drop down box there is an information (records) from this table.. When I'm choosing on of them it goes to a...