Viewing 15 posts - 331 through 345 (of 3,957 total)
CELKO (2/17/2015)
Round? Whoever said the Earth was round? It must be flat because I keep falling off the edge! :w00t:
You are not really drunk if you...
February 17, 2015 at 11:54 pm
CELKO (2/17/2015)
I am not an expert in SQL , but i been trying to get the difference of two dates in years.days format ..
You are the kid in...
February 17, 2015 at 8:09 pm
CELKO (2/17/2015)
what does your underlying dataset look like? (or the table in question). If your data table isn't normalized properly, then this is going to be a huge...
February 17, 2015 at 8:01 pm
You'll need to decide for yourself whether this is correct for you or not:
WITH SampleDates (Date1, Date2) AS
(
SELECT '1971-02-15', '2009-12-09'
UNION ALL SELECT...
February 17, 2015 at 6:35 pm
ChrisM@Work (2/17/2015)
dwain.c (2/16/2015)
ChrisM@Work (2/16/2015)
rodjkidd (2/16/2015)
Hey Chris,How likely is the chance now of you turning up Thursday at SQL Bits?
Rodders...
I've booked the day off, mate - need 5 minutes to book...
February 17, 2015 at 5:49 pm
DECLARE @Account TABLE(AccountNo varchar(3), MasterAccount varchar(10) ) ;
INSERT INTO @Account
SELECT 'ABC','0000000ABC' UNION
SELECT 'DEF','0000000DEF' UNION
SELECT 'ABC','0000000000' UNION ---- unwanted duplicate
SELECT 'DEF','00000' UNION ---- unwanted duplicate
SELECT 'GHI','0' ;
SELECT...
February 17, 2015 at 5:35 pm
A perfect case for using a pattern-based string splitter:
;WITH MyCTE([jmaPartShortDescription])
AS
(
SELECT '5.625X11.25-2.875x8.5 ' UNION ALL
SELECT '5.625X35.25-2.875x32.5 ' UNION ALL
SELECT...
February 17, 2015 at 5:30 pm
What if the value of 123 appears in more than one Pend column?
WITH SampleData
(
Docflo, Distribution, [Group], [Queue], [Status], Pend1, Pend2, Pend3, Pend4, Pend5
) AS
(
...
February 17, 2015 at 5:17 pm
I'm not saying I recommend this or anything, but something like this is likely to work.
DECLARE @ImportedXML TABLE
(
[FileName] NVARCHAR(100)
...
February 17, 2015 at 5:08 pm
PSB (2/17/2015)
The query performance is very poor . Any tips on improving performance ?
I'm not particularly surprised. A few questions.
1. How often does this query run?
2. Would it be...
February 17, 2015 at 5:01 pm
Maybe what you need to try is an age calculation to get the years and then a second calculation to get the days.
I used to refer people to a post...
February 17, 2015 at 1:50 am
Guitar_player (2/17/2015)
DECLARE @D1 DateTime = '20090128',
@D2 DateTime = '20150217';
SELECTCAST (
DATEPART(YEAR,...
February 17, 2015 at 1:20 am
Looking again, it appears that David's solution using ROW_NUMBER() is the best approach here. I missed the requirement of retrieving the HasGift column from the configuration table, so using...
February 17, 2015 at 1:11 am
Jeff Moden (2/16/2015)
You're getting real close, Lynn. You should start a countdown or something. 😛
I was expecting a Nasa-like countdown continuation, for example:
Lynn Pettis (2/16/2015)
February 16, 2015 at 11:32 pm
sm_iransoftware (2/16/2015)
How do you use Group By ?
If I knew the answer to the following I could show you.
dwain.c (2/16/2015)
February 16, 2015 at 11:30 pm
Viewing 15 posts - 331 through 345 (of 3,957 total)