Hugo Kornelis (7/29/2013)

---

I like the question. I don't think it's a trick question - many people here are so used to using case insensitive collations (stupid defaults!!!) that they can...

savycara (7/24/2013)

---

Actually 2011 is year and 4 is month which shoud be represented as 04 and date is 01 (which is to be added)

I need this column data...

in what manner you want to display this '20114'

You need to follow this article for posting any question:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Lokesh Vij (7/23/2013)

---

Interesting question Kapil!

Even if someone is not aware that the index gets dropped (in Scenario-2); Scenario-3 was easy to attempt, because non-clustered index created in this scenario...

You arw getting this error because you have specified db_datareader, db_datawriter' as a single role and due to this sql server not able to identify it as a valid role........

It will be good for us to solve your problem if you provide some more details like table structure, sample data and resultant output....

can you please post the actual error...

WHile the error you post in your post is about invalid column name type...

As...

It will be good if you Google for this....

you can also refer the execution plan for this.......

bawinkley (7/23/2013)

---

I'm pretty sure you cant use variables in views, I have decided to take them out which isn't the end of the world.

I haven't worked out how to...

Hugo Kornelis (7/23/2013)

---

kapil_kk (7/23/2013)

---

Hugo Kornelis (7/23/2013)

---

kapil_kk (7/23/2013)

---

Can someone please throw more light on this statement-

DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO...

Hugo Kornelis (7/23/2013)

---

Which part of...

Can someone please throw more light on this statement-

DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause

+1 🙂