Viewing 15 posts - 1,516 through 1,530 (of 2,894 total)
sanjayverma_mca (5/22/2012)
Hi ,The problem is that i don't now how to use it?so if could possible please explain me how can i use it ?
You should use it as prescribed.
If...
May 22, 2012 at 6:38 am
sanjayverma_mca (5/22/2012)
Hi AllPlease help me to resolve the issue of How to create dashboards in ssrs reporting??
Thank You
What issue? Using SSRS you can build reports for dashboards.
May 22, 2012 at 6:11 am
declare @sql nvarchar(4000)
set @sql = 'exec master.dbo.xp_cmdshell ''MOVE '+@caminho+'*.* c:\tempo_SGCTLOCAL'', no_output'
EXEC(@sql)
May 22, 2012 at 5:13 am
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...
May 22, 2012 at 3:31 am
k.subramanyam1017 (5/21/2012)
Thankyou for gave valuable information but i have one doubt as u r information you handled 12 datafiles...
May 22, 2012 at 3:17 am
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')...
May 21, 2012 at 10:31 am
I'm with Jeff on it: you better use CROSS TAB.
May 21, 2012 at 9:14 am
Schadenfreude-Mei (5/21/2012)
Schadenfreude-Mei (5/21/2012)
LCARS - have you been watching star trek?
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...
May 21, 2012 at 9:12 am
Schadenfreude-Mei (5/21/2012)
think we scared him off?
...LCARS 820-gigaquad interface, capable of handling over 1024[8] petanibbles of transactional guano every ms. The multi-dimensional quantum-shift matrix coupled with the m/am induction reation...
The above...
May 21, 2012 at 8:47 am
You don't need a cursor at all. Use COALESCE function:
UPDATE myTable SET RequiredColumn = COALESCE(prev15, prev30, prev45, prev60)
May 21, 2012 at 8:16 am
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
,...
May 21, 2012 at 8:11 am
k.subramanyam1017 (5/21/2012)
Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like year gap)pls tell...
May 21, 2012 at 8:01 am
Welsh Corgi (5/21/2012)
It is close. It returns 9 as the Min value when it should be 8.I'm using a concatenate function in Excel.
It returns 9 when it should be 8?...
May 21, 2012 at 7:03 am
You could just devide by 100.0:
declare @i int
set @i = 150
select @i/100.0
May 21, 2012 at 6:37 am
Viewing 15 posts - 1,516 through 1,530 (of 2,894 total)