Viewing 15 posts - 1 through 15 (of 42 total)
Hi,
Add the necessary column in the create statement.
Change the order of the insert and then use the below statement.
Declare @sql varchar(max);
set @sql= STUFF((select ', MAX(case when row_num = ' +...
May 11, 2016 at 5:23 am
Try this...
DECLARE @cols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX)
select @cols = STUFF((SELECT ',' + QUOTENAME(ColumnName)
...
May 9, 2016 at 4:23 am
Hi,
I'm not sure !!!! but from the error message which you have listed seems to be error in calling an SP, where you are passsing dates as an input paramter......
May 6, 2008 at 11:32 pm
i need to change the value of connections property by opening the xml and editing it. if i changed the value then that should be refelected in the SSIS packages......
April 15, 2008 at 7:58 am
I have updated all the stats all ..., but eventually it is showing the same performance issue...is there anything i need to update??????
April 1, 2008 at 6:45 am
You can use bulk insert if you don't have any transformation. otherwise you can use SSIS for transformation.
March 24, 2008 at 11:21 pm
Hi,
Could you send me the steps and code that how you solved this task thr' WMI?
Help is highly appreciated.....
March 24, 2008 at 11:16 pm
hi,
I don't think that there is a dependency between control flow and data flow, since you are setting the property in the control flow, so that won't return only single...
March 24, 2008 at 11:02 pm
Hi,
Anybody came accross above issue.....If you have any options, let me know...
February 28, 2008 at 11:38 pm
I don't know whether the below method satisfies your need...
While transformation, convert the numeric column into varchar datatype and check the flat file.....
February 25, 2008 at 12:35 am
Create a column which has old and new data for the date . First import the data in to an old column and then update the new column with...
February 25, 2008 at 12:28 am
Hi,
Is it a homework???:-)
Set can be used only to intialize a single variable.
Select can be used to intialize a single variable or more than that..
February 25, 2008 at 12:02 am
pls find the queries below:-
List all the departments that don’t have any employees. (Without using sub query)
SELECT * FROM DEPARTMENT DEP
WHERE NOT EXISTS
(SELECT 'DEP' FROM EMPLOYEE EMP
WHERE EMP.DEP_ID=DEP.DEP_ID)
List the departments...
February 4, 2008 at 1:04 am
hi
could you explain how to incorporate the log file????
January 31, 2008 at 11:20 pm
Viewing 15 posts - 1 through 15 (of 42 total)