topic SV:Reload in QlikView https://community.qlik.com/t5/QlikView/Reload/m-p/197040#M56860 <HTML><HEAD></HEAD><BODY><P>Yes, you can use with(Nolock) in your SQL if you are using SQL Server. But I think you need to use "getdate()" function for today.</P><P>/Michael</P></BODY></HTML> Tue, 30 Mar 2010 09:25:03 GMT 2010-03-30T09:25:03Z Reload https://community.qlik.com/t5/QlikView/Reload/m-p/197039#M56859 <HTML><HEAD></HEAD><BODY><P>Sorry for my bad english...</P><P>can i put on the reload script of the QVW file; the report ,</P><P>put in the sql select the following expresion before the table: WITH (NOLOCK) .</P><P>for example</P><P>SQL select * from employees WITH (NOLOCK) where bithday=today();</P><P>thanks..</P></BODY></HTML> Tue, 30 Mar 2010 08:58:48 GMT https://community.qlik.com/t5/QlikView/Reload/m-p/197039#M56859 2010-03-30T08:58:48Z SV:Reload https://community.qlik.com/t5/QlikView/Reload/m-p/197040#M56860 <HTML><HEAD></HEAD><BODY><P>Yes, you can use with(Nolock) in your SQL if you are using SQL Server. But I think you need to use "getdate()" function for today.</P><P>/Michael</P></BODY></HTML> Tue, 30 Mar 2010 09:25:03 GMT https://community.qlik.com/t5/QlikView/Reload/m-p/197040#M56860 2010-03-30T09:25:03Z