The lesser amount you need to read from cache, the better the performance. Seems quite logical. (pun intended)

An alternative is using the format functions.

Formatting Dates [SSRS][/url]

A list with predefined formats can be found here:

Predefined Date/Time Formats (Format Function)

The one you need would be Y,y.

This comes close:

SELECT

c.name AS ColumnName

, t.name + CASE WHEN (c.precision <> 0 OR c.scale <> 0)

THEN ''

ELSE '('+CAST(c.max_length AS varchar(3))+')'

END AS ColumnDataType

,c.precision

,c.scale

FROM

sys.all_columns c

JOIN

sys.types t

ON

c.user_type_id

= t.user_type_id

WHERE object_id...

You say you are importing an Excel file, but it is actually a .csv file.

How are you trying to read the file? I hope not with an Excel source, because...

The only user interaction with an expression is when you use parameters inside your expression.

Maybe you can define a target report which has a few subreports, and you decide to...

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1486656-2799-1.aspx

You could try with an expression on the ReportName of the drillthrough target, but that means you would have to set the parameter when the report is ran, so it's...

Try reading articles by Jeff Moden.

The key here is to avoid cursors and WHILE loops, and...

Sure. This is one of the examples where you don't need a tally table.

You can replace the logic beneath @bit = 1 with one MERGE statement.

The logic beneath @bit =...

It depends 😀

It depends on what the cursor is used for.

For example, if you need to run a query for each table of the database (e.g. to update statistics, or...

You should polish your search skills. 😉

Amazon search

Every blue and...

This article might be a good start:

Introduction to JOINs – Basic of JOINs[/url]

Interesting question, thanks.

An option might be to extract the file to a folder called Extract. Then you can go with a for each loop to that folder and pick up the file...

I'd do it this way:

WITH CTE_Main AS

(

SELECT Code, Sub_Code, Name, Amounts

FROM TableA

WHERE Sub_Code = 20

)

, CTE_Withhold AS

(

SELECT Code, Amounts

FROM TableA

WHERE Sub_Code = 50

)

SELECT m.Code, m.Sub_Code, m.Name, Amounts = m.Amounts -...