Well that is even less clear than your original post. I assume there is a language barrier but step back and ask yourself if anybody could possibly understand what you...

No problem. It happens sometimes. You can't remove a post. I just added a comment so others don't post here. Keeps your answers and discussion in one location.

Your question is totally unclear. Can you try to explain clearly what it is you want to accomplish. It would probably be best to post ddl...

duplicate post. please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1252488-392-1.aspx

Good question.

I don't think I have ever written an instead of trigger. I had to wrestle with them early in my career (didn't know how to disable a trigger...

GSquared (2/14/2012)

---

The second one won't clear tempdb. You can only remove an empty file. If tempdb has empty files, you could do this to remove them, but you...

This looks a lot like homework. What have you tried so far?

Is there a question here?

Then again...I am not sure if the server collation comes into play here. Not using or even having case sensitive instance I can't test that as easily.

The UserName is not case sensitive. By far the quickest and easiest way to answer this is to simply try connecting. 😀

Please don't cross post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1251377-392-1.aspx

kschwid (2/13/2012)

---

Well in my case Stored Procedures are used for Reporting Purposes and no I don't care because you report on the day, week, month prior. So the data shouldn't...

Jeff does a great explaining this here. http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D

No just run a similar query on your table. I am showing you an example. In my case I used a temp table because I don't have your permanent table....

Formatting should be left in the front end.

See if this...