Viewing 15 posts - 25,576 through 25,590 (of 26,487 total)
Looking at the July CTP:
xp_DirTree Yes
xp_SubDirs Yes
xp_FileExist Yes
xp_GetFileDetails No
![]()
August 10, 2007 at 11:13 am
I'll disagree with #4. There are instances where cursors are usable. Before using them, be sure you have looked at all other alternatives.
![]()
August 10, 2007 at 10:47 am
Try this:
SET @cmd = 'USE ' + @dbname + ';CREATE TABLE dbo.ETL_LAAD (LAAD_KEY bigint IDENTITY (1, 1) NOT NULL , LAAD_DATUM datetime NOT NULL) ON [PRIMARY]'
--EXEC @cmd
August 10, 2007 at 7:47 am
It would probably help more if you explained what it is you are try to accomplish besides just modifying the code. An example of the expected output would also help.
August 9, 2007 at 1:58 pm
What exactly are you trying change in OLE DB source?
August 9, 2007 at 12:37 pm
update dbo.TargetTable set
targetfield = dateadd(yyyy, targetfield, 1)
where
(any criteria to restrict the update)
![]()
August 9, 2007 at 11:50 am
Have you also included the size of the indexes in your calculations?
August 9, 2007 at 9:58 am
Here is the problem (only thing I can think of why it worked on my system is I am running on SQL Server 2005):
WHERE
(class.class_date > GETDATE()) AND (course.course_type_id =...
August 8, 2007 at 8:34 pm
Here is my suggestion, contact Microsoft. With the configuration you listed, you may be able use the Developer Edition for your Development, QA, and Training servers, and then use the...
August 8, 2007 at 9:04 am
True, I goofed with the THEN, I sometimes put it in as a line comment to keep things straight in my mind.
August 7, 2007 at 5:00 pm
Just for me, can you post back what you copied? Thanks.
![]()
August 6, 2007 at 5:12 pm
Check out John's code, I think it will do what you need also (I haven't tried myself). Also, as you didn't post the code you are running based on my...
August 6, 2007 at 4:35 pm
Looking at your code, not even going to try and fix it. You are using CASE incorrectly to start. From your description of the problem, your script (or stored procedure)...
August 6, 2007 at 2:50 pm
Start by reading about configuration files in BOL. You can also learn more in the WROX book Professional SQL Server 2005 Integration Services by Brian Knight, et al.
August 6, 2007 at 2:24 pm
Try this:
SELECT
dtclass.class_id,
dtclass.class_date,
course.course_type_id,
location.location_id,
location.display_city,
location.location_city
FROM
(select
class.class_id,
class.class_date,
class.course_type_id,
class.location_id
from
dbo.class
where
class.class_id in (select top 1 sq.class_id from dbo.class sq where class.course_type_id = sq.course_type_id and...
August 6, 2007 at 1:49 pm
Viewing 15 posts - 25,576 through 25,590 (of 26,487 total)