Viewing 15 posts - 76 through 90 (of 207 total)
Lynn Pettis (8/26/2009)
I realize I only gave a partial answer, but to essentially be called a liar? Anyone else want to tackle this one?
That search has since expired...
August 26, 2009 at 7:58 pm
calico (8/26/2009)
panwar.jt (8/24/2009)
1-- This report is running in sql server 2000
2-- I restore a copy of databse to Sql Sever 2005
3-- Report stops due to different collation...
August 26, 2009 at 7:53 pm
Paul White (8/25/2009)
ta.bu.shi.da.yu (8/24/2009)
e.g.
SELECT A.colA, B.colB
FROM PrimaryTable A where A.colValue in (select B.colValue...
August 25, 2009 at 10:39 pm
panwar.jt (8/24/2009)
But this report is running fine with blnk space and with sql server 2000
Hi Panwar,
If the query is running correctly in SQL Server 2000's query analyzer in both forms,...
August 24, 2009 at 1:56 am
GilaMonster (8/23/2009)
panwar.jt (8/23/2009)
I like to remind once again that this problem comes only in report display if i run this proc in query analyzer it run perfectly.
In that case, I'd...
August 24, 2009 at 1:51 am
An outer reference is a reference to a table that isn't in the from clause.
e.g.
SELECT A.colA, B.colB
FROM PrimaryTable A where A.colValue in (select B.colValue from OuterRefTable B...
August 24, 2009 at 1:46 am
R. C. van Dijk (8/24/2009)
August 24, 2009 at 1:28 am
So let me see if I can understand this issue a bit better.
You have a stored procedure thus:
Create Proc ProcName
@PAr1 varchar(4)
@PAr2 varchar(4)
@PAr3 varchar(4)
as
if @Par1=''
begin
select '' Par1,'' Par2,'' Par3
return
end
You create the...
August 21, 2009 at 8:17 am
GilaMonster (8/21/2009)
ta.bu.shi.da.yu (8/21/2009)
GilaMonster (8/21/2009)
Anyone keen on several pages of cursor-ridden SQL, a badly explained problem, two threads and no data?http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic774898-146-1.aspx
Oooo... sounds tempting. sadly, I think I'll pass.
Would you mind please...
August 21, 2009 at 8:15 am
Taken to http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx. Too much confusion I think. Let's do as GilaMonster says and only use one thread for this one.
August 21, 2009 at 7:41 am
GilaMonster (8/21/2009)
Anyone keen on several pages of cursor-ridden SQL, a badly explained problem, two threads and no data?http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic774898-146-1.aspx
Oooo... sounds tempting. sadly, I think I'll pass.
August 21, 2009 at 7:29 am
Steve, please tell me that you aren't implying that a RAID setup is a good substitution for a proper backup strategy!
August 21, 2009 at 7:08 am
You know what everyone was saying about bad answers... well, take a gander at the following Microsoft KB:
XL97: Data Not Returned from Query Using ORACLE Data Source
And I refer you...
August 21, 2009 at 7:02 am
Jeff Moden (8/21/2009)
ta.bu.shi.da.yu (8/21/2009)
August 21, 2009 at 4:48 am
Viewing 15 posts - 76 through 90 (of 207 total)