And this is even easier:

declare @test-2 table (MyDate date, MyTime time);

insert into @test-2 values (getdate(), getdate());

select *,

convert(datetime, MyDate) + convert(datetime, MyTime)

...

Try this out:

declare @test-2 table (MyDate date, MyTime time);

insert into @test-2 values (getdate(), getdate());

select *,

DateAdd(second, DatePart(second, MyTime), DateAdd(minute, DatePart(minute, MyTime), DateAdd(hour, DatePart(hour,...

Hugo Kornelis (10/15/2010)

---

:laugh: I seem...

cfradenburg (10/15/2010)

---

William Vach (10/15/2010)

---

...you must connect through the registered servers tree. If you connect through the File|Connect Objects explorer method, the color of the status bar will be the...

William Vach (10/15/2010)

---

Assuming that this was not a trick question, I believe that the correct answer is 'it depends'. You can set the status bar for the query window...

You're welcome. Come on back if you have any more questions!

Actually, I create all stored procedures like this:

CREATE...

I...

DECLARE @cus TABLE (col1 int, col2 varchar(50));

INSERT INTO @cus

SELECT 1, 'John' UNION ALL

SELECT 2, 'Bob';

SELECT stuff((SELECT ',' + convert(varchar(10), col1) + ',' + col2

...

jkeys-972541 (10/15/2010)

---

Thanks Wayne,

Works a treat - Although you have explained it, I don't really understand what is going on with your script - I'm sure I could apply this elsewhere....

One of the tables that you're performing an INNER JOIN with is a 1->Many relationship; thus you are getting values for each row from the table with the Many relationship.

To get this to always work, there are TWO places to set it:

1. On a registered server, select the "Connection Properties" tab, and set the color.

2. On the Object Explorer,...

ALTER TABLE DTREE ALTER...

You're welcome... but does it do what you need?

This link should help you out.