Comments by Umer Akram (Top 31 by date)

can you share the exact error ?

Once suggestion, you should not change the expression in a case which can cause confusion:

IF A > B THEN 'yes'

instead of using B > A

you should be using something like this:

IF A < B THEN 'No'.

for the said issue, share sample data for table tbl_keywordposition and share your desired output. as

provide table structures with sample data and also share desire output. provided information is not enough.

you should use column mappings something like

bulkCopy.ColumnMappings.Add("col1", "dt_col1");
bulkCopy.ColumnMappings.Add("col2", "dt_col2");
sqlBulkCopy.DestinationTableName = "dbo.TDSM";

and try it.
bulkCopy.WriteToServer(dt);

This means that you need to validate your select statement. you might be using a column(s) which are not related to the tables.

how you are creating your select query? can you share the logic?

this means your select clause is also dynamic means?

quick question, are the used table are also dynamic means generated on the run time ?

you have to break your code to narrow down the issue, i would suggest to validate the FROM WHERE clause 1st something like this. this will ensure that your query base is correct.

N'Select *
FROM ' + @Table_Name + ' AS t1
LEFT OUTER JOIN ' + @Table_Name2 + ' AS t2
ON t1."Projektdefinition DB" = t2."Projektdefinition DB"
WHERE t1.[DBN - bereich] = ''PB'' AND t2.[DBN - bereich] = ''PB''' +
' ORDER BY t1.[Projektdefinition DB] ASC '

one more thing what is the data type of the variables @Table_Name , @Table_Name2

and how you are execution this query ?

my mistake, better reply to him then :)

replied to OP.

glad to help you

you are welcome :)

are you looking at the right server & database to which your connection string is pointing to ?

Just removed the extra ")" to avoid any syntax error. here is the updated query.rest of the logic is same.


select c.Status,c.InterviewDate,c.InterviewerName,c.DateOfConfirmation,c.DateOfJoining,c.LastWorkday, c.Contact,d.DesignationOffered,d.Duration,d.SalaryOffered
into newTableName
from CandidateSelection1 c join Designation d
on c.CandidateId=d.DesignationId

what error its gives you?
which user authentication was used to login to sql server?

its a repost of the following question .
Update trigger not firing properly

question is related with that. better ask question on the same thread instead of creating a new one.

quick question what error it gives you when you execute this query? if you want to use space in side column name i would suggest to use [] instead of "". e.g
t1.[Planung GJ+05 mit AZ] AS "Planung GJ+05"
will become
t1.[Planung GJ+05 mit AZ] AS [Planung GJ+05]

have to tried to execute the generated query on the database to see if any issue? it this query is straight forward, you need to check what value you are passing to PassNo column.

you have to share your tables structure and with sample of actual data so understand the problem. the solution was as per the provided information. more detail is required.

That would required some working from your side, 1st you need to share what working you have already done at your end. What is your show stopper in this context.

you can highly improve your solution with a calendar table.

you are saying that a store which was not a in bigstore table. it value updated and its total quantity is less then 50,000 and still ends up in the bigstore.

that highly unlikely, because that store might be a in bigstore table 1st.


for your understanding check the following example:

USE tempdb
GO

create table instock ( storeid int, QUANTITY int)
create table bigstores ( storeid int)
create table stores ( storeid int)
GO
CREATE TRIGGER TRI_updateINSTOCK
ON instock
FOR update
AS
BEGIN
DECLARE
@storeid smallint,
@totalquantity int

SELECT @storeid= i.storeid FROM inserted i

select @totalquantity = SUM(QUANTITY)
FROM instock
WHERE storeid = @storeid

IF NOT EXISTS(SELECT storeid FROM bigstores WHERE storeid =@storeid )
BEGIN

select @totalquantity

insert into bigstores
select * from stores
where StoreId = @StoreId AND @totalquantity >= 50000
END

END
GO

insert into stores
select 1 union all
select 2 union all
select 3 union all
select 4

insert into instock
select 1, 10000
from stores

---------------------- updated the quantity added to exceed 50,000
update instock
set QUANTITY = QUANTITY + 10000
where storeid = 1

---------------------- updated the quantity drop from 50,000
update instock
set QUANTITY = QUANTITY - 10000
where storeid = 1

GO

drop table instock
drop table bigstores
drop table stores

what is your desired out ? same share a sample

can you share some sample data and what's your desired output will be look like? this will help to understand your problem better.

Well there are many ways to do this. i would suggest you to do it using Microsoft run time library. following is the link Building Packages Programmatically

you have to share more details regarding your problem.

Have give the explicit rights for that user against the view as well.

you have to 1st convert the datetime variables in to "string" or in SSIS Word "DT-STR" OR "ST_WSTR" by using type casting, after that is very simple you just need to do this
e.g "'Select '" + [@varStartDate] +'"
Hope it helps