Viewing 15 posts - 21,046 through 21,060 (of 26,490 total)
Bob Hovious (5/11/2009)
With MY name on it ??? :w00t:
We referees don't give cards, players EARN them. That's where I get the adage "I may have a Yellow(Red)...
May 11, 2009 at 4:48 pm
What I haven't quite figured out is how the function is going to be used?
May 11, 2009 at 4:44 pm
John Esraelo (5/11/2009)
As I expected; the test for the view takes 20+ second to run and I have not tested it from running a function yet.. that's next
The function should...
May 11, 2009 at 4:43 pm
john.arnott (5/11/2009)
Jeffrey Williams (5/11/2009)
Alvin Ramard (5/11/2009)
Grant Fritchey (5/11/2009)
Suffice to...
May 11, 2009 at 4:41 pm
Bob Hovious (5/11/2009)
No rules?! Then why are you fingering your red card in a threatening manner, Lynn? 😛
I'm not fingering any red card. Oh, wait, you...
May 11, 2009 at 4:37 pm
Are you saying hat you have NEVER had a technical conversation at the water cooler or in the hallway?
There are no rules here. Anything and everything is fair game.
May 11, 2009 at 4:21 pm
So, what is happening?? Still on the conference call?
May 11, 2009 at 4:11 pm
John Esraelo (5/11/2009)
would this go inside the view also:
GO
SELECT
ed.*
FROM
dbo.EmpData ed
WHERE
ed.ID = '22026'
GO
No. This is testing the view.
May 11, 2009 at 4:05 pm
John Esraelo (5/11/2009)
select
*
from
openquery(ads_link1111,
'SELECT
[BRGEMP].[ID],
ltrim(rtrim([BRGEMP].[LNAME])) ,
...
May 11, 2009 at 3:58 pm
Here is alittle more code, make what ever changes you need to make.
create view dbo.EmpData
as
select
*
from
openquery(ads_link1111,
'SELECT
[BRGEMP].[ID],
...
May 11, 2009 at 3:57 pm
While you are on the phone, can you tell me if this query returns the expected result set?
select
*
from
openquery(ads_link1111,
'SELECT
[BRGEMP].[ID],
...
May 11, 2009 at 3:44 pm
John Esraelo (5/11/2009)
yes, that is not a problem I was experimenting something.. but they will be and should be using the @emp_id that comes in as a param..
Didn't say it...
May 11, 2009 at 3:32 pm
John Esraelo (5/11/2009)
May 11, 2009 at 3:22 pm
Is the following always true, @MyNum and @MyNum_Middle always the same value?
select @MyNum = '''''22026'''
select @MyNum_Middle = '''''22026'''''
May 11, 2009 at 3:21 pm
You need to explain WHAT it is you are trying to accomplish. How is this being used?
May 11, 2009 at 2:24 pm
Viewing 15 posts - 21,046 through 21,060 (of 26,490 total)