|
Yet he remains optimistic that some one will help
|
|
|
|
|
|
hmmm, is that why I always got hungry and started drooling when the school bell rang?
|
|
|
|
|
Thanks for all, my challenge is the below code. If I am not using it then SP is taking 6 seconds to get data and after using it, taking more then 1 min
Please do you have any idea to optimize it
----------------------------------------------------
Update TMP1
Set DriverID = FDR.DriverID,
CompanyID = CDT.CompanyName
from @TempTable1 TMP1
Inner Join (Select FaxID, CompanyID, LTrim(Replace(Stuff((Select ', ' + ISNULL(Cast(FD1.DriverID as varchar(10)),'') From FaxId_Document_Relation FD1 Where FD1.FaxID = FD2.FaxID For XML PATH ('')),1,1,''),' ,','')) as DriverID
From FaxId_Document_Relation FD2
Where FaxID in (select FaxID from @TempTable1)
Group By FaxID, CompanyID) as FDR ON TMP1.FaxID = FDR.FaxID
--Inner Join CustomerDetails CDT on CDT.CompanyID = FDR.CompanyID --Anoop
Inner Join (select CompanyID, CompanyName from CustomerDetails) as CDT on CDT.CompanyID = FDR.CompanyID
|
|
|
|
|
What part of this:
Quote: Start by reading the text at the top of the page and you will see in bright red letters that this isn't the place for technical queries. So if you want to make people happy, post this in the right place. Happy people give better help than annoyed ones do...
did you assume does not apply to you?
You have been told, you ignore it.
You are showing yourself to be rude, arrogant, and uncaring. Why the heck should we try to help you if you just assume that the rules do not apply to you?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Sir, I optimized now and time decrease from 35 secs to 6 secs...
Thanks for your valuable support...
|
|
|
|
|
OriginalGriff wrote: did you assume does not apply to you?
Apparently not. He posted the question and somehow his problem got fixed without one post that addressed it.
I wonder if I can get code written for myself the same way?
|
|
|
|
|
ya know what would really get it?
That (in Unicode and therefore .net) NULL-characters are allowed in strings yet aren't considered whitespace.
modified 5-Apr-18 17:31pm.
|
|
|
|
|
|
You rotten so and so - I followed your link and seriously though "that can't be right"
I then used google and it made a lot more sense.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
A NULL character is part and parcel of a string. Otherwise you need some form of counted string,, otherwise the length is undetermined.
modified 5-Apr-18 4:14am.
|
|
|
|
|
The string is over when the fat lady sings.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
In .Net, string is a class, and has a length variable, so can contain NULL in the middle. Just like the std::string class in C++.
FWIW, I thought the Pascal style of having the length in the first char was quite neat (though that limited it to strings of < 255 characters).
|
|
|
|
|
Like the UNICODE_STRING we use in the kernel, it contains a length member and a pointer to the string data.
Orjan Westin wrote: can contain NULL in the middle
SOunds a bit like a multi string, nulls in the middle, ,two at the end.
Why would you want a null in the middle of a string though? How does it make it useful?
|
|
|
|
|
If you have a good old VT-52, it finally gets something it can safely ignore:
Quote: <nul> 00 Null Never affects the device. <nul> codes are always ignored wherever they appear in the character stream.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
PIEBALDconsult wrote: aren't considered whitespace
Take it up with the Unicode consortium. NULL is defined as a control character[^], not a space character[^]. It would be rather perverse for .NET to ignore that categorisation.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I'll update my rant to blame Unicode.
|
|
|
|
|
Howdy y'all - been away for a bit.
Last year was "The Year of the Hip" as in I had both of my hips replaced. One in June, the second in November. Lot's of PT but both successful - ZERO hip pain today.
A week and a half ago I had the first knee replacement done. Unlike the hips it was done on an outpatient basis. Arrived at the surgical center at 5:30am, surgery complete by 9:00am, discharged around 1:30pm. Crazy!
Used crutches for a few days and opioids for a few more days. PT is harder with a knee than it was with the hip but it's not brutal (yet).
Not sure when exactly I'll do the second knee but probably sooner rather than later. I can't wait to be able to walk without pain.
#RASucks
|
|
|
|
|
a few nuts and bolts closer to a RoboCop!!
I'd rather be phishing!
|
|
|
|
|
In and out in a day for a knee replacement is pretty quick. In NZ they like you to be in hospital for a few days as one critical aspect of recovery is the right exercises by physios to get the joint working as quickly as possible. Without the exercises the recovery can take significantly later then it should.
Good luck. I hope all goes well.
A Fine is a Tax for doing something wrong
A Tax is a Fine for doing something good.
|
|
|
|
|
1-2 days is fairly normal here too. Doing it outpatient is pretty new and certainly not the norm.
They've found that staying out of the hospital increases healing and patient attitude and reduces the chances of infection.
I actually had my first PT at the surgical center before discharge and started outpatient PT within 2 days. Could have started with home PT but I discovered (hip #1) that the locals that do that in my area are idiots.
|
|
|
|
|
Did you tell them "I will be back" as Arnold?
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
Mike Mullikin wrote: Last year was "The Year of the Hip" as in I had both of my hips replaced. One in June, the second in November. Lot's of PT but both successful - ZERO hip pain today.
A week and a half ago I had the first knee replacement done. Unlike the hips it was done on an outpatient basis. Arrived at the surgical center at 5:30am, surgery complete by 9:00am, discharged around 1:30pm. Crazy!
Faarrrkkkk!!! You are falling apart at a rapid rate. From memory you are only 54, at this rate you will be about 80% artificial by 60.
Have you thought about changing your name to Steve Austin and moving around in slow motion with a cheesy soundtrack in the background?
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
|
|
|
|
|
Has Anyone Seen Mike Hunt wrote: Steve Austin
Stone cold?
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
lw@zi wrote: Stone cold?
No. The Six Million Dollar Man was a TV show back in the 70's that Mike will know. The main character was rebuilt, also known as the Bionic Man.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
