Viewing 15 posts - 1,096 through 1,110 (of 1,583 total)
Have you exclusively granted CONNECT to that security login for the DB
Ex:
USE [mydatabase]
GO
CREATE USER [xyzINC\SVC_SQL] FOR LOGIN [xyzINC\SVC_SQL]
GO
GRANT CONNECT TO [xyzINC\SVC_SQL]
GO
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 30, 2012 at 10:51 am
You could try this, works pretty wellSELECT
Pin,
CDate,
btn,
callduration,
charge
FROM #gmreport
ORDER BY pin
COMPUTE SUM(callduration), SUM(charge) BY pin
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 30, 2012 at 10:22 am
I believe you can do this directly within SQL but first you'll need to make sure you have the "Data Connectivity Components" update, available at http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734
See this article for more...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 29, 2012 at 1:56 pm
GOOD LORD JEFF!!! :w00t:
The efficiency of this using the TVF is incredible. I processed a years worth of data in just under 2 minutes...WOW - THANK-YOU!!!
The ROLLUP is not something...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 28, 2012 at 9:00 pm
Have you thought about running the exe using the windows OS job scheduler?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 28, 2012 at 10:24 am
Could you use xp_cmdshell?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 28, 2012 at 10:13 am
I didn't think about the fact that because the file was an attachment it might keep you from opening it
SELECT '292596778','876887','427512','May 4 2009 12:00AM','0002 ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 9:44 pm
I thought I posted the DDL in the first post (apologies)
CREATE TABLE [dbo].[tmpQTY_LocalFleets_WORK](
[tranid] [int] NULL,
[ctrl-number] [int] NULL,
[tc-number] [varchar](20) NULL,
[pos-date] [datetime] NULL,
[tc-card] [char](10) NULL,
[trans-code] [int] NULL,
[prod-code] [varchar](160) NULL,
[prod-qty] [varchar](400) NULL,
[Month] [int]...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 9:34 pm
Hey Jeff, thanks for that (really)...just not certain how I would work your splitter into what I already have posted a couple posts above...
With using the CTE's that GSquared provided...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 3:30 pm
I've got to say, your solution is elegant and incredibly slick all at the same time. I can honestly admit I never would have come up with it on...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 2:42 pm
So just a table with 1 col, values 1 - n?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 12:56 pm
Thanks for the hints, I never bothered attempting CTE's for this...definitely something to try - In your example though, where is dbo.Numbers coming from?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 12:05 pm
USE [SSRS_Run_Reports]
GO
/****** Object: UserDefinedFunction [dbo].[fx_ArrayList_IP_9378] Script Date: 03/26/2012 11:23:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* =============================================
Author:John Doe
Create date: 03/20/2012
Description:To be able to parse over...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 11:01 am
Please attach your execution plan
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 10:31 am
Can anyone offer a solution to this issue regarding my post:: Yesterday @ 9:50 AM?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2012 at 10:00 am
Viewing 15 posts - 1,096 through 1,110 (of 1,583 total)