+1

Great question on a great topic that many people don't know about.

It makes sense if you think about it. How would the 208 database know that the parameter is...

vee_jess (11/19/2014)

---

Thanks for your reply but your query isn't giving me the correct result! But this one does...

with MyData as

(

select Stack

, RefID

, Name

, ROW_NUMBER() over (Partition by RefID order by...

I would recommend taking a long look at your structure. Everything is varchar(max). Do you really need that many characters in every column? There is no primary and since every...

Why are you using a cursor for this? And why do you have a variable named @XML that is not XML?

What a great job posting consumable data!!! I turned this into a temp table to make this a little more clear (and use it myself). Here is how you can...

g.britton (11/18/2014)

---

Sean Lange (11/18/2014)

---

For what it is worth, you should consider using a numeric datatype instead of float. It appears this is dealing with money and float is not an...

For what it is worth, you should consider using a numeric datatype instead of float. It appears this is dealing with money and float is not an exact numeric datatype.

And be warned...when building views that call views you are highly likely to get suboptimal execution plans. In short, performance is going to start degrading when you nest views.

arunnrj87 (11/17/2014)

---

Hi Friends I am Using the Below mentioned Script to fetch the data from Flatfile table and i need to populate it into respective Parent and Child table by...

Ashish Dutt (11/16/2014)

---

I have four tables.

Table1 has four columns, Table2 has 3 columns, Table3 has eight columns and Table4 has 10 columns.

Table3 and Table4 have a same column called...

If you are explicit with your columns you could deal with this in the insert statement. Then the update statement is not needed.

Something like this.

insert into OrderB

(

City

, [OtherColumnsHere]

)

select

case...

Took a shot at what I guessed was the most likely answer among them and got lucky.

Yes the query I posted will not work because the multi valued parameter is NOT a table. It...

I would recommend you use aliases in your queries. I had not until now really looked at your query. It is difficult to decipher when every column is referenced by...