|
|
-
|
|
Hi,
i have to perform following task by using SSIS package
please help me to automate following using SSIS
TABLE STRUCTURE
MonthEndCDSSpreadCalc:
Date CompanyName PurchaseLotID DatePurchased EntryPrice PreviousMark Spread Mark
NU...
|
|
-
|
|
Hi Sudeep,
I have some folders namely FolderA, Folder B... and each folder contains some files like file1, file2..etc. File1 can be present in both folder A and B and so on. I want to create an SSIS package which merges all the similar files. Like Fil...
|
|
-
|
|
Can anyone tell me the uses of SSIS?...
|
|
-
|
|
In CTE , if it is possible to use local variable @i in the hints (maxrecursion @i) ?Ex:declare @i int= 5;with cte(...)select * from cteoption(maxrecursion @i) ...
|
|
-
|
|
Hi, I have this XML File and I'm trying to get this XML into Single table using the below Query. Warner Home VídeoWarner Bros.Warner Bros. PicturesUSAWarner Bros.Warner Home VídeoWarner Bros. PicturesUSASELECT R.value('@type',...
|
|
-
|
|
Hello, I have been trying to get this procedure to return some values from multiple rows. I am just trying to get it to return a single value. Something like this is what I have so farSay from this XML Schemahttp://beyondrelational.com/modules/3/ask/q...
|
|
-
|
|
How to calculate the working hours per day?empid timesheetid timesheet62 1 2013-02-20 09:45:29.15362 2 2013-02-20 10:45:29.15362 1 2013-02-20 10:50:19.10362 2 2013-02-20 13:01:22.15362 1 2013-02-20 14:08:02.10062 2 2013-02-20 16:10:52....
|
|
-
|
|
i have the following table
Student SubjectCode AverageMark
1 1,5,8 70
2 1,8 80
3 2,4 55
4 5,2,8,4 ...
|
|
-
|
|
We have a table that has 2 attributes (Name,
population)
When I write:
SELECT Name, MAX (Population) From Country
I don’t see the name of “correct” country in
the result.
Suppose the correct answer is “China”
But I see the “Austria” (the first name...
|
|
-
8
Replies
| 1
Answers
| 1
Suggested
|
|
Hi,
Can some one please tell me how to run commands stored in table.
for example i have a table where its column have some drop commad like below
drop table tbl1
drop table tbl2
drop table tbl3
Thanks in advance
Manish ...
|
|