Topics
Started by
Posts
Last post
Assuming that I do not know if a record exists (and about a 50% chance that it does), what is the m…
18 replies
I have a trigger on a Table1, that when an insert happens, it updates a value on Table2. Connection…
10 replies
Hi, I'm trying to write a query that will create a field name/value pair list of data from a …
2 replies
Hi all I have been ramming my head against a wall trying to get temporary tables or table variables…
10 replies
Hi Gurus, Is there any func's or SP's to read regisrty. https://dbfriend.blogspot.com/
11 replies
Hi, I have this update statement, UPDATE products SET productdetail = @detail, productprice = @pri…
6 replies
What is the diff between these two statements: SUM( ROUND(ISNULL(REVENUE, 0) , 0)) 'tot…
4 replies
I need to modify the query below: SELECT DISTINCT PhoneNum FROM History WHERE ProjectID IN (945, 11…
10 replies
I have a function GenRows() which generates row nums, and I have a table with 1000 rows, Tab A. Syn…
1 replies
I am using SQL Server 2000. I have a need to concatenate character fields so that the resulting ch…
3 replies
I have a table test_update with two columns id and name and I am trying to update the table w…
4 replies
Hi I am trying to join to three tables however one is duplicated. DPSITE TABLE: DPSITE UK F…
3 replies
In My database ,a column Message_reference VARCHAR2(10) is having sequncial values. But some of the…
3 replies
What is the equivalent of the Last() function in SQL Server 2000? Definition: LAST(c…
5 replies
Hi Everyone, Let me first preface my question with I am Novell Engineer that has be retasked to wri…
8 replies
Viewing 15 topics - 7,951 through 7,965 (of 17,082 total)
You must be logged in to create new topics.