Moreover, to find the necessary indexes, its required to know what type of queries will be executed against the table.

And also, here is the code that will provide you the...

We would be happy to help you, if you can provide us with the table definitions (in form of CREATE TABLE Scripts) and sample data (in form of INSERT statements)....

There are many ways to achieve this..., here is few ways to do it...

--METHOD 1

SELECTC.TRN, P1.Name AS FRM, P2.Name AS [TO]

FROMChild C

INNER JOIN Parent P1 ON C.FRM = P1.RNO

INNER JOIN...

I think you are getting NULLs because the you don't have any records where value of CustomFieldValueBit is 0...

REPLACE this

(SELECT SUM(isnull(soi.ItemValue,0))

WHERE CVOption.CustomFieldValueBit = 0) AS 'QuoteValue',

WITH

SUM( ( CASE WHEN...

You can set the SOURCE & TARGET connections (by setting "ConnectionString" property) dynamically using Expressions...

Look for Package Configurations, Expressions in BOOKS ONLINE

Well, you have to make sure that the file "C:\Practice Files\Northwind.mdb" exists on the SERVER (and not on LOCAL machine) and the sql service account/windows account has read access to...

What do you have in first place, a backup file (.bak) or a .mdf file? In either cases, you can setup the database. Use BACKUP DATABASE if you...

Can you elaborate more on how these two tables are linked? And what is the logic behind the output?

...ROW_NUMBER() is what you are looking for

Well, I think the format "YYYYMMDD" is an ISO standard.. So, you can first convert the decimal to a varchar(8) column and then to a datetime column...

DECLARE @dSomeDec DECIMAL(8,0)

SET @dSomeDec...

..Since you haven't provided enough information, I could only find the probables and this is what I think is the most probable...

SELECTt12.t12Name

FROMtable3 t3

INNER JOIN

(

SELECTt1Id AS t12Id, t1Name AS t12Name,...

...but the main question here is, how do you know which files needs to be deleted? The system cannot read your mind:D, and off course mine too..., you have...

Do the files to be deleted have a specific name format? If yes, then you can the specify the wildcard format in for each loop enumerator.

You can execute T-SQL statements in "Execute SQL Task"

Try adding "/r/n" as row terminator (replace "/" with "\")....