For every value in A, i am using RANK to calculate the highest B , so i...

bkubicek (9/28/2011)

---

kishoremania (9/28/2011)

---

Actually the data will be like

10 1 1

10 1 2

10 2 1

10 2 2

10 3 1

10 3 2

11 1 1

11 1 2

11 2 1...

How about this?

declare @test-2 table ( a int, b int, c int )

insert into @test-2 ( a, b , c)

select...

Can you please expand further on how you arrived at your desired result ? i am kinda stuck in understanding the requirement. Should we find the highest profit for Deal...

That will give you all the rows that has A...

Thanks Gian for the wonderful set-up.

SELECT *

FROM (

SELECT *

, cnt = COUNT(*) OVER(PARTITION BY strategy_ID)

, RN = ROW_NUMBER() OVER(PARTITION BY strategy_ID ORDER BY efct_start_dt DESC)

...

Write a CLR proc to find the windows tasks, summon that CLR in ur SQL 🙂

tina 77078 (9/19/2011)

---

Sorry - didn't mean to be unprofessional. You just have NO IDEA how long I was struggling with this issue. I just wish I found this...

U...

ajenawsu (9/19/2011)

---

SELECT 1 AS EncID, 'OB Visit' AS 'Category' UNION ALL

SELECT 2 AS EncID, 'Other' AS 'Category' UNION ALL

SELECT 3 AS EncID, 'Dental Visit' AS 'Category' UNION ALL

SELECT 4 AS...

Lowell (9/19/2011)

---

i'm using the patindex a second time to find the comma, and then pulling the length of whatever is between the two.

with stg_reporting([column 5])

AS (

SELECT '[jobname] [RPP] Info: [RPP]...

This:

DECLARE @Tab TABLE

( [Column 5] VARCHAR(200) )

INSERT INTO @Tab

SELECT '[jobname] [RPP] Info: [RPP] Job processed 0, Success: 0, Error: 0.'

UNION ALL SELECT...

can i be ur BFF also ?? :ermm:

it requires more than the switches to capture the information from a query to be passed to sqlcmd, i think..

Wont objects in tempdb get dropped when the server restarts ?

< i dint read...