Just add

INTO SomeTableName

right before the FROM clause.

select icn,

'ADMIT' = case when MAX(case when [sequence number] = 'a' then [diagnosis code] end) IS null

then ''

else MAX(case when [sequence number]...

dannayakrahul (2/22/2014)

---

Hello,

Thank you for your response i dont know exactly how to develop a query to that problem that is why i have kept the question with some practical data...

No problem. It...

halifaxdal (2/21/2014)

---

ScottPletcher (2/21/2014)

---

I, too, got different totals; mine add up to 82, the number of sample rows of data.

SELECT

Owner, CAST(YEAR(Quarter) AS char(4)) + 'Q' + CAST(DATENAME(QUARTER,...

Can you explain the desired output? If this is a count of values for each period I am a bit lost. You have a total of 82 rows in the...

ghitpro (2/21/2014)

---

Team,

I would like to include few columns (varchar and int data types) from same table in below query without adding in group clause, i do not want these column...

You are updating every row because there is nothing to tie the rows together. Your logic basically says, if there are any rows that meet this criteria then update the...

montecarlo2079 (2/21/2014)

---

Yep thanks sean,

I used the max for all of the columns...did exactly what I needed it to.

but one question, do I need to create a temp table to make...

below86 (2/21/2014)

---

Thanks Sean, I was trying to figure out something similar the other day and couldn't think of how to get it down to one row per ID. Without...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

Hi and welcome to the forums. It is really difficult to figure out what you are trying to do here. You should take a few minutes and read the first...

Great job posting ddl and sample data. You stated the desired results but it is exactly the same as your sample data. What exactly are looking to do here?

SQL_Padre (2/21/2014)

---

I can easily find user created stat in a databaseSELECT * FROM DB.sys.stats WHERE user_created=1

But how do I determine what tables those stats are in? with over 6000...

Jeff Moden (2/20/2014)

---

Oh ye of little faith. 😛

SELECT TOP 10000

...

Dieselbf2 (2/20/2014)

---

hunchback (2/20/2014)

---

Have you checked the catalog views sys.tables and sys.columns?

Here is an example without taking into consideration user types.

SELECT

t.name AS tn,

sc.*

FROM

sys.tables AS t

INNER JOIN

sys.columns AS sc

ON sc.object_id = t.object_id

INNER...