I have store proc giving me deadlock issue
looks like I need to work with lock hinds
if some on can look at and help me to solve the problem
ALTER PROCEDURE [dbo].[sp_CNVRT_GetNextNewJob]
@nJob_ID AS BIGINT OUTPUT,
@sSrcFileSpec AS NVARCHAR(260) OUTPUT,
@sDestFileSpec AS NVARCHAR(260)...
How can I write this to linq
first I'm doing
XElement root = doc.MainDocumentPart.GetXDocument().Root;
then
var query = from c in root.Descendants(W.p) select c;
then
foreach (XElement p in query)
{
XElement pElement = p.Descendants(w + "pStyle").FirstOrDefault() ...
I need to index the database but there is not a unique field to set the primary key on. All fields have duplicate values in them. If I do not index the database then trying to move around in the database is very slow. . All of the fields have duplicated data.
any one has ideas how to do it
thanks
I have a column in database "unittype"
it contains string value
like
"units"
"minutes"
I'm unig textbox.text = unittype
I want to use regex like
textbox.text = regex.replace(unittype)
to set unittype value from units or minutes to Unit(s) or Minute(s) for display
thanks,
var d = new Date();
d.setTime(d.getTime() - (d.getDay() ? d.getDay() : 7) * 24 * 60 * 60 * 1000);
jQuery("#DateTo").datepicker("setDate", d);
d.setTime(d.getTime() - 6 * 24 * 60 * 60 * 1000);
jQuery("#DateFrom").datepicker("setDate", d);
I have to support ie and foxpro as well
thanks
Thank you very much for your reply
but it is giving me
start last week=== Last week thursday's date (02/02/2012).
end last week == last week today's date (tuesday (02/07/2012).
what I need
start last week=== Last week Monday's date (start from Monday.. e.g 1/30/2012)
end last week ==...
I have two input fields and want to fill these fields as
start last week=== Last week Monday's date
end last week == last week sunday's date
any help would be nice...
thank you...
Qik3Coder
then how to write this logic in your way
IF @TypeOfDateSearch = 'Date Of Service' BEGIN IF @DateSearchFrom IS NOT NULL SET @SQL = @SQL + ' AND q.DateOfServiceFrom >= @DateSearchFrom' + CHAR(13) + CHAR(10); IF...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.