Viewing 15 posts - 5,596 through 5,610 (of 8,761 total)
Quick solution, similar to the one Ozzmodiar posted, with an additional POC index which eliminates any sorting operations in the execution plan.
π
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.testTable') IS NOT NULL DROP...
April 18, 2015 at 3:28 am
Mark Cowne (4/17/2015)
WITH CTE AS (
SELECT cust_Id,sDate,budget,
ROW_NUMBER() OVER(PARTITION BY cust_id ORDER BY sDate) -
ROW_NUMBER()...
April 18, 2015 at 3:11 am
Further on Alan's reply, this is an incomplete query, first guess would be that it's from a BMC Dashboard, try to capture the whole query.
π
April 18, 2015 at 2:49 am
Abhijit More (4/18/2015)
Would it be possible to handle multiple file systems (e.g. xlsx, csv, mdb) with different /similar headers in single package without Script Component?
Yes it is, I would ask...
April 18, 2015 at 2:28 am
Quick and somewhat naΓ―ve ( compared to Dwain's ) solution
π
Note: added 'a'-->'@' for demonstration purposes π
USE tempdb;
GO
SET NOCOUNT ON;
/* sample data */
IF OBJECT_ID(N'dbo.ReplaceCharStrings') IS NOT NULL DROP TABLE dbo.ReplaceCharStrings;
CREATE TABLE...
April 17, 2015 at 3:21 am
Revenant (4/16/2015)
eccentricDBA (4/16/2015)
Eirikur Eiriksson (4/16/2015)
Ed Wagner (4/16/2015)
Eirikur Eiriksson (4/16/2015)
Ed Wagner (4/16/2015)
djj (4/16/2015)
Ed Wagner (4/16/2015)
CaterpillarTracktor
Construction
Build
Version
Conflict
resolution
New Year
Passed
April 16, 2015 at 2:35 pm
Ed Wagner (4/16/2015)
Eirikur Eiriksson (4/16/2015)
Ed Wagner (4/16/2015)
djj (4/16/2015)
Ed Wagner (4/16/2015)
CaterpillarTracktor
Construction
Build
Version
Conflict
April 16, 2015 at 2:05 pm
Ed Wagner (4/16/2015)
djj (4/16/2015)
Ed Wagner (4/16/2015)
CaterpillarTracktor
Construction
Build
April 16, 2015 at 1:41 pm
kcj (4/16/2015)
Declare @VariableA varchar(8000)
Declare @VariableB varchar(8000)
How can I concatenate these two variables without converting them to varchar(max) ?
If...
April 16, 2015 at 1:39 pm
Alan.B (4/16/2015)
You query should look something like this:
SELECT a.col1, a.col2, b.col1
FROM a
Join
(
<Subquery>
)...
April 16, 2015 at 1:31 pm
Have you checked the tempdb, congestion there is a possible cause.
π
April 16, 2015 at 12:42 pm
GF (4/15/2015)
I have a table that has company id, attachment file name, folderexists columns.
First what I need to do is create a series of folder or directories on...
April 15, 2015 at 11:32 pm
Steve Jones - SSC Editor (4/15/2015)
http://radar.oreilly.com/2015/04/rebooting-a-1970s-satellite-with-modern-software-and-hardware.html
Pretty cool!
π
April 15, 2015 at 3:30 pm
Viewing 15 posts - 5,596 through 5,610 (of 8,761 total)