Viewing 15 posts - 6,406 through 6,420 (of 8,753 total)
Nice "first coffee" question, thanks.
😎
BTW: another good read on the subject (MSDN) Caching Mechanisms
December 17, 2014 at 12:00 am
DonlSimpson (12/16/2014)
MMartin1 (12/16/2014)
NULLIF((EVT.VAL2), 0)
Maybe I'm just missing something here, but how can the above EVER return a zero?
It would not, but that is what the user wanted. That is to...
December 16, 2014 at 2:08 pm
arunkumarcg (12/16/2014)
Ok thanks.But how will i apply this in my query?
Instead of EXEC sp_describe_first_result_set, should i mention my proc name?
What should i do here Select * from sys_objects?
Replace "Select *...
December 16, 2014 at 1:21 pm
arunkumarcg (12/16/2014)
Here sysobjects is a table.I do not have a table, i have to create one dynamically with sparse columns.
Thats my question.
The code demonstrates how to use sp_describe_first_result_set to get...
December 16, 2014 at 11:49 am
A quick example of sp_describe_first_result_set
😎
DECLARE @RES TABLE
(
is_hidden ...
December 16, 2014 at 11:07 am
Stefan Krzywicki (12/16/2014)
Eirikur Eiriksson (12/16/2014)
Jeff Moden (12/16/2014)
Steve Jones - SSC Editor (12/15/2014)
Jeff Moden (12/14/2014)
December 16, 2014 at 10:49 am
Quick thought and if I remember correctly, use ODATaskParams.Fill to populate the object type variable
😎
December 16, 2014 at 10:31 am
Jeff Moden (12/16/2014)
December 16, 2014 at 10:26 am
Jeff Moden (12/16/2014)
Steve Jones - SSC Editor (12/15/2014)
Jeff Moden (12/14/2014)
December 16, 2014 at 10:24 am
DonlSimpson (12/16/2014)
Are you able to build a calendar or "dimDate" table? That will simplify this and similar queries that come up in the future.
+1
for any warehouse / reporting...
December 16, 2014 at 10:14 am
Eric M Russell (12/16/2014)
Eirikur Eiriksson (12/16/2014)
...
There is an alternative for this case which is the sparse column, it practically does normal foreign key constraint when the value is not null,...
December 16, 2014 at 10:07 am
gkramer 23701 (12/16/2014)
There is one main database but I'm not sure (yet) of some support databases will come along.
As you are suggesting in your reply - is there a way...
December 16, 2014 at 10:02 am
Eric M Russell (12/16/2014)
December 16, 2014 at 8:22 am
Quick question, wouldn't it be enough to change the collation for that single database?
😎
December 16, 2014 at 7:49 am
Quick though, laurie-789651's solution is good but given the requirements of
The condition is first SP should check if same SRC is repeating if yes then do dedup on IP_ref...
December 16, 2014 at 7:39 am
Viewing 15 posts - 6,406 through 6,420 (of 8,753 total)