Viewing 15 posts - 1,861 through 1,875 (of 10,143 total)
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
dprasannain (12/10/2015)
Why doesn't this query return's any value . Whats wrong with this querySelect * from #emps Where EN IN (@Names)
- because @Names isn't the comma-delimited list of string values...
December 10, 2015 at 8:31 am
Viewing 15 posts - 1,861 through 1,875 (of 10,143 total)