T-SQL

i am importing excel file and i want to use the name of excel file in my table

NO i am just importing excel sheet and i need to use that excel sheet name in one column

For this query

SELECT CAST(634 AS VARCHAR(2))

why it display * in result

One more

SELECT CAST(634 AS VARCHAR(2))

why it display * in result

Use Execute sql take

I have many other column, in which i dont have any value that's why i specify null. As I mention earlier my data value are becoming column and we have...

Yes!!! I am using SSIS

Use 2 CTE and in First display January and in other -1

Please Provide me Step by Step Information because i am new in it.

and it is interview screening question.

Any one provide Step by Step information.

that will be great help.

I tried but not getting with is log table info. and how to change the column name.

if possible can you provide the process and which transformation i have to use.