Viewing 15 posts - 6,421 through 6,435 (of 8,753 total)
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
Quick thought, use cross-tab
😎
Can you post DDL and sample data?
December 15, 2014 at 9:23 am
wiredvoltage (12/15/2014)
Hi many thanks for the reply.I copied your suggestion and intellisence still highlights tblRoom & tblEquipment as referencing invalid tables?
Regards
Try pressing CTRL+SHIFT+R (in SSMS) to refresh the intellisense cache...
December 15, 2014 at 6:44 am
Quick suggestion
😎
CREATE TABLE tblRoomEquipment( /* Fully descriptive name...
December 15, 2014 at 6:24 am
December 15, 2014 at 4:53 am
farrukhhameed786 (12/14/2014)
Hi SSThanks ! but how to apply in one sql query ?
The code shows the behaviour of the same NULL handling
VAL1/ISNULL(VAL2,1)
for all scenarios, simply replace the formula you...
December 14, 2014 at 11:36 pm
Steve Jones - SSC Editor (12/14/2014)
Lynn Pettis (12/13/2014)
December 14, 2014 at 11:01 am
Quick thought, could this be a name resolution issue (DNS/Browser service)?
😎
December 14, 2014 at 6:36 am
farrukhhameed786 (12/14/2014)
I am finding an error while i am dividing value. Some times Val1 is not available and some time Val2 is not available in my case. I need if...
December 14, 2014 at 6:33 am
Viewing 15 posts - 6,421 through 6,435 (of 8,753 total)