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,
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...
can any one help me to refactor this store proc
it seems to me very ugly
ALTER PROCEDURE [dbo].[SearchTransactions]
@SiteId varchar(4)
, @ProviderId int
, @PatientFirstName varchar(35)
, @PatientLastName varchar(60)
, @UnsentTransactionsOnly bit
, @GEDIPayerId varchar(10)
...
I'm trying to use jquery readonly plugin to make all input in div
if (!User.GetWebUser().Permissions.CheckPerm("View/Retrieve RTPA Info"))
$('div.divMemberLookup :input').readonly(true);
I'm very new to jquery
how to do this stuff
any help would be appriciated
I have scenario
I want to save the data into a Name field of give table
First time it save the name
if second I provide same name I want to check if new name is already exist then triger should save new name as name 1 and for next save if name is name 1 it should save as name 2 egc....
my...
Hi I have string like
insert into FaultEvent select id as object_id,
${eventType} as event_type_id, current_timestamp as
timestamp from Ahu((returnAirDewPointTemperature >
(returnAirDewPointTemperatureSetpoint + ${upperDeadband}))
or (returnAirDewPointTemperature <...
I'm have classes and need to make data tables as follow
Class 1
public class EventType
{ public String Id { get; private set; }
public int Severity { get; set; }
public EventTypeTemplate Template { get; set; }
public IDictionary<String, String> Params { get; set; }
public...
I have iis7 I install wcf and when I right click *.svc a drop down shows when I choose browse it does not work
can any one help me what is going wrong with iis
thanks,
How can I write regular expression that
replace
https://localhost/Sm.Services/BatchService.svc/invoke
to
http://localhost:20001/Sm.Services/BatchService/invoke
any help will be nice
thanks,
I have to write a small stuff
that accept a url: like "www.mywebside.com/otherside.html"
myside url address is www.mywebside.com
and it should redirect this request to "otherside.html"
is there any sample that any one share with
thanks,
Hi,
Hope some one help me fast
I need javasript for following scenario
I have one aspform Form1.aspx has two controls Control1.ascx and Control2.ascx
Control2.ascx visbility = false
Now I want Control2.ascx visbilty = true
when I click add button in Control1.ascx
any suggession
Thanks
Hi,
I need to open new window from code behind with out opening open a windows I just want the return value weather window open successfull or error
any suggesstion
thanks,
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.