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

http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D

Make sure you read and then follow along to the second article about how to make this dynamic.

joe.cahoon (2/13/2012)

---

Hi,

I agree, I wished who ever initially set these up did so in a different way, but I have to work with it regardless.

The date and time are in...

Try this link. http://bit.ly/zjNFeT

memymasta (2/13/2012)

---

Hmm not really.

I got this query..

Select a.a from a LEFT JOIN b ON a.a=b.b WHERE b.b IS NULL

Is it possible to get same results with

Select a.a from a LEFT...

joe.cahoon (2/13/2012)

---

Hi, thanks for the quick response.

Here's what I have to work with in these tables,

Table_1

HeatNumberID (PK,varchar(50),not null)

Start_Time (text,null)

Start_Date (text,null)

...

Like this?

declare @MyVar varchar(10)

set @MyVar = null

Great question and excellent scenario setup. I am quite surprised that at the time I am posting there are 417 answers and 16% of them still think truncate is not...

Keep in mind there is no such thing as next or previous rows. They have no order until you add an order by clause. It appears that you want to...

Get a dev environment setup and try it out. There shouldn't be any issue but it is impossible to say that for sure. The ONLY way you can be sure...

No worries. Now you have an example of what you should provide for next time. 😉

It is best for these types of questions if you can post ddl and sample data along with desired results based on your sample data. I created the ddl and...

Aside from the very painful structure and naming convention, I am not sure what the issue is. You will return the result of the union of all those select statements....

Sounds bit like another profession we are all familiar with. Thanks for the article.