Viewing 15 posts - 196 through 210 (of 244 total)
yea. i'm still a little freaked out that the isnull returns the first params type and length no mater what. Don't know how i didnt run into this before. Run...
December 14, 2009 at 9:27 am
Yea. i didn't follow what u guys were saying before.
I see what your saying now. Wow. That's crazy and good to know.
December 14, 2009 at 8:58 am
The below will allow u to perform your update in chucks of whatever desired size u want. Correct my if i'm wrong but i suppose the idea is to have...
December 14, 2009 at 8:52 am
actually u can use isnull in all situations if u wanted to. A coalesce is a nested isnull.
coalesce(custname, last, first) = isnull( isnull( custname, last ), first )
Therefore a...
December 14, 2009 at 8:26 am
not sure what ur saying about the selecting for a cte because u can sdo that w/ the #tables as well.
However that is very interesting the the QO will look...
December 9, 2009 at 7:41 am
Are u saying if i'm using a #table and it has 10,000 recs then the optimizer may not optimize properly? Interesting. Would it by using the CTE w/ 10,000 recs?
December 9, 2009 at 7:23 am
not sure if i'm following however give it a shoit. are u saying u have 10 different inserts to the same table. each insert has it's own select it is...
December 9, 2009 at 7:18 am
All very useful info guys. Once again it appears the geniuses at sql server have designed a new way to do the same thing but w/ different syntax. Sure there...
December 9, 2009 at 7:13 am
Dont everyone answer at once now.
December 8, 2009 at 3:38 pm
i ran the following to find where this subscriber_id originates and can't find it.
select distinct tb.table_name
from INFORMATION_SCHEMA.TABLES tb (nolock)
join INFORMATION_SCHEMA.COLUMNS col (nolock)
on tb.table_name = col.table_name
where table_type =...
December 8, 2009 at 3:14 pm
i see there is a MSsubscriber_info table however it doesn't have an id column which i find very bizarre.
CREATE TABLE [dbo].[MSsubscriber_info](
[publisher] [sysname] NOT NULL,
[subscriber] [sysname] NOT NULL,
[type] [tinyint] NOT NULL,
[login]...
December 8, 2009 at 3:12 pm
Why dont u just do the check in the proc that is loading the record?
December 4, 2009 at 7:54 am
nevermind i found it. sysmail_mailitems
INSERT sysmail_mailitems
(
profile_id,
recipients,
...
December 4, 2009 at 7:25 am
THIS WILL WORK....DID NOT TEST IT BUT THE METHOD IS SOUND
select a.departmentid
,ISNULL( B.CNT,0)
from department9 a
left join (
SELECT departmentid
, COUNT( * ) CNT
FROM empdept9
GROUP BY departmentid...
December 3, 2009 at 1:07 pm
Viewing 15 posts - 196 through 210 (of 244 total)