In the format file, you should define the format of the data file, not the table.

Here's what I used to make it work:

11.0

4

1 SQLBIGINT 0 8...

You're also calling a function twice. If that's a multi-statement table function, that might be causing problems.

Your clause "and vru.Full_User_Name0 IN (@Assignee)" is causing that your left join becomes an...

johnwalker10 (4/13/2016)

---

Shipping Tool can take screenshots of an open window, rectangular area, a free-form area, or the entire screen.

SnippingTool.exe is located in the System32 folder but it can also...

lotusnotes (4/14/2016)

---

Ok. Thanks guys.

If you use an alias od.orderid it still lets you do it & the overall code still works & returns no rows.

You would hope to...

Have you tried a Quirky Update? That would be my choice.

Reference: http://www.sqlservercentral.com/articles/T-SQL/68467/

kawi6rr (4/13/2016)

---

I'm sorry I tried to be as clear as I could but it looks like I could have explained better.

Table

Is a table that's already created and filled with the...

golf

How do you get that output from that data?

Here's what you seem to be trying to do. Please notice on how I posted the sample data so you can do...

This is not a bug. It's a feature.

Allowing to reference columns from the outer query allows you to create correlated subqueries. This is specially important when using EXISTS or APPLY.

Due...

Help us help you. Please post DDL and sample data in a consumable form. Learn how to do it from the articles linked in my signature.

smw147 (4/13/2016)

---

drew.allen (4/12/2016)

---

LEAD and LAG were introduced with SQL2012. You won't be able to use them if...

If you want to pass parameters, you don't need a view. You need an inline table-valued function (iTVF).

CREATE FUNCTION SomeFunctionName(

@Year int

,@Period int

) RETURNS TABLE AS

RETURN

SELECT

MAX(GLChartOfAccounts.GLChartOfAccountId) AS GLChartOfAccountId,

SUM(DTbl.OpenBalance) AS OpenBalance,

SUM(DTbl.ThisPeriodDebits)...

I'm not a C# or VB developer either,...

Avoid threading if you're writing to the same table. Leave that option to SQL Server by the use of parallelism.

Also, align the clustered indexes of temp tables with perm table.

What's wrong on using the script task code I gave you?

In a single task you'd be validating and deleting. If you need to get the date by the name, that's...