Hi Adi,

Fine for the convert into varchar, but

OP shows convert to timestamp

ARUN SAS

Hi,

You need to convert the records from the date time to timestamp or change the table column schema from date time to timestamp?

ARUN SAS

ezhil (5/3/2009)

---

Hi,

Can u suggest be better way(based on performance) to split by comma delited string.

Input:

String - 1,'Joy'~2,'Jack'~3,'Rozy'

Expected Result:

As Table

ID Name

1 Joy

2 ...

Hi,

select AVG(C_ProfitPercentage)AVG_C_ProfitPercentage from

(

SELECT

J.JobID,

/*YOUR SELECT*/ AS C_ProfitPercentage

FROM Jobs J

)AS X

WHERE C_ProfitPercentage <= 20.00

ARUN SAS

Hi,

Try this

select * from

(

SELECT

J.JobID,

/*YOUR SELECT*/ AS C_ProfitPercentage

FROM Jobs J

)AS X

WHERE C_ProfitPercentage > 20

ARUN SAS

Hi,

also try this

select a.ItemName,a.ItemCost,a.ItemCostDate from #Items a,

(SELECT distinct ItemName,max(ItemCostDate)ItemCostDate FROM #Items

group by ItemName)as b

where a.ItemName = b.ItemName

and a.ItemCostDate = b.ItemCostDate

ARUN SAS

Hi,

in your side OVER / PARTITION works or not?

ARUN SAS

WHY?

Your in 2005 or in 2000?

ARUN SAS

Hi,

try this sp

create procedure Spinrun (@Parameter varchar(90))

as

begin

create table #temp

(

eventtype nvarchar(30),

Parameters int,

EventInfo nvarchar(255)

)

declare @SPID varchar(10)

DECLARE OPENTRANS CURSOR FOR

SELECT SPID from master.dbo.sysprocesses (nolock)

OPEN OPENTRANS

FETCH NEXT FROM OPENTRANS into @SPID

WHILE @@FETCH_STATUS...

mithun.gite (4/29/2009)

---

hi viswa,

Good morning...

Before u read on make sure that there will be always only 2 decimals will be there in ur values and i wrote it in bit of...

Hi,

try this sp

create procedure XYZ (@A int)

as

begin

1) Select * from table

where

and @A is null or @A = ''

2) Select * from table

where

and @A is not null or...

Hi,

What kind of the data type used (for the records) to insert?

And show the existing table schema

ARUN SAS

Hi,

use the SPACE(10) instead of the CHAR(10)

SELECT @vSQL='BULK INSERT dbo.Source FROM ' + ''''+@v_Path +''''

+ ' ' + 'WITH (FIELDTERMINATOR = '+''''+','+''''+' ,ROWTERMINATOR = '''+space(10)+''')'

ARUN SAS

Hi Steve,

Post your full statement which you write

Meanwhile try this

select year(order_Dt),month(order_Dt),count(order_No) from Order_table

where order_Dt between dateadd(year,-1, getdate()) AND getdate()

GROUP BY year(order_Dt),month(order_Dt)

ORDER BY year(order_Dt),month(order_Dt)

ARUN SAS

Hi,

How can we handle this reversal of pivoting in 2000?

ARUN SAS