Viewing 15 posts - 76 through 90 (of 137 total)
Oops...sorry
July 13, 2005 at 9:53 pm
Looking at the GUI angle....
Create another package .....call it Main
In the main package:
call package1 --> call package2 --> on success call store proc (sql task).
July 13, 2005 at 9:48 pm
what do you mean by depends on indexes? can u give example?
July 13, 2005 at 9:33 pm
Trying my luck....
declare @date datetime
select @date = getdate()
select convert(varchar(22),@date,100)
July 13, 2005 at 9:29 pm
whic one is better?
personally, I still like Remi's query. It's easier to understand.
July 13, 2005 at 9:01 pm
Igor, my apology the query below should work. It was my bad I didn't drill deep enough.
insert into #tmp (name) exec('select top 9 name from [SAVVIS-Reporter].master.dbo.sysobjects')
Just one question, why don't you want...
July 13, 2005 at 8:53 pm
one way to get around it...
select taskid,taskname,entrydt from task
where task.entrydt >= @x and task.entrydt < dateadd(dd,1,@x)
July 13, 2005 at 7:52 pm
declare @x datetime
set @x= '29/06/2004' --datetime doesn't like this format. How about '29-Jun-2004' ??
OR
'29/Jun/2004' ?
July 13, 2005 at 7:34 pm
Ray is right. Table can be dropped. The view that referenced this table still exists but unviewable.
July 13, 2005 at 6:33 pm
I've never tried insert and exec() in one statement before. But I think the problem is you're missing a 'select' statement.
insert into #tmp (name) exec('select top 9 name from [SAVVIS-Reporter].master.dbo.sysobjects')...
July 13, 2005 at 6:17 pm
Just wondering is there anything that you write as a function but cannot re-written in SP ???
July 12, 2005 at 11:43 pm
There are so many rules bound to views for update/insert/delete!!!!
one rule states UPDATE statement cannot affect more than one of the base tables referenced in the FROM clause of the...
July 12, 2005 at 11:34 pm
Remi, do you mean something like this?
Select *
from dbo.SysObjects
option (maxdop 1)
July 12, 2005 at 8:23 pm
Remi, not sure which query you'r ereferring to?
If you're talking about the query below it only reads everything from sysobjects.
Select * from dbo.SysObjects maxdop1
July 12, 2005 at 5:46 pm
Viewing 15 posts - 76 through 90 (of 137 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy