Viewing 15 posts - 586 through 600 (of 10,144 total)
September 5, 2017 at 9:42 am
-- sample data
September 4, 2017 at 5:26 am
edwardwill - Friday, September 1, 2017 1:45 AMExcept that it's known almost everywhere as a Table Value Constructor, not Valued.
No, it isn't....
September 1, 2017 at 1:55 am
August 31, 2017 at 7:28 am
Have you tried messing with LAG and LEAD?
SELECT *,
KeepMe = CASE WHEN LAG(SuggestedName,1) OVER(ORDER BY [Name], SuggestedName) = [Name]...
August 30, 2017 at 9:29 am
locn_no varchar(20)
cust_no varchar(20)
address varchar(20)
desc billed_det
cust_no varchar(20)
order_amount numeric(5,2)
oreder_date datetime
expecting output:
cust_no locn_no
details who are not billed...
August 30, 2017 at 7:50 am
twin.devil - Wednesday, August 30, 2017 4:24 AMSomething like this will do
select '044123044' as OrginialValue, STUFF('044123044', 1,3,'0') as AdjustedValue
with...
August 30, 2017 at 4:38 am
August 30, 2017 at 3:12 am
August 30, 2017 at 2:23 am
When I run a 'Select * from product', I get 28k rows. ...
August 29, 2017 at 10:39 am
This is a generic question regarding query optimization.The query is working fine yesterday i.e....
August 29, 2017 at 5:47 am
August 25, 2017 at 9:38 am
August 25, 2017 at 8:31 am
Viewing 15 posts - 586 through 600 (of 10,144 total)