This is the one i use.

use master

CREATE TABLE #TMPFIXEDDRIVES (

DRIVE CHAR(1),

MBFREE INT)

INSERT INTO #TMPFIXEDDRIVES

EXEC xp_FIXEDDRIVES

CREATE TABLE #TMPSPACEUSED (

...

Lynn Pettis (10/12/2012)

---

A link to a wiki page to help explain what a crore and a lak is. There are many of us...

what is this?

this $ users are available in one of my server as well but i havent removed it yet.

as per me no body can access using that logins so how security...

daily data of 15 lakhs has total of 5 crore means average of 30 -35 days of data only right.

do you have any keys / indexes in the table.

try moving...

sqlrd22 (10/12/2012)

---

Sorry I've only just managed...

are you getting the complete output in the email?

can you mask the sensitive code and post a sample so that we can check.

can you provide the below details.

are using excel to open the csv file?

what is the sql server and office version?

approximate no of rows for 2 or 3 days

ksr39 (10/10/2012)

---

Thank You Bhuvnesh for the quick reply,

But it’s difficult to find the table which is not been used more than a month as my server was rebooted since 65...

try with the sever IP address/reports and check whether in iis direct browse is working or not.

when ever there was a issue i used to get some error from report...

is it named as reportserver or somethingelse.

are you tring the correct URL.

[quote-0Now challenge come when i have single Item present in store, in this case group by Store and Item will not give my required output.

[/quote-0]

100003 is once in your example...

can you push this data to a temp table

select min(Priority) 'Priority', Item, Store

from tableName

group by Item, Store

and then join with main table to get No_ column

old idea but...

give us some time some body will help

do you want to show one data irrespective of different priority right?