It's not a bug.

The syntax you are using is never reliable to get string concatenation in T-SQL.

BTW, Order By 1 in your first sample, is not inequivalent to...

Sony Francis @EY (11/7/2012)

---

Try this

SELECT *

FROM TableA a

LEFT OUTER JOIN TableB b ON a.LoanID = b.LoanID

WHERE b.ColumnA <> 'Y'

When we use INNER JOIN it will consider only commom records....

So, can you claim that you have never-ever lied yourself?

😉

I guess OP...

Jason-299789 (11/7/2012)

---

This also works for £ and € currency symbols. I'm not sure about other currency symbols like Yen, Roubles, etc, as it may...

aykut canturk (11/6/2012)

---

I was digging sql2012 sequence feature, looks like don't need to worry about deadlocks nor increments any more but I couldn't find one thing:

where does sql2012 stores sequences....

I would pre-populate InvoiceTable with 0 on the Customer Record creation, then getting and updating invoice number would be as simple as:

DECLARE @invoiceNo INT

UPDATE...

My favoured one is:

SELECT $

Please note, that the order of output is a bit different...

aykut canturk (11/6/2012)

---

dear lnardozi 61862,

problem is, I'm not generating invoices. my customers are generating their own invoices for their own customers using my web application. Say, customer A starts operation...

shilpaprele (11/6/2012)

---

Dear All

I need to create procedure with variable parmaeter list. I am trying to achive it through table value parameter.

Is it the correct approch?

Also I need this parameter to...

I honestly believe that you are trying to do something wrong, but...

Here we go:

;WITH cte_ref

AS

(

SELECT R.*, ROW_NUMBER() OVER (PARTITION BY F_data_id ORDER BY F_ref_id) N

...

How will you differentiate between first set of:

- - - D

- - - E

and the second set of

- - - D

- - - E

What makes them first or...

Jason-299789 (11/5/2012)

---

The problem is...

There is another powerful feature which will make even viewing a stored procedure code a big hassle, it's called ENCRYPTION:

Read about option ENCRYPTION in here:

http://msdn.microsoft.com/en-us/library/ms187926.aspx

I don't think that function should worry about time part of date of birth. In SQL2008 you better just to use DATE type so the time wouldn't be...