Viewing 15 posts - 4,471 through 4,485 (of 5,678 total)
On this portion:
from NCV_BL_DHL_TEMP a
INNER JOIN
DHL_TRADE_ASSIGNMENT b
on a.POL_COUNTRY_CD = ltrim(rtrim(substring(b.COUNTRY_CD,1,2)))
INNER JOIN DHL_TRADE_ASSIGNMENT c
on a.POD_COUNTRY_CD = ltrim(rtrim(substring(c.COUNTRY_CD,1,2)))
You'll need your join code to handle the AND/OR switching you'll need to do.
Please...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 6, 2011 at 12:35 am
I agree with the above, but in case you're not quite willing to spill your guts for whatever reason, for anyone else who's interested in these topics:
vinodh247 (1/5/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 6, 2011 at 12:21 am
Koen (da-zero) (1/5/2011)
GilaMonster (1/5/2011)
Koen (da-zero) (1/5/2011)
I have never understood the fuzz about "division by zero". It is possible, it just doesn't return a normal number.
However if you allow it,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 11:06 am
rizkhan92 (1/5/2011)
But i couldn't found any answer related to this table OHEM..
so please guide me what should i have to...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 3:42 am
What I wish to accomplish is only display data for either FRN or FRS. If the country code begins with FR(France) in the POL_COUNTRY_CD or POD_COUNTRY_CD column in NCV_BL_DHL_TEMP table...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 3:35 am
First, tertiusdp needs to be thanked for making consumable sample data.
Now, for the code. I modified the sample data to remove the typo:
IF OBJECT_ID('tempdb..#tbl1') IS NOT NULL
DROP TABLE #tbl1
IF...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 3:27 am
violation is coming from this statement (it's the only insert/update):
Insert Into SBO_Rehnuma.dbo.OHEM(empid,jobTitle,
firstName,middleName,lastName,
sex,dept,branch,
workStreet,workBlock,workZip,workCountr,
officeTel,mobile,homeTel,
email,startDate,status,
salary,termDate,
bankCode,bankBranch,bankAcount,
homeStreet,homeBlock,homeZip,
homeCountr,birthDate,
govID,U_JobTitle,U_EmpName,position)
Values( @EmpID,@EmpCode,
@FName,@MName,@LName,@Sex,@DeptCode,@branch,
@CAddress1,@CAddress2,@Work_Zip,'PK',
@OfficeTel,@hometel,@mobile,@email,@StartDate,
@Status,@Salary,@termdate,@bankcode,@bankBranch,@bankAccount,
@PAddress1,@PAddress2,@home_Zip,'PK',
@birthdate,@govID,@JTitle,@U_Name,@DesgCD)
We'll need to see the DDL on table SBO_Rehnuma.dbo.OHEM to answer your question. Check out the first...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 2:53 am
Duplicate post, please send all replies to:
http://www.sqlservercentral.com/Forums/Topic1042892-391-1.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 2:50 am
Sebastian,
In the sample data you included this:
1 dog a
2 dog c
3 dog b
4 dog d
4 dog a
5 dog c
6 dog c
Note, the 4 for dog d and a is repeated....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 2:44 am
You're looking to recursion a cascade delete? Yikes.
Does this HAVE to be a trigger? Can you do this from a called proc level or are you doing this...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 2:36 am
Koen (da-zero) (1/5/2011)
Dave Ballantyne (1/4/2011)
On drilling into C++ from C#, I know now why C# is so called "word...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 2:31 am
Junglee_George (1/5/2011)
Hi..Try thisselect cast(datediff(yyyy, '2006-01-01', '2008-01-01') as varchar) + 'Y : '
+ cast(datediff(mm, '2006-01-01', '2008-01-01') as varchar) + 'M : '
+ cast(datediff(dd, '2006-01-01', '2008-01-01') as varchar) + 'D'
Right...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 2:24 am
panwar.jt (12/21/2010)
As per my understanding we can't alter a datetime column directly into numeric type. So I convert frist into varchar(8) then to Numeric.
Thanks for your...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 2:16 am
JayK (1/4/2011)
In youe extract is says : "When no profile_name is specified, sp_send_dbmail uses the default private profile for the current user."
But in my...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 5, 2011 at 2:09 am
I wonder if it's bogging up on the Profile name.
From here: http://msdn.microsoft.com/en-us/library/ms190307.aspx
[ @profile_name= ] 'profile_name'
Is the name of the profile to send the message from. The profile_name is of type...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 4, 2011 at 5:05 pm
Viewing 15 posts - 4,471 through 4,485 (of 5,678 total)