mike 57299 (9/15/2015)

---

Hi all:

Here is the setup...

Standard Order header / Order detail records (1-m). Each order detail has a product id, order detail and ship detail.

Product info is...

lmarkum (9/15/2015)

---

The below code returns a NULL for all the Differential backups. I am trying to return the word Differential when there is a NULL because I can tell...

squvi.87 (9/15/2015)

---

This new set of data is not the same as the one you posted earlier. Is this giving you the correct results? If not, what should they be from...

sgmunson (9/15/2015)

---

Sean Lange (9/15/2015)

---

sgmunson (9/15/2015)

---

Question: Table definition uses user defined types for EVERY field (yeah, I know, but it's legacy). These aren't really "user defined types" in...

sgmunson (9/15/2015)

---

Lowell (9/15/2015)

---

As a remember it, there is no valid syntax for ALTER TYPE. only drop and create.

i know that once a user type is in use, to change it,...

Here is an excellent place to start. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/%5B/url%5D

sgmunson (9/15/2015)

---

Question: Table definition uses user defined types for EVERY field (yeah, I know, but it's legacy). These aren't really "user defined types" in the useful sense,...

freyes (9/15/2015)

---

I think there are only 3 ways to asign an alias to a column,

column as alias, alias=column and column alias.

The other variants are diferent ways to write the alias...

elmnas (9/15/2015)

---

Hello people,

I am total new to SQL server query programming.

I need to gather information by writing a own query to our SQL server,

I using LinQpad 4,

But I have less...

squvi.87 (9/15/2015)

---

So you can reference it by either substream1 or substream2? Regardless this is pretty much a typical recursive cte. There are thousands and thousands of examples of how...

_simon_ (9/14/2015)

---

Wow, such negative comments... As I wrote before, it was purely curiosity that made me ask the question how to convert my if exists update ... else insert ......

mw112009 (9/14/2015)

---

Select A.name, B.name

FROM

SYS.tables A

inner join

SYS.columns B on ( A.object_id = B.object_id )

ORDER BY 1 , 2

What I need is a 3rd column which...

mar.ko (9/14/2015)

---

Thanks Sean, but remember, my potential solution would effectively be 2 lines of code.

One to define the table via string, the other to call a function to convert it...

BWAHAA!!! No offense but that...

uummm....

select ORIGINAL_LOGIN()

You could try reading Books Online (BOL), the manual that comes with sql server. It is...