David,

you have just specified the datatypes for the inputs.

there are many decimals in the result ,as u haven't restricted the decimal places for output

do the below

declare @dividend decimal(12,5),@divisor decimal(12,5)

declare @output...

U have to specify the decimal places

Runt the below ...U will get the expected result

declare @dividend decimal(12,5),@divisor decimal(12,5)

set @dividend='105.12345425'

set @divisor='7.2654859425'

select @dividend/@divisor

twin.devil (9/2/2014)

---

Indu-649576 (9/2/2014)

---

IS there any way I can use the below

Select X.* From TABLE X

INNER JOIN

(case when (condition) then TABLE A else TABLE B end) AS Y

ON X.Col1...

LutzM (8/23/2014)

---

You need to apply the cast to varchar inside the dynamic SQL. Otherwise you're only converting the dynaic statement, not the result.

declare @result varchar(max)

set @result = ('select cast((select *...

LutzM (8/23/2014)

---

What do you mean by "It is not casting to varchar"?

Do you get any error message?

Can you provide a test scenario so we can reproduce the result you're...

Sorry now the error is

Server 'FDOPROD1\FDOPROD1' is not configured for DATA ACCESS

OH ..ok thanks..

Koen Verbeeck (8/18/2014)

---

Indu-649576 (8/18/2014)

---

Koen Verbeeck (8/18/2014)

---

This works fine:

DECLARE @b-2 INT;

DECLARE @action VARCHAR(100);

DECLARE @dbname VARCHAR(100);

DECLARE @a INT;

SET @dbname = 'adt';

SET @action = 'dfgf';

SET @a =...

Koen Verbeeck (8/18/2014)

---

This works fine:

DECLARE @b-2 INT;

DECLARE @action VARCHAR(100);

DECLARE @dbname VARCHAR(100);

DECLARE @a INT;

SET @dbname = 'adt';

SET @action = 'dfgf';

SET @a = 14;

SET

Koen Verbeeck (8/18/2014)

---

I consider leaving out length specifications for strings (and leaving it up...

@Action already set in quotes ,then why od we need to have quotes again the dynamic query?

Yes ....Plz close this discussion..

Im okkkkkkkkkk to use row number as there doesn't seems to be better option..

Thanks to all

I really don't like this temp table creation as in my code I have to use this logic of row number multiple times..

Tell me if there are any other ideas

I really don't understand the CLR /CTE concepts ..somebody ..plz explain

I have gone through the example

But my concern is how can we loop through all the values of a column with out having cursor in the above example?

Thanks,

Priya.