| Thread | Last Post | Replies |
|
| query | 28 Oct 2006 23:19 GMT | 8 |
Have a problem and hope someone can help. I have a column which consists of numbers such as 123 235
|
| parameter query | 25 Oct 2006 23:30 GMT | 1 |
I have a table of doctors, each doctor is assigned a unique identifier, but may have mulitple offices in diff cities with differnent id numbers. When writing my paramter query to build a list of doctos, I am seeing duplicates. query looks like this:
|
| Capture Before/After data on Multirow Updates | 21 Oct 2006 00:43 GMT | 1 |
Problem: I only get one record of before and after data when performing multirow updates from a single update statement. I want to get before and after data for ALL updated records from the update statement. How can I do this? I am using sp_trace_generateevent to capture ...
|
| Hierarchy Data in XML | 10 Oct 2006 19:15 GMT | 1 |
I have two Table Employee and Dept Employee Columns EmpID EmpName
|
| sql query single table | 09 Oct 2006 03:14 GMT | 8 |
I am trying to run a report. The requestor has specifics on the way it should be formatted on output. I'm going to try and explain what he's looking for as well as give the example of output which was given me. The "Central Host" is the system whose agcprefix = DAC. Each ...
|
| Insert data | 07 Oct 2006 00:11 GMT | 1 |
I haven't figure out why the store procedure execute withour error, but the data doesn't on the table. I have a store procedure which is call by the component in the exchange server.
|