Process Flow:
We have a Data flow task inside a For each container.
Inside the Data flow task we have 3 ole-db source connection.
Each source connection executes a stored procedure and their results will be passed to the flat file designation.
right now all the 3 ole-db executes at same time. ...
Yes, you are now a Superhero, able to wield the mighty Mjölnir.
The rules are:
You can instantly close as a duplicate any question that was originally asked with a tag you have a gold badge for.
You can instantly reopen any question closed as a duplicate that was originally asked with a tag ...
I have three tables project, users and proj_user. The PK of proj_user table is the FK of project and users table's pk e.g.(project_id,user_id)
My question is, is it possible if the project_id and user_id's data is different
like project_id = '12345' and user_id = 'abc987'
Please reply
kind re...
The SYSDATETIME() function is evaluated once in your query, because it is considered a runtime constant.
You can try a windowing function such as ROW_NUMBER()
INSERT INTO table1
(invoice,
detailline,
somedata1,
somedata2)
SELECT ROW_NUMBER...
We have disabled all forms of community wiki automatic conversions, not just for answers but for questions as well. The feature was never really about encouraging substantive edits as much as it was about prevent abuse. And in fact it punished people who made not just substantive edits, but lots ...
Try
Date(), doesn't give the right format.
You can do this with an update using join:
update a
set code = b.code
from a join
c
on c.latlong = a.latlong join
b
on b.code = c.code;
You can't use variables directly as table names; you need to use dynamic SQL to construct the whole query & concatenate the variable with the table name.
DECLARE @tblName VARCHAR(30);
SET @tblName = '...';
EXEC (';with tbl1_CTE as (select * from ' + @tblName + ') select * from tbl1_CTE');
