Hello,

You can use the extended stored procedure xp_cmdshell of SQL Server.

In order to use this first of all you have to reconfigure the run_value of xp_cmdshell by using sp_configure stored...

Hello dilipc01,

You can get the details of drill down ssrs report on following link below:

http://www.mssqltips.com/sqlservertip/1329/drill-down-techniques-in-ssrs-with-the-visibility-property/

Also, yes you can create dashboard in the SSRS, using charts and graphs.

In case...

Hello,

Ok, since you mentioned SQL Server Database so i think that you might be need to work on windows.

But as per your question, yes there are web based BI reporting...

Hello cooljagadeesh,

You can implement RANK in your query like this

select *,

RANK() over (partition by name order by row) as...

Hello karthik M,

No SQL is term use to designate from classic relational databases. In nosql the concept of relational database has been diluted and anew concept of key value pair...

Hello trapnell,

In SSIS, when you use a FTP Connection first time you have to enter a password for your ftp server, after then it get automatically configured to ssis package...

Hello gayathriperumala,

You can find your answer at this location

http://www.keepitsimpleandfast.com/2011/07/more-tips-to-improve-performance-of.html

Thanks....:-)

Hello sam 55243,

Instead of writing code for this problem, I advice you to use SSMA (SQL Server Migration Assistant)

This is a free tool provided by Microsoft for Migration purpose from...

Hello biforumnewby,

There are several BI tools available but I suggest you should use Report Builder because of certain reasons:

1. This is a Microsoft BI tool which can easily integrated with...

Can you please specify which Reporting Tool you are using to create the report.

If you are using Report Builder you can follow the following procedure

1. Open Report Builder

2. Click on...

You need to create a linked server for that in sql server.

Also before that you have to create a ODBC Connector

The steps for the same has been described at:

Hello,

It can be done using

INSERT INTO select from yourtable

I have created the T-sql query for you, please have a look

[font="Times New Roman"]

INSERT INTO dbo.ledgerBalance (party,closingbalance)

select

distinct

temp.ID,

(case when temp2.DrAmount...

Hello,

There is an alternative solution to your problem what you can do is, you can add an additional entries for extra spaces

for eg:

Let say your input is @STR...

Hello,

For installing the cluster the pre requisites can be found at below link:

http://www.mssqltips.com/sqlservertip/1687/install-sql-server-2008-on-a-windows-server-2008-cluster-part-1/

Hope so it will help you...:-)

This query can also be answered without using escape

The query is shown below:

select * from accounts where accname like '%OLD%'

Thanks:-)