I can not get the results in one row as you have shown in a simplified manner.

From BOL:

The result sets combined using UNION must all have the same structure.

They...

/*Requirements BEFORE executing SQL code:

1. Excel workbook must exist on the server in this case C:\TipsNTrick\Tables.xls

2. Excel sheet column headings must be identical for example...

Refer to books on line (BOL) sp_who - specifically the entries for columns "blk" and "cmd'

Blk:

The system process ID for the blocking process,...

Using SSMS

Expand the database which contains the 2 tables

Right click on the table name

In the drop down menu left click on "Design"

In the resulting pane click row with "StyleId"...

Open SSMS

Expand the list of databases

Right click on a database name

Left click on "Properties" in the menu which appears

In the next window (left pane titled "Select a page")

Click...

aljtdj (5/5/2008)

---

Whine all he wants, and make no mistake it is whining, developing an architecture and/or tools that millions of people, other developers included, will use is far more...

In my humble opinion...

AS previously stated:

dunnjoe (5/5/2008)

---

That's why I feel answer b is not correct. Answer b says the value is converted to an int. The error message says the conversion failed....

Grant Fritchey (5/29/2007)

---

Ladies... The signal to noise ratio is starting to drop a bit. This was supposed to be a bit of candy for some intellectual stimulation. A little...

Thank you one and all for the comments. Since the QOD is or should be designed to make us think and learn, I believe that all the comments...

Another option -- You can create a stored procedure incorporating two input parameters to execute something similiar to the following

DECLARE @news INT ...

SUJITH KUMAR (4/23/2008)

---

Hi,

If a new number is generated insertion have no problem. If number generated is an existing one Sql Server not allowing to insert because of duplicate key....

Dots or no dots from:

http://msdn2.microsoft.com/en-us/library/aa225964(SQL.80).aspx

The following text:

Note During a full database or differential backup, Microsoft® SQL Server™

backs up enough of the transaction log to produce a consistent...

arsrini (4/17/2008)

---

Hi,

We have three production servers running SQL 7.0 with hundreds of our own Stored Procedures. We want to upgrade these servers to SQL 2000 or SQL 2005. Are there...

Goodguy your answer "Thanks, I think I figured out the solution I need."

Heck we all can learn from these posts how about telling us what / why / how you...