Viewing 15 posts - 1 through 15 (of 42 total)
Select T1.ToDisplayName as DisplayName, T1.ToEmailAddress as EmailAddress , T1.AddressListID as AddressListID
FROM T1
UNION
Select T2.ToDisplayName as DisplayName, T2.ToEmailAddress as EmailAddress , T2.AddressListID as AddressListID
FROM T2
UNION
Select T3.ToDisplayName as DisplayName, T3.ToEmailAddress as EmailAddress , T3.AddressListID ...
September 19, 2005 at 12:17 am
Can you run the quey in QA and see if it is running fine?
September 19, 2005 at 12:08 am
go to the Package in the menu bar
Package --> disconnect edit --> Steps
It will list down all the steps in the DTS package and on the right hand side...
September 18, 2005 at 11:48 pm
How are you transferring the data between the two databases ? Are you using any query to transform the data from sql server ( in Transform task) or is it...
September 16, 2005 at 2:03 am
This thread might give some idea for you to get started
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=166709
September 16, 2005 at 1:35 am
Can you tell what your function dbo.GetSpecifiedSlumpInfo does ? does it return just the UID or something else ?
September 16, 2005 at 1:21 am
SELECT Name, Elcl_grant, ol_grant, sum(elcl) as elcl_given, sum(ol) as ol_given
FROM Master
JOIN Detail ON master.code = detail.code
GROUP by Name, Elcl_grant, ol_grant
September 14, 2005 at 1:08 am
I have been seeing the exceptions a lot as well...
September 13, 2005 at 3:28 am
The filename 'UNC_to_file' might not be present in the folder from where you are executing the procedure .
Give an absolute path in the Filename field and see if the...
September 13, 2005 at 12:59 am
Based on the Value from the control table you can set a flag (Global variable) and using that flag you can disable/enable the step.
September 12, 2005 at 4:50 am
Try setting the Autorestart SQL Server Agent if it stops unexpectedly to true in the Properties of SQL Server Agent
Sql Server Agent --> Properties --> advanced (tab) --> Restart Services...
September 12, 2005 at 1:31 am
Very nice article..although I saw this at a very later date
June 28, 2005 at 4:32 am
This thread might help you ....
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=111988
-Meghana
June 28, 2005 at 1:51 am
The time will always be stored as a part of the datetime datatype AFAIK. But you can use date functions to get the data in the format you want.
Please refer...
June 28, 2005 at 12:38 am
Try checking the log files for any problem with the source records. You might have some erroneous records because of which only half the records are getting inserted
right click the...
June 23, 2005 at 2:38 am
Viewing 15 posts - 1 through 15 (of 42 total)