Viewing 15 posts - 961 through 975 (of 2,894 total)
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...
November 7, 2012 at 6:02 am
Sony Francis @EY (11/7/2012)
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....
November 7, 2012 at 4:44 am
CELKO (11/6/2012)
...Now we have to track down this interview so we can tell them that you cheat
...dishonesty...
So, can you claim that you have never-ever lied yourself?
😉
I guess OP...
November 7, 2012 at 1:52 am
Jason-299789 (11/7/2012)
Eugene Elutin (11/6/2012)
My favoured one is:
SELECT $
This also works for £ and € currency symbols. I'm not sure about other currency symbols like Yen, Roubles, etc, as it may...
November 7, 2012 at 1:47 am
aykut canturk (11/6/2012)
where does sql2012 stores sequences....
November 6, 2012 at 10:43 am
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...
November 6, 2012 at 9:39 am
Please note, that the order of output is a bit different...
November 6, 2012 at 6:45 am
aykut canturk (11/6/2012)
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...
November 6, 2012 at 6:12 am
shilpaprele (11/6/2012)
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...
November 6, 2012 at 6:03 am
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
...
November 6, 2012 at 5:00 am
How will you differentiate between first set of:
- - - D
- - - E
and the second set of
- - - D
- - - E
What makes them first or...
November 6, 2012 at 4:47 am
Jason-299789 (11/5/2012)
Eugene Elutin (11/5/2012)
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:
The problem is...
November 5, 2012 at 11:05 am
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:
November 5, 2012 at 8:16 am
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...
November 5, 2012 at 3:28 am
Viewing 15 posts - 961 through 975 (of 2,894 total)