Viewing 15 posts - 5,536 through 5,550 (of 10,144 total)
Koen Verbeeck (9/28/2012)
It still has the seat for the European Union/Committee. 😛(always great traffic jams when they have a meeting)
I rest my case - room for only one seat 😀
September 28, 2012 at 2:52 am
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!Who is going to make it to any of the SQL in the City events coming up in the next week+?
If you do one in Brussels...
September 28, 2012 at 2:35 am
Here's a fourth method:
-- solution
;WITH ParentsOnly AS (
SELECT ComputerName, ChildRows = COUNT(*)
FROM #MyTable
GROUP BY ComputerName
)
SELECT a.*, b.*, x.*
FROM ParentsOnly a
INNER JOIN ParentsOnly b ON b.ChildRows = a.ChildRows AND b.ComputerName...
September 28, 2012 at 2:31 am
Shadab Shah (9/28/2012)
I had written the lines of code as
Cast(SUM(A*B) / SUM(C) AS DECIMAL(30,5)) and
Cast(SUM(A*B) AS DECIMAL(30,5))/Cast(SUM(C) AS DECIMAL(30,5))
Conceptually both should return the same result , which is...
September 28, 2012 at 2:05 am
harri.reddy (9/27/2012)
hii want to insert 1000 rows in a table without any loop.
how can i do it?
In what format are the 1000 rows?
September 28, 2012 at 2:03 am
Barry Couch (9/27/2012)
CASE @SortColumn WHEN 'StreetName' THEN Maintainer + ', ' + StreetName END ASC,but how could I do something like sorting by Maintainer ASC and StreetName DESC?
You will need...
September 28, 2012 at 1:56 am
vinay.varaala (9/27/2012)
thanks a lot ..can I subtract todaysales- weeksale as other column
many thanks
Yes of course. To keep the query nice, either call it as a CTE or use it as...
September 27, 2012 at 8:39 am
vivekkumar341 (9/27/2012)
Try this.DECLARE
@ta VARCHAR(MAX) = '107.3'
SELECT SUBSTRING(@ta,0,CHARINDEX('.',@ta,0)) + SUBSTRING(@ta,CHARINDEX('.',@ta,0) + 1,LEN(@ta))
Why? How is it relevant to this thread? The OP isn't even around any more - he's a tuna fisherman...
September 27, 2012 at 8:00 am
Eugene Elutin (9/27/2012)
ChrisM@Work (9/27/2012)
Eugene Elutin (9/27/2012)
I have read a spec... 🙂...
Obviously not this OP's spec! The input value is supposedly DECIMAL(5, 4), however this appears to clash with the quoted...
September 27, 2012 at 7:38 am
komal145 (9/26/2012)
UPDATE TableC
SET step_desc= Tableb.StepDescription
FROM #MAX_STEPMAX_STEP WITH (NOLOCK)
JOIN TablebB WITH (NOLOCK) ON MAX_STEP.LoanNumber = b.LoanNumber
and MAx_step.Step=b.step
...
September 27, 2012 at 7:29 am
This is a little more tricky but reads the tables only once.
SELECT
SumTodaySales = SUM(CASE WHEN CAST(tr.Reading_Date AS DATE) = dates.Today THEN tr.Sales ELSE 0 END),
SumLastweekSales = SUM(CASE...
September 27, 2012 at 6:31 am
Eugene Elutin (9/27/2012)
I have read a spec... 🙂...
Obviously not this OP's spec! The input value is supposedly DECIMAL(5, 4), however this appears to clash with the quoted numbers in the...
September 27, 2012 at 6:27 am
Here's the simplest way. Note that performance will suck because you're doing all of your table reads twice:
;WITH SalesToday AS (
select
SumSales = SUM(tr.Sales),
t1.Tank
from Transactions as tr...
September 27, 2012 at 6:15 am
diptidjadhav (9/27/2012)
One more question for Jinxsee, Suppose if we are using row_number() for a huge records it will minimize...
September 27, 2012 at 6:11 am
Jinxsee (9/27/2012)
My bad! Mental note added. ^^.
No worries - now how about fixing your code so that it runs against the OP's sample data? You don't need the GROUP BY.
September 27, 2012 at 5:47 am
Viewing 15 posts - 5,536 through 5,550 (of 10,144 total)