BenWard

Forum Replies Created

Viewing 15 posts - 46 through 60 (of 264 total)

RE: Summer, Summer, Summertime

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

July 25, 2014 at 1:31 am

#1732268
RE: SSIS stops with communication link failure if I lock my PC whilst it's running

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

June 13, 2014 at 6:20 am

#1721435
RE: SSIS stops with communication link failure if I lock my PC whilst it's running

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 -...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

June 13, 2014 at 5:56 am

#1721425
RE: Better, Faster, and Cheaper

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 6, 2014 at 2:43 am

#1710965
RE: X in Technology

skeleton567 (3/31/2014)
Hey, I had to stop and look up that STEM thing. New to me, so I am still learning today, at 71 years old!
one comment I'm 'gonna' (...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 31, 2014 at 10:21 am

#1701686
RE: X in Technology

skeleton567 (3/31/2014)
Come on, Steve. You sound like the one who is 'impacted' this morning. Get over it. Don't try to twist my comments. What I pointed...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 31, 2014 at 10:02 am

#1701672
RE: X in Technology

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 31, 2014 at 8:52 am

#1701620
RE: Core T-SQL

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....
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 12, 2014 at 8:57 am

#1696426
RE: Returning multiple records when only one is specified

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 5, 2014 at 6:40 am

#1686176
RE: Returning multiple records when only one is specified

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 ...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 5, 2014 at 5:48 am

#1686161
RE: Returning multiple records when only one is specified

ok lets see if this is what you're after...
IF (EXISTS(
SELECT TOP 1 1
FROM PAT_NAMES_ADDRESS
WHERE NAME_ID =...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 5, 2014 at 5:26 am

#1686148
RE: Returning multiple records when only one is specified

which column name is invalid? is it definitely in your table?
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 5, 2014 at 5:09 am

#1686143
RE: Returning multiple records when only one is specified

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
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 5, 2014 at 3:57 am

#1686134
RE: Returning multiple records when only one is specified

Sorry not sure I follow the question... do you want to do something like
IF(@ADR2 = 'ADR2')
BEGIN
some code...
END
??
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 5, 2014 at 3:54 am

#1686133
RE: Returning multiple records when only one is specified

At a guess I'd say you had multiple records in the STATE_NAME table with the same STATE_ID
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 5, 2014 at 3:01 am

#1686118

Viewing 15 posts - 46 through 60 (of 264 total)