Viewing 15 posts - 4,366 through 4,380 (of 8,761 total)
g.britton (10/13/2015)
Shouldn't your example output be:1 0 Apple
4 2 Apple
8 3 Apple
Guess it's "before and including"
😎
October 13, 2015 at 1:50 pm
jeffrey.sharp (10/13/2015)
Product_ID identity 1,1
Product_Purchased varchar(25)
1 Apple
2 Pear
3 Banana
4 Apple
5 ...
October 13, 2015 at 1:49 pm
arrjay (10/13/2015)
Hi there - For SQL Standard edition, would I need multiple licenses if I created multiple named instances on the same physical or virtual server?Thanks, Russell.
Quick answer is that...
October 13, 2015 at 1:29 pm
Quick thought, change the data type from datetime to datetime2, the value is out of range for the former.
😎
October 13, 2015 at 9:51 am
Quick question, have you considered turning on compression on those tables and indices, most likely more effective and almost no risk involved.
😎
October 13, 2015 at 1:48 am
ChrisM@Work (10/12/2015)
October 12, 2015 at 12:27 pm
eklavu (10/12/2015)
I'am having an issue fetching Chinese characters in a XML data type. It return questions mark (?).
Would you be able to advise me? TIA.
Below is the sample script.
DECLARE...
October 12, 2015 at 12:20 pm
Luis Cazares (10/12/2015)
crookj (10/12/2015)
djj (10/12/2015)
eccentricDBA (10/9/2015)
Ed Wagner (10/9/2015)
Luis Cazares (10/9/2015)
Eirikur Eiriksson (10/9/2015)
Ed Wagner (10/9/2015)
DonlSimpson (10/9/2015)
anthony.green (10/9/2015)
Ed Wagner (10/9/2015)
crookj (10/9/2015)
Ed Wagner (10/9/2015)
happygeek (10/9/2015)
Deadlock victim!Cost
Expense
Revenue
Tax
Tariff
Price Increase
Pint
Pitcher
Round
Parrotheads
Paradise
Snake Eyes (pair a dice)
G.I.Joe
DYJoe
October 12, 2015 at 12:14 pm
vipin_jha123 (10/12/2015)
Yes sir
Slight different between the two, roughly connect_by_isleaf is the equivalent of GetDescendant
😎
October 12, 2015 at 2:21 am
Quick question, is this hierarchical data?
😎
October 12, 2015 at 1:07 am
Quick solution
😎
SELECT
RoleName = max(pr.name ...
October 10, 2015 at 10:12 am
Ed Wagner (10/9/2015)
DonlSimpson (10/9/2015)
anthony.green (10/9/2015)
Ed Wagner (10/9/2015)
crookj (10/9/2015)
Ed Wagner (10/9/2015)
happygeek (10/9/2015)
Deadlock victim!Cost
Expense
Revenue
Tax
Tariff
Price Increase
Pint
October 9, 2015 at 11:40 am
Slightly more pedantic approach preventing an implicit conversion
😎
DECLARE @sql NVARCHAR(400)
DECLARE @WgnWCUser VARCHAR(30)='DBO'
DECLARE @TIMESTAMP VARCHAR(30)='UpdateTimestamp'
DECLARE @datFrom DATETIME='20150916'
DECLARE @datTo DATETIME='20150930'
SET @sql='SELECT EVENTUID,EVENTTIMESTAMP,EVENTMAJORTYPE,EVENTMINORTYPE INTO #TEMP
FROM ' + @WgnWCUser + '.EMPLOYEE A WITH(NOLOCK)
WHERE A.'+@TIMESTAMP+'>=CONVERT(DATE,'''+CONVERT(VARCHAR(25),@datFrom,112)+''',112)AND...
October 9, 2015 at 9:51 am
dwain.c (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB...
October 8, 2015 at 11:29 am
sandhuz24 (10/7/2015)
Sorry for the delay in getting back to the post. Been really busy at work. I had the indexes on the table as you suggest in your post...
October 7, 2015 at 2:48 am
Viewing 15 posts - 4,366 through 4,380 (of 8,761 total)