Ms Sql Server Technology Discussions

[deals2buy]

[quote name='mtkr' timestamp='1355155011' post='1302924367']
...
[/quote]
bhayya koddiga naa question ki answer chudava

[mtkr]

[quote name='deals2buy' timestamp='1355154417' post='1302924307']
bhayya idi work avvatledu
[/quote]


mama oka sari e link chudu.....

[url="http://stackoverflow.com/questions/9180460/update-of-a-column-based-on-max-date-and-group-by"]http://stackoverflow.com/questions/9180460/update-of-a-column-based-on-max-date-and-group-by[/url]

adi nen post chesindhee...


na lst proj lo same ne req e unde....
but i dont remember exact query wch i used... intiki vellaka chusthaa....

[mtkr]

[quote name='deals2buy' timestamp='1355155526' post='1302924432']
bhayya koddiga naa question ki answer chudava
[/quote]

eee wrrk place lo tooo complicated ga undi anni open cheyyadam....

n koncham wrk undhi....

wil try my best 2 provide u an ans..

[mtkr]

[quote name='deals2buy' timestamp='1355155526' post='1302924432']
bhayya koddiga naa question ki answer chudava
[/quote]

here u go...




[size=4][color=#0000ff][color=#0000ff]create[/color][/color] [color=#0000ff][color=#0000ff]table[/color][/color][color=#000000] #test[/color]
[color=#808080][color=#808080]([/color][/color]
id [color=#0000ff][color=#0000ff]int[/color][/color][color=#808080][color=#808080],[/color][/color]
city [color=#0000ff][color=#0000ff]varchar[/color][/color][color=#808080][color=#808080]([/color][/color]100[color=#808080][color=#808080]),[/color][/color]
dt [color=#0000ff][color=#0000ff]datetime[/color][/color]
[color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]select[/color][/color] [color=#808080][color=#808080]*[/color][/color] [color=#0000ff][color=#0000ff]from[/color][/color][color=#000000] #test[/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]values[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]1[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]'ca'[/color][/color][color=#808080][color=#808080],[/color][/color] [color=#ff0000][color=#ff0000]'12/10/2012'[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]values[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]1[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]'tx'[/color][/color][color=#808080][color=#808080],[/color][/color] [color=#ff0000][color=#ff0000]'12/09/2012'[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]values[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]2[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]'va'[/color][/color][color=#808080][color=#808080],[/color][/color] [color=#ff0000][color=#ff0000]'10/10/2000'[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]values[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]2[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]'fl'[/color][/color][color=#808080][color=#808080],[/color][/color] [color=#ff0000][color=#ff0000]'10/10/2010'[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]select[/color][/color] [color=#808080][color=#808080]*[/color][/color] [color=#0000ff][color=#0000ff]from[/color][/color][color=#000000] #test[/color]

[color=#0000ff][color=#0000ff]create[/color][/color] [color=#0000ff][color=#0000ff]table[/color][/color][color=#000000] #test2[/color]
[color=#808080][color=#808080]([/color][/color]
id [color=#0000ff][color=#0000ff]int[/color][/color][color=#808080][color=#808080],[/color][/color]
city [color=#0000ff][color=#0000ff]varchar[/color][/color][color=#808080][color=#808080]([/color][/color]100[color=#808080][color=#808080])[/color][/color]
[color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test2 [/color][color=#0000ff][color=#0000ff]values [/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]1[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]''[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test2 [/color][color=#0000ff][color=#0000ff]values [/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]2[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]''[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]select[/color][/color] [color=#808080][color=#808080]*[/color][/color] [color=#0000ff][color=#0000ff]from[/color][/color][color=#000000] #test2[/color]


[color=#0000ff][color=#0000ff]update[/color][/color][color=#000000] d[/color]
[color=#0000ff][color=#0000ff]set[/color][/color][color=#000000] d[/color][color=#808080][color=#808080].[/color][/color][color=#000000]city [/color][color=#808080][color=#808080]=[/color][/color][color=#000000] f[/color][color=#808080][color=#808080].[/color][/color][color=#000000]city[/color]
[color=#0000ff][color=#0000ff]from[/color][/color][color=#000000] #test2 d[/color]
[color=#808080][color=#808080]inner[/color][/color] [color=#808080][color=#808080]join[/color][/color]
[color=#808080][color=#808080]([/color][/color][color=#0000ff][color=#0000ff]SELECT[/color][/color][color=#000000] city[/color][color=#808080][color=#808080],[/color][/color][color=#000000] id [/color][color=#0000ff][color=#0000ff]FROM[/color][/color][color=#000000] #test [/color]
[color=#0000ff][color=#0000ff]WHERE[/color][/color] dt [color=#808080][color=#808080]IN[/color][/color]
[color=#808080][color=#808080]([/color][/color][color=#0000ff][color=#0000ff]SELECT[/color][/color] [color=#ff00ff][color=#ff00ff]MAX[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]dt[/color][color=#808080][color=#808080])[/color][/color][color=#0000ff][color=#0000ff]FROM[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]GROUP[/color][/color] [color=#0000ff][color=#0000ff]BY[/color][/color][color=#000000] id[/color][color=#808080][color=#808080]))[/color][/color][color=#0000ff][color=#0000ff]as[/color][/color][color=#000000] f[/color]
[color=#0000ff][color=#0000ff]on[/color][/color] d[color=#808080][color=#808080].[/color][/color]id [color=#808080][color=#808080]=[/color][/color] f[color=#808080][color=#808080].[/color][/color]id


[color=#0000ff][color=#0000ff]select[/color][/color] [color=#808080][color=#808080]*[/color][/color] [color=#0000ff][color=#0000ff]from[/color][/color] #test2[/size]

[mtkr]

evaraina sql(t-sql) stored proc no oracle(pl-sql) ki convert cheyyagalaraaa.....[CODE]


CREATE PROCEDURE [dbo].[rsp_Application_Audit_Process]
@Channel Varchar(40),
@StartDate datetime
As
BEGIN
select *
from (
select
'Application Not Received from Siebel' as Problem,
aa.Channel,
aa.HIC,
se.medicare_no,
aa.ReceiveDate,
aa.LastName,
se.last_name as SMM_LastName,
aa.FirstName,
se.first_name as SMM_FirstName,
aa.Address,
aa.City,
aa.State,
aa.Zip,
aa.Phone,
aa.SSN,
aa.DOB,
se.date_of_birth as SMM_DOB,
aa.EffectiveDate,
se.application_id,
se.subscriber_id,
se.hcc_id,
se.cip_id,
SUBSTRING(aa.filename,69,20) as filename,
aa.confirmation_number,
'' AS DCN,
aa.Application_Source,
'MA' as product_type
from
appaudit aa
left join vw_stage_enrollment_cms se on aa.confirmation_number = se.confirmation_number
where se.confirmation_number is null
and aa.channel = 'CMS'
and aa.channel IN (SELECT * FROM dbo.fn_SplitList2(@Channel,','))
and aa.Invalid = 'N'
and( (@StartDate is null) or (aa.ReceiveDateTime >= @StartDate))
and aa.HIC not in (select HIC from AppAudit aa1 inner join vw_stage_enrollment_cms se1 on aa1.HIC = se1.medicare_no where se1.medicare_no is null and aa1.channel='CMS')
)a
UNION
select
'Application Not Received from Siebel' as Problem,
aa.Channel,
aa.HIC,
se.medicare_no,
aa.ReceiveDate,
aa.LastName,
se.last_name as SMM_LastName,
aa.FirstName,
se.first_name as SMM_FirstName,
aa.Address,
aa.City,
aa.State,
aa.Zip,
aa.Phone,
aa.SSN,
aa.DOB,
se.date_of_birth as SMM_DOB,
aa.EffectiveDate,
se.application_id,
se.subscriber_id,
se.hcc_id,
se.cip_id,
SUBSTRING(aa.filename,76,50) as filename,
aa.confirmation_number,
'' AS DCN,
aa.Application_Source,
CASE
WHEN CHANNEL ='INT' THEN
CASE
WHEN CMS_CONT_NO = 'MIPPA' THEN 'MS'
ELSE 'MA'
END
END AS product_type
from
appaudit aa
left join vw_stage_enrollment_cms se on aa.confirmation_number = se.confirmation_number
where se.confirmation_number is null
and aa.channel = 'INT'
and aa.channel IN (SELECT * FROM dbo.fn_SplitList2(@Channel,','))
and aa.Invalid = 'N'
and( (@StartDate is null) or (aa.ReceiveDateTime >= @StartDate))
end
[/CODE]



and the function which it uses is


[CODE]



CREATE FUNCTION [dbo].[fn_SplitList2]
(
@sList varchar(4000),
@sDelim varchar(1)
)
RETURNS @ParsedList TABLE(value varchar(4000) not null)
AS
BEGIN
DECLARE @sValue varchar(4000), @Pos int

SET @sList = RTRIM(@sList) + @sDelim
SET @Pos = CHARINDEX(@sDelim,@sList,1)
IF REPLACE(@sList,@sDelim,'') <> ''
BEGIN
WHILE @Pos > 0
BEGIN
SET @sValue = LTRIM(RTRIM(LEFT(@sList,@Pos - 1)))
INSERT INTO @ParsedList(value) VALUES(@sValue)
SET @sList = RIGHT(@sList, LEN(@sList) - @Pos - LEN(@sDelim) + 1)
SET @Pos = CHARINDEX(@sDelim,@sList,1)
END
END
RETURN
END

[/CODE]

[deals2buy]

[quote name='deals2buy' timestamp='1354740650' post='1302901545']
Two tables unnayi...

Table1:
ID, City

Table2:
ID, Start_Date, End_Date, City


Table1 Data ila undi:

1 NewYork
2 Chicago
3 Los Angeles


Table2 Data ila undi:

1 2012-09-01 2012-10-31 NewYork
1 2012-11-01 2012-12-31 Boston
2 2012-09-01 2012-12-31 Chicago
3 2012-09-01 2012-12-31 Los Angeles




Ippudu nenu Table1 lo unna ID1 ki Boston ani update cheyyali based on the max End Date of Table2


ela cheyyalo ardham kaavatam ledu...

ee error vastondi
Msg 147, Level 16, State 1, Line 1
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
[/quote]
[quote name='DARLING...' timestamp='1354745585' post='1302902184']
Update T1
Set T1.CITY = T2.city
From T2
Where T1.ID = T2.ID And T2.startdate = (Select MAX(T2.startdate) From T2
Where ID = 1)

This will Work
[/quote]
[quote name='deals2buy' timestamp='1354748379' post='1302902437']
nenu example ki oka record esaanu anthe... naadaggara multiple records untai...

also aggregate function filter lo raasthe work avutunda?
[/quote]
[quote name='cool_dude' timestamp='1354749400' post='1302902504']
may be idhi vastundi kavachhu try cheyyu

update T1
SET T1.city =T2.City
From Table1 T1
INNER JOIN
(
Select Id,
max(date),
City
From table2 group by ID)as T2
ON T1.ID=T2.ID
[/quote]
[quote name='cool_dude' timestamp='1354749943' post='1302902540']
Nenu icchina query lo where clause em use chesthalem kadhu bhaiyya..Enduku ala error vastundi..proper ga check chesava query ni..juz asking for conformation...
[/quote]
[quote name='DARLING...' timestamp='1354814571' post='1302905442']
update T1
SET T1.city =T.City
From T1
INNER JOIN
(
Select Id,
max(T2.startdate) Maxstrt,
City
From T2 group by ID, City)as T
ON T1.ID=T.ID

id wokr avtundi soodu
[/quote]
[quote name='mtkr' timestamp='1355156435' post='1302924525']
mama oka sari e link chudu.....

[url="http://stackoverflow.com/questions/9180460/update-of-a-column-based-on-max-date-and-group-by"]http://stackoverflow...te-and-group-by[/url]

adi nen post chesindhee...


na lst proj lo same ne req e unde....
but i dont remember exact query wch i used... intiki vellaka chusthaa....
[/quote]
[quote name='mtkr' timestamp='1355158499' post='1302924759']
here u go...




[size=4][color=#0000ff][color=#0000ff]create[/color][/color] [color=#0000ff][color=#0000ff]table[/color][/color][color=#000000] #test[/color]
[color=#808080][color=#808080]([/color][/color]
id [color=#0000ff][color=#0000ff]int[/color][/color][color=#808080][color=#808080],[/color][/color]
city [color=#0000ff][color=#0000ff]varchar[/color][/color][color=#808080][color=#808080]([/color][/color]100[color=#808080][color=#808080]),[/color][/color]
dt [color=#0000ff][color=#0000ff]datetime[/color][/color]
[color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]select[/color][/color] [color=#808080][color=#808080]*[/color][/color] [color=#0000ff][color=#0000ff]from[/color][/color][color=#000000] #test[/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]values[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]1[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]'ca'[/color][/color][color=#808080][color=#808080],[/color][/color] [color=#ff0000][color=#ff0000]'12/10/2012'[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]values[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]1[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]'tx'[/color][/color][color=#808080][color=#808080],[/color][/color] [color=#ff0000][color=#ff0000]'12/09/2012'[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]values[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]2[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]'va'[/color][/color][color=#808080][color=#808080],[/color][/color] [color=#ff0000][color=#ff0000]'10/10/2000'[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]values[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]2[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]'fl'[/color][/color][color=#808080][color=#808080],[/color][/color] [color=#ff0000][color=#ff0000]'10/10/2010'[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]select[/color][/color] [color=#808080][color=#808080]*[/color][/color] [color=#0000ff][color=#0000ff]from[/color][/color][color=#000000] #test[/color]

[color=#0000ff][color=#0000ff]create[/color][/color] [color=#0000ff][color=#0000ff]table[/color][/color][color=#000000] #test2[/color]
[color=#808080][color=#808080]([/color][/color]
id [color=#0000ff][color=#0000ff]int[/color][/color][color=#808080][color=#808080],[/color][/color]
city [color=#0000ff][color=#0000ff]varchar[/color][/color][color=#808080][color=#808080]([/color][/color]100[color=#808080][color=#808080])[/color][/color]
[color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test2 [/color][color=#0000ff][color=#0000ff]values [/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]1[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]''[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]insert[/color][/color] [color=#0000ff][color=#0000ff]into[/color][/color][color=#000000] #test2 [/color][color=#0000ff][color=#0000ff]values [/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]2[/color][color=#808080][color=#808080],[/color][/color][color=#ff0000][color=#ff0000]''[/color][/color][color=#808080][color=#808080])[/color][/color]
[color=#0000ff][color=#0000ff]select[/color][/color] [color=#808080][color=#808080]*[/color][/color] [color=#0000ff][color=#0000ff]from[/color][/color][color=#000000] #test2[/color]


[color=#0000ff][color=#0000ff]update[/color][/color][color=#000000] d[/color]
[color=#0000ff][color=#0000ff]set[/color][/color][color=#000000] d[/color][color=#808080][color=#808080].[/color][/color][color=#000000]city [/color][color=#808080][color=#808080]=[/color][/color][color=#000000] f[/color][color=#808080][color=#808080].[/color][/color][color=#000000]city[/color]
[color=#0000ff][color=#0000ff]from[/color][/color][color=#000000] #test2 d[/color]
[color=#808080][color=#808080]inner[/color][/color] [color=#808080][color=#808080]join[/color][/color]
[color=#808080][color=#808080]([/color][/color][color=#0000ff][color=#0000ff]SELECT[/color][/color][color=#000000] city[/color][color=#808080][color=#808080],[/color][/color][color=#000000] id [/color][color=#0000ff][color=#0000ff]FROM[/color][/color][color=#000000] #test [/color]
[color=#0000ff][color=#0000ff]WHERE[/color][/color] dt [color=#808080][color=#808080]IN[/color][/color]
[color=#808080][color=#808080]([/color][/color][color=#0000ff][color=#0000ff]SELECT[/color][/color] [color=#ff00ff][color=#ff00ff]MAX[/color][/color][color=#808080][color=#808080]([/color][/color][color=#000000]dt[/color][color=#808080][color=#808080])[/color][/color][color=#0000ff][color=#0000ff]FROM[/color][/color][color=#000000] #test [/color][color=#0000ff][color=#0000ff]GROUP[/color][/color] [color=#0000ff][color=#0000ff]BY[/color][/color][color=#000000] id[/color][color=#808080][color=#808080]))[/color][/color][color=#0000ff][color=#0000ff]as[/color][/color][color=#000000] f[/color]
[color=#0000ff][color=#0000ff]on[/color][/color] d[color=#808080][color=#808080].[/color][/color]id [color=#808080][color=#808080]=[/color][/color] f[color=#808080][color=#808080].[/color][/color]id


[color=#0000ff][color=#0000ff]select[/color][/color] [color=#808080][color=#808080]*[/color][/color] [color=#0000ff][color=#0000ff]from[/color][/color] #test2[/size]
[/quote]



[color=#ff0000][size=5]Finally, I got the output I needed. Posting the query which I've used:[/size][/color]

UPDATE T1
SET T1.City = ISNULL((select top 1 City from Table2 T2 where T2.ID = T1.ID order by T2.End_Date DESC),T1.City) FROM Table1 T1


everyone for actively helping me out

[cool_dude]

Calling all SSRS/DBA thopu's...Naa issue jara solve cheyyandi dudes.....
This is wt the error I am getting in Report Manager

[size=2][i]An error occurred during client rendering.[/i][/size]
[size=2][i]An error has occurred during report processing.[/i][/size]
[size=2][i]Query execution failed for dataset 'Rank_Prior'.[/i][/size]
[size=2][i]For more information about this error navigate to the report server on the local server machine, or enable remote errors[/i][/size]

[size=3][font=Verdana]When I am running the report in Visual Studio in report viewer naaku report manchiga execute avtundi without errors. Kani Adhe Report manager lo run chesthe ala paina vachhina error vastundi. 2-3 times refresh chesaka report is running in report manager. What could be the problem..Plz help me guys...[/font][/size]

[cool_dude]

[quote name='deals2buy' timestamp='1355171764' post='1302926630']
[color=#ff0000][size=5]Finally, I got the output I needed. Posting the query which I've used:[/size][/color]

UPDATE T1
SET T1.City = ISNULL((select top 1 City from Table2 T2 where T2.ID = T1.ID order by T2.End_Date DESC),T1.City) FROM Table1 T1


everyone for actively helping me out
[/quote]

WOW..Good that u got the solution for the query.Tnq for the query bhaiyya..Rock ON

[deals2buy]

[b] Asynchronous Update and Timestamp – Check if Row Values are Changed Since Last Retrieve[/b]


USE tempdb
GO
CREATE TABLE SampleTable (ID INT, Col1 VARCHAR(100), TimeStampCol TIMESTAMP)
GO
INSERT INTO SampleTable (ID, Col1)
VALUES (1, 'FirstVal')
GO
SELECT ID, Col1, TimeStampCol
FROM SampleTable st
GO
UPDATE SampleTable
SET Col1 = 'NextValue'
GO
SELECT ID, Col1, TimeStampCol
FROM SampleTable st
GO
DROP TABLE SampleTable
GO

Now let us see the resultset.
[img]http://www.pinaldave.com/bimg/timestamp.jpg[/img]

Here is the simple explanation of the scenario. We created a table with simple column with TIMESTAMP datatype. When we inserted a very first value the timestamp was generated. When we updated any value in that row, the timestamp was updated with the new value. Every single time when we update any value in the row, it will generate new timestamp value.

Now let us apply this in an original question’s scenario. In that case multiple users are retrieving the same row. Everybody will have the same now same TimeStamp with them. Before any user update any value they should once again retrieve the timestamp from the table and compare with the timestamp they have with them. If both of the timestamp have the same value – the original row has not been updated and we can safely update the row with the new value. After initial update, now the row will contain a new timestamp. Any subsequent update to the same row should also go to the same process of checking the value of the timestamp they have in their memory. In this case, the timestamp from memory will be different from the timestamp in the row. This indicates that row in the table has changed and new updates should not be allowed.

I believe timestamp can be very very useful in this kind of scenario.

[lolliman]

[Kakateyudu]

[img]http://www.desigifs.com/sites/default/files/Brahmi-8.gif?1349015951[/img]

[cool_dude]

[quote name='cool_dude' timestamp='1355177115' post='1302927650']
Calling all SSRS/DBA thopu's...Naa issue jara solve cheyyandi dudes.....
This is wt the error I am getting in Report Manager

[size=2][i]An error occurred during client rendering.[/i][/size]
[size=2][i]An error has occurred during report processing.[/i][/size]
[size=2][i]Query execution failed for dataset 'Rank_Prior'.[/i][/size]
[size=2][i]For more information about this error navigate to the report server on the local server machine, or enable remote errors[/i][/size]

[size=3][font=Verdana]When I am running the report in Visual Studio in report viewer naaku report manchiga execute avtundi without errors. Kani Adhe Report manager lo run chesthe ala paina vachhina error vastundi. 2-3 times refresh chesaka report is running in report manager. What could be the problem..Plz help me guys...[/font][/size]
[/quote]

Dhiniki inka answer evru cheppaledhu..
jara sepapndi babulu..Ikkada picchi ekkutundi naaku....

[Desamudhuru]

[quote name='cool_dude' timestamp='1355251000' post='1302932279']

Dhiniki inka answer evru cheppaledhu..
jara sepapndi babulu..Ikkada picchi ekkutundi naaku....
[/quote]
try sestha baa..

[cool_dude]

[quote name='Desamudhuru' timestamp='1355251173' post='1302932305']
try sestha baa..
[/quote]

Tnq dude..

[chelsea]

[quote name='cool_dude' timestamp='1355251000' post='1302932279']

Dhiniki inka answer evru cheppaledhu..
jara sepapndi babulu..Ikkada picchi ekkutundi naaku....
[/quote]

Connection string correct ichavu chudu ba Mostly BIDS lo run aithe ikkada koda run avvali nuvu shared datasource use chesava