ChrisM@Work (2/7/2013)

---

;WITH SampleData ([Group], [Type], Amount) AS (

SELECT 'Dog', 'Typea', 1 UNION ALL

SELECT 'Dog', 'Typeb', 2 UNION ALL

SELECT 'Dog', 'Typec', 3 UNION ALL

SELECT 'Cat', 'Typea', 10 UNION ALL

SELECT 'Cat', 'Typeb',...

mjbkm (2/7/2013)

---

Thanks. I'm just confused about this part:

with DogCat(Animal, Amount) as

(

select 'Dog', 1 union all

select 'Dog', 2 union all

select 'Dog', 3 union all

select 'Cat', 10 union all

select 'Cat', 20

)

I...

How about using the DelimitedSplit8k? This seems to be super fast to me.

Select Id,

MAX(Case When ItemNumber = 1 Then Item Else '' End) As Level1,

...

menon.satyen (2/6/2013)

---

It depends on whats coded in your database scripts, application etc.

If you set it to 90 then it will use features of SQL 2005 and if set to...

kjeter (2/6/2013)

---

I have Filestream set-up in my backend SQL server. I have MS Access as my frontend. Any idea why I am unable to attach PDF documents? ...

Something like this should work. Notice how I posted sample data in a readily consumable format. That is something you should do in the future.

with DogCat(Animal, Amount) as

(

select 'Dog', 1...

njfuller (2/6/2013)

---

I'll back up a bit.

In a single transaction, a material and a material_prod_version record will be inserted.

Each record has its own identity column.

The material_prod_version record has a column for...

It would be far more helpful if you posted ddl and sample. You can find out how to do that by reading the article at the first link in my...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1413549-147-1.aspx

Then I would suggest you look at the article in my signature about splitting strings. Then look at the articles in my...

Can you post ddl and sample data. See the first link in my signature.

Antony Symonds (2/5/2013)

---

Is dynamic SQL bad in general or just when it opens up this sort of a security hole allowing for the SQL to fully specified or at...

It seems that a calendar table would help you considerably. You can read about them here. http://www.sqlservercentral.com/articles/T-SQL/70482/%5B/url%5D

If you need help with the query please first read the article in my...

This method will work but often people get confused. They...

igloo21 (2/5/2013)

---

Thanks Sean. I am adding the column as "AS ImportDate". This is actually a stored proc that I am putting together that will import into an xls. The trouble...