You are very welcome 🙂

sql4us (9/1/2011)

---

Thank you so much...Now it makes sense. I have one more question

I want to include all column names to display

For ex:

Zipcode West East North South maxvalue Colname

00001 ...

Almost there 🙂

Two things to consider:

1. Your order by clause should only include the maxvalue column and not the zip code.

2. Encapsulate your whole query in a cte, and then...

sql4us (9/1/2011)

---

I have 30,000 records..I almost got it but if you saw my code and results it shows all the values for the same zipcode. I just need max value,...

If you have a limited number of columns, you could use a case statement. Alternatively, try using a cte to "normalize" the data before aggregating.

Yes.

It is possible to do something like this with recursive cte's.

This is what I managed to come up with, and I think it will do what you need it...

luismarinaray (8/31/2011)

---

use AGENCYFORM

GO

Select BB.ORDENV,BB.acountcode,BB.Description,

(select cc.balance from dbo.MOV AS cc

where

cc.accountcode=BB.acountcode and

cc.month='03' and

cc.form='F' and

cc.codeagency='05961'

) as

'05961'

from dbo.T_PLANT1 AS BB

I'm now interested that codeagency be dynamic, but this code is...

Data Conversion Task in your SSIS dataflow.

Excel destinations can only accept unicode data. You will have to convert your text file data to unicode first.

No problem 🙂

Remember that the "inserted" table contains ALL values that were updated/inserted.

Rather try this:

CREATE TRIGGER [trg_test]

ON test

FOR INSERT,UPDATE

AS

begin

insert into Test_Audit(test_id)

(

select test_id

from inserted

)

end

I'm not sure that I...

Sure...no problem 🙂

Auditors usually have finding/recommendation checklists with standard responses. While the auditor's comment does have some value and significance, it fails to take all factors into consideration (especially the...

Try this:

create function [dbo].[Split_Values]

(

@String varchar(4000)

,@Delimiter varchar(5)

)

returns @Split_Values table(String_Value varchar(200))

as

begin

declare @Split_Length int

while len(@String) > 0

begin

select @Split_Length =case charindex(@Delimiter,@String)

when 0 then len(@String)

else charindex(@Delimiter,@String) - 1

end

insert into @Split_Values

(

String_Value

)

(

selectsubstring(@String,1,@Split_Length)

)

select @String =case (len(@String) -...