Anandkumar-SQL_Developer (12/15/2016)

---

Hi ,

normally its working .

better you post some sample data or check any chacters or (comma , instead of dot . found) ..! then only we can able...

Hi All,

Please let me know if someone have faced this type problem and resolved it.

For chrome i got the below link but it did not worked for me.

http://stackoverflow.com/questions/5428017/ssrs-2008-r2-ssrs-2012-reportviewer-reports-in-safari-chrome-but-works-fine

When saved the excel file as csv having some challenges like the numbers are in exponential when saved as csv.

So when saved as csv and opened my csv file found...

In order to serve business i have blurred my screen.

That is the servername or i can say my machine name on which services is running.

http://myservername/reports_SQLExpress

http://localhost/reports_SQLExpress

But...

Thom A (10/5/2016)

---

Visual studio is telling you exactly what the problem is here, it can't find the server. I'm pretty sure if you navigated to http://localhost/Reports_SQLEXPRESS/[/url] you would get a...

Thanks for the information.

Is from sql server 2008 R2 express edition supports the BI?

Thanks!

Sean Lange (6/15/2016)

---

By the time you have done this with dynamic sql like this there really isn't much point left in having this be a procedure. There are only a...

What about this ?

Create Table test12 (i int, j int)

insert into test12

Select 1,5

Create procedure test

(@tablename varchar(10),

@filedval int,

@where int)

as

Begin

declare @String varchar(200)

set @String = 'Update '+ @tablename +' Set j =...

sgmunson (8/7/2015)

Just constructing such an example would require more time than I have available. There's no easy way to be sure you could cover all the possible problems,...

Will this be one of the solution:

Solution 1:Once the file reaches the FTP, it should be read and processed , the data which are not processed which are failed should...

Orlando Colamatteo (8/8/2015)

---

you need to break down the problem into smaller pieces:

1. get files from FTP

2. load files as they arrive

those are simple steps but each raises a lot of...

Is there an example / sample with 3 columns

It will help to me to learn on this.

Step:1

How can we find the column validation of my Rows, say if there are 25 columns are there how can we validate columns with database tables.

Thanks for your replay Steve.

As i said it is one of the condition to check.There are multiple possible ways are there for data not loaded in to database, i have...

Steps :

I am connecting my dev server from my local machine.

i have created a shared path in my local machine.

Ran the query from my local machine connecting dev server.

I am...