Viewing 15 posts - 1,861 through 1,875 (of 10,144 total)
CONCAT is designed for stuff on the same row. For concatenating stuff from different rows you need an alternative approach, most of which are covered in Aaron Bertrand's article here.
Try...
December 17, 2015 at 3:26 am
Tallboy (12/17/2015)
Yes there is a limit of either 1 week, 2 weeks or 4 weeks maximum.
So the user chooses an option 1,2 or 4 week period and 2 dates...
December 17, 2015 at 2:14 am
twin.devil (12/17/2015)
you can also check...
December 17, 2015 at 1:43 am
Jeff Moden (12/16/2015)
ChrisM@Work (12/15/2015)
Jeff Moden (12/12/2015)
ChrisM@Work (12/10/2015)
Jeff Moden (12/9/2015)
ChrisM@Work (12/9/2015)
suvesh.sonker 2691 (12/9/2015)
-- Ten digitDeclare @field as varchar(20) = '559'
Select Replace(right(replicate(' ',10) + @field ,10),' ','0')
In what circumstances might this be...
December 17, 2015 at 1:39 am
Jeff Moden (12/12/2015)
ChrisM@Work (12/10/2015)
Jeff Moden (12/9/2015)
ChrisM@Work (12/9/2015)
suvesh.sonker 2691 (12/9/2015)
-- Ten digitDeclare @field as varchar(20) = '559'
Select Replace(right(replicate(' ',10) + @field ,10),' ','0')
In what circumstances might this be preferable to the...
December 15, 2015 at 9:41 am
SQLPain (12/15/2015)
SELECT DISTINCT
a.AppID
, CONVERT(varchar(10), a.DateAppRec, 101) AS DateAppRec
, ch.NameLong AS Dealer
, CASE WHEN ch.assignedbranch = ch.channelid THEN '' ELSE (SELECT namelong FROM channels WHERE channelid =...
December 15, 2015 at 8:48 am
LinksUp (12/14/2015)
mr.databases (12/14/2015)
CASE WHEN det_dte IS NULL THEN CAST({ fn NOW() } - rec_dte AS int) ELSE CAST(det_dte - rec_dte AS int) END
rec_dte and det_dte are both data type...
December 15, 2015 at 2:24 am
MadAdmin (12/14/2015)
serg-52 (12/9/2015)
select id,title,
ParentIdLevel1 = max(case ParentLevel when 1 then ParentId end),
ParentTitleLevel1 = max(case ParentLevel when 1 then ParentTitle end),
ParentIdLevel2 = max(case...
December 14, 2015 at 2:47 am
Steve Jones - SSC Editor (12/11/2015)
Friday
Happy!
December 11, 2015 at 8:18 am
baludw22 (12/11/2015)
Empkey = isnull(aa.empkey,(select empkey from dimemp where empid=-1)),
deptKey = isnull(bb.deptkey,(select deptkey from dimdept where deptid=-1))
it will work good.
when we...
December 11, 2015 at 6:09 am
You mean, like this?
SELECT
o.*,
NewEmpkey = ISNULL(x1.empkey,-1),
NewdeptKey = ISNULL(x2.deptkey,-1),
NewProjectname = b.projectname,
b.*
FROM Facttran O
INNER JOIN trantable b
ON o.transactionid=b.transactionid
OUTER APPLY (SELECT TOP 1 empkey FROM dimemp WHERE empid = b.empid ORDER...
December 11, 2015 at 4:28 am
baludw22 (12/10/2015)
December 11, 2015 at 2:10 am
The MERGE statement can be tricky to implement even for experienced developers. Since you're only using it for inserts it's overkill anyway. I'd recommend you use INSERT instead - it's...
December 10, 2015 at 9:14 am
pghdisturbed1 (12/10/2015)
The index locking seems to be based on a date. Does that...
December 10, 2015 at 9:05 am
Can you provide an execution plan of one of these updates please, also the definition of index IX_Table_Task_Eventdate.
December 10, 2015 at 8:46 am
Viewing 15 posts - 1,861 through 1,875 (of 10,144 total)