i think mostly we will be using this to avoid divide by ZERO error

Here the 'U' is the object type which is a table.if you dont put 'U' still the query works, but think if you are having a SP or a Funtion...

SELECT name, physical_name AS current_file_location

FROM sys.master_files

Imports System

Imports System.Data

Imports System.Math

Imports System.Data.SqlClient

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

'...

Here is the code:

Public Sub Main()

Dim user As String

Dim Password As String

...

If You just need to Run some procedure, then you can go for Execute SQl Task instead of doing it in the Script Task.

If still need Script Task to achieve...

The below Query Will update all the recodes (Multiple)

UPDATE student_records

SET GRADE =

CASE

WHEN (marks > 90) THEN 'A'

WHEN (marks between 79 and 90) THEN 'B'

WHEN (marks between 60...

In the Reporting Services Configuration Manager Please Do the following steps:

1) In the Report Server Virtual Directory settings Create a new Virtual Directory with the name "ReportServer" and Create it...

More info, we can refer to this URL:

Please Look at this URL:

http://msdn.microsoft.com/en-us/library/ms190190.aspx

The real solution is to design an incremental ETL process that loads to a report optimized database. If a closer to real time data is required, triggers, modified replication or...