Wednesday, December 14, 2011
SQL Server Integration Services ( SSIS ) Interview Questions
When preparing for a SQL Server interview, it is helpful to understand what questions may be asked related to SSIS. In this series, I will try to cover as much as I can to help you prepare.
Subscribe to:
Post Comments (Atom)
Respected Sir, Please guide me to design a query:-
ReplyDeleteWe need to take the base number (W31 for example) and compare it to other parts with color codes i.e (W31GR) (in this case the color codes are 2 characters so the base number in the driver table would be entered as W31 with a double underscore). The report should look at the applications on the base number and each part number with color codes and will export applications that are different among the whole group. I will send an email with a detailed example. however, for some suppliers, the color code is not 2 characters at the end of the part. It could be that the base number is 9517 and the three colors available are 95171 for black, 95172 for tan and 95173 for gray and there is no existing part number equal to 9517 itself. so in this case, the report would compare 95171/ 95172/ 95173 based on the driver table base number of 9517 with one underscore after it. my mail id: binodihs@gmail.com