Viewing 15 posts - 46 through 60 (of 263 total)
Great to hear your company were happy to give you the summer off Steve, last year my company gave me a 12 week sabatical between June and September to get...
July 25, 2014 at 1:31 am
yep exactly, within a few seconds it would seem. It may be a completely random unrelated intermittent issue which just so happens to have occurred at those times but I...
June 13, 2014 at 6:20 am
Thanks Koen,
Sleep mode is disabled and I've even told the network adapter never to shut off now.
It would appear it's doing it even if the SSIS application looses focus -...
June 13, 2014 at 5:56 am
KFC; It's Fast food. It's finger lickin' good. It's cheep...
I don't think the triangle can be beaten so easily as some think...
superstar programmers: you either spend thousands recruiting them (not...
May 6, 2014 at 2:43 am
skeleton567 (3/31/2014)
one comment I'm 'gonna' (...
March 31, 2014 at 10:21 am
skeleton567 (3/31/2014)
March 31, 2014 at 10:02 am
WIT is a good group. From what I can see it encourages men and women to support 1) Women in their IT careers and 2) helps men learn from/about the...
March 31, 2014 at 8:52 am
I was thinking that... Developers aren't necessarily untrained DBAs, it's a different skillset not necessarily a 'lower' level.
I'm one of my company's developers and the DBAs are on another team....
March 12, 2014 at 8:57 am
Probably the best option if you need to preserve that variable number of output columns is to bung the lot into a stored procedure and use @NAMEID as a parameter.
http://msdn.microsoft.com/en-us/library/ms345415(v=sql.120).aspx
you'll...
February 5, 2014 at 6:40 am
ah I see.
This should be easier than you think.
DECLARE @NAMEID int, @ADR2 VARCHAR(100), @ADR3 VARCHAR(100)
SET @NAMEID = '14388'
--just add this line
SELECT @ADR2 = ADR2, @ADR3 = ADR3 FROM PAT_NAMES_ADDRESS ...
February 5, 2014 at 5:48 am
ok lets see if this is what you're after...
IF (EXISTS(
SELECT TOP 1 1
FROM PAT_NAMES_ADDRESS
WHERE NAME_ID =...
February 5, 2014 at 5:26 am
which column name is invalid? is it definitely in your table?
February 5, 2014 at 5:09 am
or are you after
SELECT CASE
WHEN COALESCE(@ADR2,'itsnull') <> 'itsnull' THEN ADR2
WHEN COALESCE(@ADR3,'itsnull') <> 'itsnull' THEN ADR3
ELSE ADR1
END AS 'ADDRESS'
, --the rest of your query
February 5, 2014 at 3:57 am
Sorry not sure I follow the question... do you want to do something like
IF(@ADR2 = 'ADR2')
BEGIN
some code...
END
??
February 5, 2014 at 3:54 am
At a guess I'd say you had multiple records in the STATE_NAME table with the same STATE_ID
February 5, 2014 at 3:01 am
Viewing 15 posts - 46 through 60 (of 263 total)