Please have a look at BOL, "OPENROWSET function" -> OPENROWSET (Transact-SQL)

Example right out of BOL:

It's a little bit confusing to me what you're trying to achieve...

What I figured is that you want to import xml structure from a flat file.

Right after that I'm lost:...

I'm not sure what Excel version you're trying to import from but you might want to check if the following link gives you the answer you're looking for: http://www.sql-server-performance.com/articles/biz/How_to_Import_Data_From_Excel_2007_p1.aspx

How are you planning to store the 150 tags?

Are you planning on creating a table with 150 cols or are you going to store the NTFRS data in a separate...

Paul White (6/24/2009)

---

An actual execution plan would be much more useful than estimated plans (we could see the runtime distribution of data across the threads for example).

...

It's all a bit...

If you need to get the first value for a given Callernum (like in your example for '233'), you simply could use top 1 clause (based on Wayne's sample data...

Hi folks,

would someone with execution plan background mind to take a look at this post and verify if I'm on the right track or misguiding the OP?

The more interesting part...

I'm by far no expert on execution plans but to me it looks like there is a missing index on column ACCT_DEBTOR that causes the major time of the non-pivot...

The following will give you the total for the last 12 months as requested based on a given variable @yr for the year and @mo for the month.

SELECT SUM(Opportunities),SUM(OppsWon) FROM...

SELECT CONVERT(VARCHAR(10),odate,105) AS date,'receipt' AS type,CAST(oamount AS VARCHAR(30)) AS [amount of receipt],'' AS [amount of spend]

FROM receipt INNER JOIN receiptregel ON receipt.oreceiptnr=receiptregel.[oreceiptnr]

UNION ALL

SELECT CONVERT(VARCHAR(10),odate,105) AS date,'spend' AS...

You might wanna try http://tinyurl.com/l8cveg.

Note: This is a professional forum. "Dude" is inappropriate and does influence the way I'll answer.

Please provide table structure, sample data and expected result as describe in the link in my signature.

From what you've described I don't know whether a GROUP BY would solve the...

Eichpeel (6/23/2009)

---

Lutz,

This looks perfect! I will make sure in the future to try listing all possible scenarios so that the community can test them all. I really love the fact...

Hi Lynn,

would you mind quoting the post...

Florian Reischl (6/23/2009)

---

GilaMonster (6/23/2009)

---

How far are you from Berlin? There's a very, very, very, very small chance that I may be...