You should use it as prescribed.

If...

What issue? Using SSRS you can build reports for dashboards.

declare @sql nvarchar(4000)

set @sql = 'exec master.dbo.xp_cmdshell ''MOVE '+@caminho+'*.* c:\tempo_SGCTLOCAL'', no_output'

EXEC(@sql)

Jeff Moden (5/22/2012)

---

...

By posting data in a format that you need 2008 or above for, you're cutting out some pretty hefty SQL Ninjas who may not have a 2008 machine...

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thankyou for gave valuable information but i have one doubt as u r information you handled 12 datafiles...

Just had fun (with some more data-samples):

IF OBJECT_ID(N'tempdb..#mytable') IS NOT NULL

DROP TABLE #mytable ;

CREATE TABLE #mytable

(event_ID INT,

event_date DATE)

INSERT #mytable

VALUES (101, '2012-04-01') ,

(101, '2012-04-02') ,

(101, '2012-04-05') ,

(102, '2012-04-03') ,

(102, '2012-04-07')...

I'm with Jeff on it: you better use CROSS TAB.

Schadenfreude-Mei (5/21/2012)

---

Schadenfreude-Mei (5/21/2012)

---

Yes infact 820-Gigaquads is the p/s access speed of the main computer core in 1701-D. LCARS (Library Computer Access/Retrieval System) is...

That may help:

http://connect.microsoft.com/SQLServer/feedback/details/208636/enhance-full-text-index-to-include-other-non-text-columns

It's still applicable to 2008.

The above...

You don't need a cursor at all. Use COALESCE function:

UPDATE myTable SET RequiredColumn = COALESCE(prev15, prev30, prev45, prev60)

If you want the MIN and MAX based on their numeric values you will need to convert to it:

SELECT '#TmpAct' AS TableName,'ACCOUNT_ID' AS ColumnName

, COUNT(DISTINCT CAST(ACCOUNT_ID AS VARCHAR(MAX))) AS NumDistinctValues

,...

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like year gap)pls tell...

It returns 9 when it should be 8?...

You could just devide by 100.0:

declare @i int

set @i = 150

select @i/100.0