Viewing 15 posts - 3,916 through 3,930 (of 15,381 total)
joduvil (9/3/2014)
You're the best! IT WORKS!! I appreciate for your positive attitude and resolving this weird requirement from our client. Thanks a ton.
You are welcome. I hope you take...
September 4, 2014 at 7:26 am
Or you could just leave those columns out of the view entirely. If you are truly concerned about the data you might consider a constant for both names instead of...
September 3, 2014 at 2:16 pm
OK here we go. This has to be one of the absolute scariest situations I have ever heard of. A truly bizarre "key" and sales people with access to SSMS...
September 3, 2014 at 2:11 pm
Koen Verbeeck (9/3/2014)
Bah. I couldn't resist it.
Did he go "we we we all the way home???" :-D:-D:-D
September 3, 2014 at 1:25 pm
joduvil (9/3/2014)
Yes.. inserting manually from their end - directly into table through statements
Why in the world are you allowing sales people to manually create and execute insert statements??? Not only...
September 3, 2014 at 11:02 am
Lynn Pettis (9/3/2014)
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
September 3, 2014 at 10:03 am
joduvil (9/3/2014)[/b
Manually : Sales team receiving leads from different sources and collecting the same and inserting into table manually.
Meaning your sales teams has SSMS and is creating these insert queries...
September 3, 2014 at 10:03 am
joduvil (9/3/2014)
Yes It is dynamic value and the ID will change during insert according to above conditions.
There are lots of end users who were inserting data into this...
September 3, 2014 at 9:36 am
Let's start with some formatting so we can read it. You can use these types of windows by looking the IFCode Shortcuts on the left side when posting.
CREATE PROCEDURE [dbo].[DELIVERY]...
September 3, 2014 at 9:18 am
Since you have to proceed with this I would look into using a computed column instead of trying to do this in a trigger. Is this value supposed to be...
September 3, 2014 at 9:14 am
joduvil (9/3/2014)
Company name (First three character)
City (First Three...
September 3, 2014 at 8:47 am
The solution posted will work but I am concerned about the WHY you are doing this. This seems like you are ending up with multiple values in your column now....
September 3, 2014 at 8:35 am
Gazareth (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
September 3, 2014 at 8:29 am
Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1610013-360-1.aspx
September 3, 2014 at 8:28 am
TomThomson (9/2/2014)
Sean Lange (9/2/2014)
Lynn Pettis (9/2/2014)
AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.
In my experience nearly 95% of the people in this business...
September 3, 2014 at 7:14 am
Viewing 15 posts - 3,916 through 3,930 (of 15,381 total)