Viewing 15 posts - 2,641 through 2,655 (of 6,036 total)
Once again - read BOL.
February 11, 2009 at 1:41 pm
It's decoded in column text.
February 11, 2009 at 1:27 pm
Procedures don't hold locks.
Transactions do.
February 11, 2009 at 4:58 am
The soliution is in the article.
And it does not use any loop.
February 10, 2009 at 8:54 pm
Should be something like this:
SELECT ISNULL(T1.account, T2.account) Acct, ISNULL(T1.MName, T2.MName) M_Name,
ISNULL(T1.Sname, T2.Sname) S_Name, T.TotalQty - T2.TotalQty Diff
FROM (
select account, MName, Sname, sum(Qty) as TotalQty
from tbl1
where OS =...
February 10, 2009 at 4:38 pm
Open BOL and read the topic about syscomments.
February 10, 2009 at 4:21 pm
Cannot understand why
update Table1 set col1 = replace(userid, @OldID, @NewID)
does not work for you.
February 10, 2009 at 4:18 pm
Derek Dongray (2/10/2009)
Sergiy (2/9/2009)
So, what was wrong with my solution?I thought your solution was just a step-by-step explanation of Adi's.
Yep, kind of.
Just missed his post.
So, the question then: what was...
February 10, 2009 at 4:01 am
Derek Dongray (2/10/2009)
The OP didn't mention that he had a calendar table and, in this case, I can't see that it's adding anything to the query.
If you need to paint...
February 10, 2009 at 3:57 am
2 smiles per post, considering it's MY post - is to seriously???
:w00t:
Man...
:hehe:
February 9, 2009 at 3:34 pm
andrewd.smith (2/9/2009)
The only thing I'd say is that sometimes you are forced by circumstances to do things in SQL Server that it wasn't designed for.
Unless you're a professional.
February 9, 2009 at 1:29 pm
Lynn Pettis (2/9/2009)
Sergiy (2/9/2009)
So, what was wrong with my solution?Actually, Sergiy, I have no idea.
Actually, the question was not for you.
🙂
You may realize that if you look at the...
February 9, 2009 at 1:18 pm
SELECT C.[Date], COUNT(T.indate)
from dbo.Calendar C
LEFT JOIN dbo.YourTable T ON T.indate = C.[Date]
WHERE C.[Date] > dateadd(m,-6,getdate()) -- probably you need to remove time portion here
group by [Date]
February 9, 2009 at 12:54 pm
The task itself is stupid enough not to bother to run any benchmark tests.
SQL Server is a RDMS, which stands for Relational Database Management System.
Can you show me any piece...
February 8, 2009 at 7:08 pm
Viewing 15 posts - 2,641 through 2,655 (of 6,036 total)