Viewing 15 posts - 2,101 through 2,115 (of 4,087 total)
sgmunson (12/14/2016)
drew.allen (12/14/2016)
It looks like a simple pivot/crosstab. Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]Drew
Yes, but that assumes that the values "StartDate" and "EndDate" are...
December 14, 2016 at 8:34 am
It looks like a simple pivot/crosstab. Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]
Drew
December 14, 2016 at 8:03 am
Your XML is incomplete.
I think you have the wrong scope for your CASE/SUM statement. You have your SUM inside your CASE when you probably want your CASE inside your...
December 13, 2016 at 3:05 pm
Definitely use a VCS. We're using TortoiseSVN.
Drew
December 13, 2016 at 12:37 pm
Jack Corbett (12/13/2016)
Any chance you could normalize the structure so the Yes/No columns are in a separate or separate table(s). Maybe...
December 13, 2016 at 11:12 am
Does any else think that this response borders on being unethical? http://www.sqlservercentral.com/Forums/FindPost1842475.aspx It sounds like she wants to use this approach just to avoid due diligence.
Drew
December 13, 2016 at 10:01 am
Part of the reason that bits were introduced was because of the complexity of using bitfields and bitwise computations. You're already seeing some of the issues, in that you...
December 13, 2016 at 8:48 am
SQLUSERMAN (12/10/2016)
To me the query for the above requirements would be as...
December 12, 2016 at 1:45 pm
paulo.margarido (12/12/2016)
MMartin1 (11/30/2016)
declare @fromDate date, @toDate date ;
select @fromDate=
dateadd(m,0,cast(Cast(year(getdate())-2 as char(4)) as date))
select @toDate = cast(getdate() as date) ;
Select @fromDate , @todate
by
declare @fromDate date,...
December 12, 2016 at 8:46 am
You're not excluding the records that you've already processed, so you're processing them over and over again. Try adding the line
WHERE a.load_id <> q.load_id
Drew
December 8, 2016 at 12:58 pm
padmakumark26 (12/8/2016)
In the New combined DB we will have two user(Hms,EAM) and two schema (HMS,EAM) and...
December 8, 2016 at 11:33 am
Peter Brinkhaus (12/8/2016)
SELECT
Q.memid,
Q.EffectiveDate,
Q.termdate,
...
December 8, 2016 at 9:33 am
You're seeing the before (deleted.*) and after (inserted.*) picture. You can't do that with a single set of columns. What are you trying to do where this is...
December 8, 2016 at 8:18 am
jbalbo (12/7/2016)
HiHaving a problem trying to figure out formatting a datettime as "mm/dd/yyyy h:mm:ss AM/PM"
Any help would be great!!
Thanks
datetime fields do not have a format, because they need to be...
December 7, 2016 at 2:23 pm
CELKO (12/6/2016)
Unfortunately you have a TOP () operator. This proprietary and totally nonrelational operation requires a sort, hence the order by clause.
Actually, that's not true. The ORDER BY clause...
December 7, 2016 at 8:39 am
Viewing 15 posts - 2,101 through 2,115 (of 4,087 total)