Viewing 15 posts - 16,606 through 16,620 (of 18,926 total)
Update A set A.col4 = dtMaxDates.Col4 from TableA a inner join
(Select col1, col2, col3, max(col4) as col4 from dbo.TableB group by Col1, Col2, col3) dtMaxDates
on A.col1 = dtMaxDates.col1 AND A.col2...
June 17, 2005 at 7:30 am
Here's a demo with the system tables.
IF Object_id('ListTableColumns') > 0
DROP FUNCTION ListTableColumns
GO
CREATE FUNCTION dbo.ListTableColumns (@TableID as int)
RETURNS varchar(8000)
AS
BEGIN
Declare @Items as varchar(8000)
SET @Items = ''
SELECT
@Items = @Items + C.Name + ',...
June 17, 2005 at 6:34 am
Or maybe there won't be enough work done on Oracle... I've often seen that sql server will import the whole table(s) and do the work locally without indexes. while...
June 17, 2005 at 6:26 am
The more indexes you add, the more it costs to maintain them. But if that costs is less than the cost of a slow query then it can be...
June 17, 2005 at 6:24 am
Sure :
GO
CREATE PROCEDURE dbo.Test @Dividor as int
AS
SET NOCOUNT ON
Declare @Er as int
begin tran
Select 10 / @Dividor
Set @Er = @@Error
if @Er 0
begin
print 'There''s an error'
rollback tran
end
else
begin
print 'No problem --...
June 17, 2005 at 6:07 am
How the heck did he do that without noticing he was screwing something up??
June 17, 2005 at 2:51 am
Good idea, it's true some forums are very specialized...
June 16, 2005 at 1:27 pm
You'd never do that, would you??
June 16, 2005 at 1:23 pm
No, I don't know that trick... I usually just copy/paste the whole thing directly and it works.
June 16, 2005 at 1:22 pm
1=2 returns only the metadata, no select is actually done.
June 16, 2005 at 1:16 pm
Care to outline the logic of this thing???????????????????????
June 16, 2005 at 1:13 pm
I can so picture myself doing that
.
Maybe we should redo that disaster contest. Looks like we'd have a few new inputs
June 16, 2005 at 1:07 pm
I see you have way more experience in that area than me. Thanx for sharing.
June 16, 2005 at 12:22 pm
While I don't know anything about reporting services either, I can suggest that you have a single query (stored proc) with DateFrom parameter that you can set on the client....
June 16, 2005 at 11:47 am
I knew you could help him
. I must be able to see the future or something
June 16, 2005 at 10:55 am
Viewing 15 posts - 16,606 through 16,620 (of 18,926 total)