Viewing 15 posts - 1,321 through 1,335 (of 2,171 total)
He is all over the places so this must be reallt important, having twice the number of helpers...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88706
I suggested adding a ";" before the WITH keyword
August 30, 2007 at 2:29 pm
CREATE
PROCEDURE dbo.uspGetLastOrdersForCustomer
(
@CustomerID
@LastDays
August 30, 2007 at 1:08 pm
Already answered here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88696
August 30, 2007 at 12:54 pm
And this is the solution
-- Prepare sample data
DECLARE @Sample TABLE (CustomerID INT, dt...
August 30, 2007 at 12:51 pm
Why don't you use WITH TIES?
SELECT
TOP 3 WITH TIES
CreateDate AS ShipDate,
TrackingNumber
August 30, 2007 at 11:36 am
You are welcome!
-- Prepare sample data
DECLARE
@Table1 TABLE (GroupID INT, Type...
August 30, 2007 at 11:32 am
If you run your original query WITH table prefix in the IN part, like this
SELECT
DISTINCT A.teller_id, b
August 30, 2007 at 9:31 am
Which values can inactive_teller have, besides "I"?
Can it be NULL?
August 30, 2007 at 9:23 am
SELECT CASE
WHEN tCount12 = 0 THEN 0
ELSE 1.0 * tSum12 / tCount12
END AS Avg12,
CASE
WHEN tCount345...
August 30, 2007 at 6:51 am
DECLARE
free_reg CURSOR FOR
SELECT GRIDDude,
NumbReg
,
fname
,
lname
,
accnum
August 29, 2007 at 11:53 pm
SELECT
DISTINCT a.Teller_ID,
b.Teller_Name
FROM Branch_Teller_st AS a
INNER...
August 29, 2007 at 11:46 pm
Why are you overcomplicating things?
Bledu put you on the right track.
SELECT TOP 2 * FROM shipments WHERE customerid = 'dmo-con' ORDER BY createdate desc
It the issue is that you want them...
August 29, 2007 at 11:40 pm
Select cardid, activedate, score1, score2, score3, score4, score5
From (
Select cardid, activedate, score1, score2, score3, score4, score5, row_number() over (partition by cardid order by activedate desc) AS recid
From @cards
) as...
August 29, 2007 at 12:44 pm
I use SQL Profiler to measure the CPU, DURATION, WRITES and most important, READS.
August 29, 2007 at 11:45 am
Viewing 15 posts - 1,321 through 1,335 (of 2,171 total)