Viewing 15 posts - 21,046 through 21,060 (of 26,484 total)
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
The following code is a very simple example using existing databases on a "retired" server.
create view dbo.OpenQueryTest
as
SELECT
jobname,
jobdesc
FROM
OPENQUERY(DWSQL1, 'SELECT...
May 11, 2009 at 12:39 pm
Steve Jones - Editor (5/11/2009)
May 11, 2009 at 12:33 pm
It is still worth a try. I found the code but it is a bit confusing as it has nested subqueries. Can you write the query as if...
May 11, 2009 at 11:54 am
John Esraelo (5/11/2009)
May 11, 2009 at 11:40 am
John Esraelo (5/11/2009)
As you can see I have been reading many postings in various forums in order to find the answer I have been looking for.
This is also related to...
May 11, 2009 at 11:27 am
Viewing 15 posts - 21,046 through 21,060 (of 26,484 total)