Flashback

http://www.youtube.com/watch?v=tyeJ55o3El0

School House Rock

Here is a great article which explains this. http://blogs.msdn.com/b/conor_cunningham_msft/archive/2008/08/27/no-seatbelt-expecting-order-without-order-by.aspx

tr763 (9/23/2014)

---

I have two columns in a table right now. My query is inserting data into this table from another so that non technical users can view this database value...

Here are a few links which discuss what that NOLOCK hint is really doing.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/%5B/url%5D

As previously mentioned either one can be correct. Those two calculations are NOT the same thing. A subtle difference perhaps but the results could vary greatly as they are calculating...

I will just leave this here.

Great question. I pretty much knew what was being tested part way through and skipped the first insert. Guess I should wait until after I finish my first cup of...

Sickness

phingers (9/19/2014)

---

no generic columns - here is the view

CREATE VIEW [dbo].[bespoke_packaging_per_job]

AS

SELECT DISTINCT dbo.jobbom.jobnum, dbo.lotdet.lotnum, dbo.prdall.descr, dbo.spdfil.mark, dbo.boming.slot

FROM dbo.bomlot WITH (nolock) INNER JOIN

...

Please don't use all caps. It is considered yelling and is really difficult to read.

Now let's turn that unformatted mess into something legible.

SELECT DEBIT.ACCOUNT_NO

,DEBIT.SERVICED_AMT

,DEBIT.TRANSACTION_VALUE_DATE

,DEBIT.SERVICED_FLAG

,CREDIT.ACCOUNT_NO

,CREDIT.TRAN_AMT

,CREDIT.SERVICED_FLAG

,CREDIT.[TRANSACTION_VALUE_DATE]

FROM TBL_INTEREST_DEBIT AS DEBIT

INNER JOIN TBL_CREDIT...

up.sivakumar (9/19/2014)

---

select CONVERT(VARCHAR(10),LEFT( e.REGION ,10))AS reg ,count(JOINING_DATE) from emp e

group by CONVERT(VARCHAR(10),LEFT( e.REGION ,10))

order by e.REGION

The above SQL Script ran successfully up to yesterday. But today its throws the below...

Your question is so incredibly vague there is no real way to answer it. Do things that make your code accurate and fast. Don't do things that make your code...

up.sivakumar (9/19/2014)

---

No, I am using Base table. I didnt change anything on that query. I want to know how it was worked without "WITH" keyword upto yesterday. Please clarify me.

Now...

I am not a fan of formatting from the sql side but you could greatly simplify this query. There is no need for these elaborate case expressions and hard coded...