It is correct, if there is any open transaction while executing the Rollback transaction command.

Check if any transactions are open after commiting transaction by using this command

SELECT @@TRANCOUNT.

If you get...

Hi

You can use the following query:

DECLARE @CSV_String VARCHAR(2000)

SET @CSV_String = 'UNIPAR LLC , IAE Power Products , MID-AM Equipment Inc.

, Diesel Electrical Equipment, Inc. , K & L Electronics...

i think u can solve the problems using Synonyms

use master

go

alter procedure p1

@dbname varchar(100)

as

begin

--<<<< is there any way i can change the db context over here>>>

IF...

Here is the DDL Script in case if any body wants it.

declare @tab table(ClientID int, Act varchar(6), Deposit varchar(6), TransactionDate DateTime)

insert into @tab values (100, 'A-123',...

Hi Gsquared

Thank you very much for the explanation.

You are most welcome

SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY]

Check this link for further references

http://www.sql-server-helper.com/tips/date-formats.aspx

Hi Gsquared

Thanks for correcting me

I was thinking the if @imported is null

so this 'DailysettlementYN = @imported' will fetch the rows containing only the rows having DailysettlementYN as NULL and...

Add this code in ur proc

declare @crds_DueAmount_prev float

select top 1 @crds_DueAmount_prev = crds_DueAmount from ISV_CreditSettlement

WHERE crdp_CreditDepositID = @crds_CreditDepositID

order by crds_CreditSettlementID desc

...

GSquared (12/27/2010)

---

I must be missing something if this won't work:

DECLARE @imported BIT;

SELECT @imported = null;

SELECT *

FROM #M_Vendor

WHERE DailysettlementYN = @imported

OR @imported IS NULL;

Change the value of the variable, as if...

There is also an 'as' between there

'tipo_mon, 'as' descr_mon '

this might also be the cause of ur problem

It seems like you have 2 different columns EditingDt and testDate.

So case in one column has nothing to do with cast in another column.

What is the datatype of t.STRT_DTM, t.END_DTM...

Hi New Commer

I agree with kingston for not using varchar for date.

And try to minimize datatype conversion

If ur date columns are same as the dafault format of sql server then...

Sorry New Commer for the previous code

Please use the following code

It will give u the desired result.

DECLARE @CYBeginDate smalldatetime, @CYEndDate smalldatetime,

@LYBeginDate smalldatetime, @LYEndDate smalldatetime

Declare @para datetime

set @para =...

Kingston u r right

this code will not work if the date fall in first 3 months of the year

Thanks for pointing it out

I will put an updated code