Did you actually try your sample script before posting?

Reason for asking:

table Inventory:

column TotalValue is missing.

column ManufacturingOrder is missing.

Insert statement fails on table Inventory: trying to...

Hi Phil/Tommy (?),

based on your Excel file, what would be the expected result?

I just used some Excel formulas and I'd assume the following:

Number of products20

MaterialValue4098,5205

LabourValue271,3305

OverheadValue1731,125

TotalValue6100,976

Is this assumption correct?

Edit: wording modified.

Need some advice on how to respond in the future...

While venting:

Do you think that I've overreacted on that post http://www.sqlservercentral.com/Forums/FindPost732338.aspx

I mean, posting sample data in Excel is fine for the...

Hi Tommy,

Based on the Excel data you attached I kinda assumed the relevant structure of your tables.

Is it really an issue that you're unable to post the following on this...

Hi Balaji,

I'm wondering how the xsd shows up all of a sudden... since it looks almost like the issue we discussed just the other day within the following thread http://www.sqlservercentral.com/Forums/FindPost729749.aspx...

The...

Regarding the "Smurf" posts:

Did anybody ever figured out, what color a smurf turns into if he gets strangled?

(Just had to warm up that old joke...) 😀

Hi, you should look into sp_executesql instead of EXECUTE. For Details please see BooksOnLine (BOL).

You also might have a look at http://www.sommarskog.se/dynamic_sql.html

If you need more information please tell us a...

Glad I could help. 🙂

Hi Megistal,

first of all thanx for the sample data structure you provided! Makes it easy to work on!!

This solution should work.

DECLARE @FileContent xml

SET @FileContent='101213'

SELECT Node.value('VersionInfo[1]', 'int') AS VersionInfo,

Node.value('Version2Info[1]', 'int') AS...

Please don't cross post.

further discussion using http://www.sqlservercentral.com/Forums/FindPost730969.aspx

Hi Balaji,

before we go into details a few comments:

1) You should not post real data as it might get you into trouble for posting stuff that's not within your authority....

Jeff Moden (6/7/2009)

---

I seen this type of problem many times. Normally, it comes with a start and end date and someone wants to generate a row for each date...

Please don't cross post.

Discussion in thread http://www.sqlservercentral.com/Forums/FindPost729749.aspx.

I was wondering about his reply too, since the two statements (regarding the article and the correlation to the original subject) within one post don't seem to match up very...

Cross post.

Reference post http://www.sqlservercentral.com/Forums/FindPost730354.aspx already closed by OP.