Try the following

DECLARE @REAL1 float

SET @REAL1 = 163773.58

DECLARE @real float

SET @real = @REAL1

select @real

used float instead of real

If you still want order by in both querries use inner querry, but ideally using order by at the end of the both querries should also work for you

This is may be because of higher report body width

It should be 1,5,2,3,3,2

U can get it using ModifiedDate property

I dont think it is a relavent question.

As if u direct execute them how do u get data into inserted..... tables.

So, it can not be allowed to do like that.

It is not a glitch....

It is working fine...

As a nature the input is truncated to variable definition length10

So it is returning 10letters only

Can u pl help in letting me know what r the manual changes to be made?

Thanks in Advance

Giri

Thanks for your reply.

I tried the same and found that the columns added in detail part of matrix table were reflecting under each year as columns.

Let me know if u...

if u can send me the result or script of function......

SELECT * FROM dbo.someStringSplitFunction('String To Split', 'Delimiter')

then some way can be sugested.........

? exactly u r looking for?

hi........... try the below querry

select distinct month_yr,

convert(datetime,'01/' + month_yr,101) from emp_dd

u can try using below syntax in where clause

where len(colname) < 12

--try with this code

CREATE Procedure Search

@TicketID int

AS

BEGIN

IF (@TicketID>0)

BEGIN

SELECT * from Tickets

WHERE UserID= '10' AND TicketID=@TicketID

END

ELSE

BEGIN

...

just add index on the sort column, it will help ur querry and then it will be same on both the servers