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...

Read this article about NO LOCK and dirty reads. It is more than just non-committed transactions and it is by no means a magic "go fast" pill.

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

A few questions:

What are...

joe.cahoon (2/13/2012)

---

Thanks for the replies, I really appreciate it.

One question, and I'm still new to using SQL,

declare @Date varchar(10) = '12/3/2012'

declare @Time varchar(20) = '10:33:31 PM'

select CAST(@Date + ' '...