03? That is old ambulance number in Russia, you can use just 3 ...:hehe:

Actually, SQL can convert '17/08/12'...

Basically does it cause physical I/O operation on the disk?

My answer...

scott_lotus (8/15/2012)

---

I am trying to write a script to read the current row and previous row per device and work out the difference reporting values over X (> than 20...

First thing I would do is de-noodling the code so it can be readable:

a.) Format with proper indenting of code between BEGIN and END

b.) Remove the hoard of commented out...

...

To be fair, we'd start from a file, because if the contest is aggregating from a table, assembly wins because I'll pick a table definition that consists of putting the...

Jay Pete (8/14/2012)

---

Hi

I am newbie in the T-SQL Programming.

Please anyone can explain to me when and where i should use left join or right join with nice example.

Thanks in...

...

That said - if I gave you a file or a table with 10,000,000 invoices and I needed to get a balance by customer, I guarantee you SQL server will...

All your single quotes must be escaped by doubling them:

SELECT [ValidationRule]

= '[PERFORMINGPROVIDERID]=COALESCE(NULLIF([PERFORMINGPROVIDERID],''''),NULLIF([PERFORMINGPROVIDERNPI],''''),NULLIF([BILLINGPROVIDERNPI],''''),REPLICATE(''*'', 10))'

If you are looking for performance, then "well-done" CLR using RegEx will outperform T-SQL for large and/or complex string replacements.

drew.allen (8/14/2012)

---

If you're trying to do what I think you are, then the answer is that you can't do it in SQL. First Normal Form for databases is that...

Ough! Yes! I have seen this film! Also, I've seen The...

Actually, you wouldn't even need a lot of experience to choose surrogate PK over natural key. Use common sense or apply pure mathematical...

Sergiy (8/12/2012)

---

CELKO (8/10/2012)

---

like the idea of having a sid (a surrogate id) on my tables, even if I do have a natural key that can serve as a primary...

Don't forget to buy and read all his books, otherwise you will be left in unknowing state for ever!

:hehe:

What is your default connection option in EM for ANSI_NULLS? I think it will be OFF. In old QA it used to be ON...

Try to create your proc as per...