Viewing 15 posts - 6,421 through 6,435 (of 8,761 total)
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
Quick thought, under normal circumstances if a value can be unknown/undefined/missing then use NULL, as there would be no gain in a replacement value, only complications.
😎
In simple terms the...
December 16, 2014 at 6:55 am
Greeted by a waiter when walking into a restaurant, as SQL Server developer asks "Do you have a table". The waiter responds "in 10 minutes". Disappointed the SQL Server developer...
December 15, 2014 at 1:03 pm
arunkumarcg (12/15/2014)
How does that create a dynamic table with sparse columns?
It doesn't create the table, it provides all the information about the result set needed to create the table
😎
December 15, 2014 at 12:52 pm
Quick suggestion, on SQL Server 2008 and earlier you can use SET FMTONLY, on 2012 and later use sp_describe_first_result_set
😎
December 15, 2014 at 12:41 pm
farrukhhameed786 (12/15/2014)
HiPlease Below the query i need to use condition
I need to use in below query how to use
SELECT
ISNULL(EVT.VAL1/NULLIF((EVT.VAL2),0),0) AS ITEM_ID
FROM
EVENT1 EVT
WHERE NAME IN ('JOHN','PATRICK')
Consider this...
December 15, 2014 at 12:30 pm
December 15, 2014 at 10:37 am
Doesn't this look like one of out favourite "Kitchen" people (look at the query, db name is OrbeData_KithKitchens):-D
😎
December 15, 2014 at 10:30 am
Viewing 15 posts - 6,421 through 6,435 (of 8,761 total)