because u are concatenating Gender with the Date and using this to match RiskStart..

Your @a+@b results in Riskstart = 'M2010-08-25 00:00:00.000'.. is it wat you have it in RiskStart column...

WayneS (8/26/2010)

---

ColdCoffee (8/26/2010)

---

WayneS, OP is having SQL 2000.. so i guess OVER (PARTITION BY) wont work there..i dont have a handy SQL 2000 version for OVER (PARTITION BY)... it would...

Ok, i used correlated sub-query to accomplish this task without OVER (PARTITION BY)

Here is the SQL 2000 version of the code (Using the same concept from Peso)

DECLARE @Sample TABLE

...

WayneS (8/25/2010)

---

Edit: Note that...

+1

😀 :hehe:

Coool question, Hugo.. Thanks 🙂

try this:

declare @a varchar(50)

declare @b-2 varchar(20)

set @b-2=(select gender from table where Cov='101')

set @a='''' + @b-2 + ''''' OR CAST ( ' + convert(datetime,'24/08/2010',103) + ' AS DATETIME...

This thread will help you out:

http://www.sqlservercentral.com/Forums/Topic739604-360-1.aspx

~Edit : Fixed the IFCodes

Or,

DATEADD(dd, o, DATEDIFF(dd, 0,GETDATE()))

Deepthy, write a CLR procedure (essentially a C# code) to perform the "unpack and validate file" logic and call it in your T-SQL procedure..i cant think of a way to...

Gila is not "HE"... GilaMonster @ Gail Shaw is a girl and SHE is a MVP in SQL Server as well...:-)

taz, I guess the Stored Procedure with a "lock" icon is a CLR procedure.. Just check the definition of the SP....

Try this:

; WITH CTE AS

(

SELECT sum (amt) [SUM] FROM [abc]

)

SELECT T1.ac,T1.bal , T2.[SUM]

FROM [abc] T1

CROSS JOIN CTE T2

WHERE T1.[my_order] = 1

~Edit : Fixed...

ummfish (8/17/2010)

---

I tried to use if-else and it worked. But the real query is much more complicated (two flags, one has two possible values for choosing tables, the other six...

Try dynamic SQL.. build your final query using @Flag...