vick12 (10/12/2011)

---

Hi,

I am in need of converting a datetime column into character type and then sort it once it is converted to character. I am not sure which convert style...

Gianluca Sartori (10/12/2011)

---

Lynn Pettis (10/12/2011)

---

To proudly go where few have gone! Just how many people have gone into space? What an honor it would be to be a...

To proudly go where few have gone! Just how many people have gone into space? What an honor it would be to be a part of that elite...

SQL_By_Chance (10/12/2011)

---

Hi,

Does anyone know how to implement use of different database inside a proc ?

create proc xyz

as

begin

declare @sql varchar (100)

set @sql = 'use ' + @dbname /*...

jared-709193 (10/12/2011)

---

Lynn Pettis (10/12/2011)

---

When in doubt, contact Microsoft. It is their kicensing scheme, they are the ones that will give you the answer you seek. All we can...

When in doubt, contact Microsoft. It is their kicensing scheme, they are the ones that will give you the answer you seek. All we can do is give...

I'll have to reread the EULA for the developer edition, but when I was looking at for our test servers at D11 I am pretty sure that users testing an...

Here is what I really need to help. The DDL for the original table with the data in it that you need to parse. Sample data for that...

Wait, Wait, it gets even better when interfacing nHibernate with Oracle!

The ref...

dmoutray (10/7/2011)

---

sqlfriends (10/7/2011)

---

We cannot use trial version of Enterprise, is because once the test server is upgraded, we want to keep using it, the developer will use it as a...

dmoutray (10/7/2011)

---

Lynn Pettis (10/7/2011)

---

I don't think that means you can install the same licensed version on 4 physical machines. I think it means you can install the copy on virtual...

I don't think that means you can install the same licensed version on 4 physical machines. I think it means you can install the copy on virtual systems residing on...

I can't work on it here at work. I'll look at it when I get home and can concentrate on the solution.

Sean Lange (10/7/2011)

---

This should be totally doable in tsql. A combination of Jeff Moden's splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D and maybe a for xml should just about get it there.

I don't have much...

Looks like home work. Show us what you have written so far and where you seem to be having a problem.