mw112009 (6/23/2015)

---

CREATE TYPE BP_Data_ACRC_427_B

as table

(

AIMS_VALUE_NUMERIC numeric(19,2),

bp_type VARCHAR(4),

Dt datetime ,

ID int IDENTITY(1,1),

MBP numeric(19,2),

MPOG_PHYSIOLOGIC_CONCEPT_ID VARCHAR(10)

UNIQUE CLUSTERED (MPOG_PHYSIOLOGIC_CONCEPT_ID,Dt)

)

IT works in SQL Sevrer...

Meatloaf (6/23/2015)

---

Hi,

I have created a phone list and am using a union to be able to display letter category. However, what I would like to do is only show...

An index on...

pjn (6/23/2015)

---

seriously? any need for that?

I asked a question, I accepted it, its fine, I wanted to know it something could be done (as in initial question), the answer to...

mw112009 (6/23/2015)

---

This is my table type definition ( below ) and as you see I declared a table whose name is in @t

/*

CREATE TYPE BP_Data_ACRC_427

as table

(

AIMS_VALUE_NUMERIC numeric(19,2),...

yb751 (6/23/2015)

---

GilaMonster (6/23/2015)

---

I'll probably be looking to get new kittens/cats later this year. My Siamese died late May, completely unexpected, out of the blue. One day she was fine, next...

pjn (6/23/2015)

---

Eirikur Eiriksson (6/23/2015)

---

pjn (6/23/2015)

---

Basically I am try to cut down some processing time.

Currently in its simplistic form:

sql1 = "select table1.theSql,table1.userid from table1"

loop through sql1.resultset

...

pjn (6/23/2015)

---

Not sure? if this is ever going to be possible, but I'm trying to do a dynamic join on EXECUTE, but the execution string has to come from a...

greglove (6/23/2015)

---

I want to study for SQL Server 2012 MCSA certification. Aside from study material, I assume I'll need SQL Server 2012 itself.

What edition do I need? Is the...

abhas (6/23/2015)

---

Hi,

Can we use case in pivot like below? I am getting an error. I want to do Pivot on condition basis. Please suggest idea.

select (

...

ChrisM@Work (6/23/2015)

---

sqlinterset (6/22/2015)

---

I have a table has data of all months. i want to have this table data in the form as first it lists data

from 1 month to...

Brandie Tarvin (6/23/2015)

---

So I know it's dirty pool to promote one's own blog on the forums, but in this case, I absolutely MUST show off.

Click it and you'll see why....

Jeff Moden (6/22/2015)

---

Ed Wagner (6/22/2015)

---

Lynn Pettis (6/19/2015)

---

Sean Lange (6/19/2015)

---

ChrisM@Work (6/19/2015)

---

I'm with Alvin...

I noticed that....