Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fix Join strings to get correct records
Message
 
 
To
14/09/2007 17:46:33
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01254404
Message ID:
01254475
Views:
15
What is meanung of NULL in the timefield column? How records with NULL is sorted relativly to other records?

>there can be 6 records for morning and 6 records for afternoon, any others are ignored.
>
>>How many records could be in each group?
>>
>>>
>>> This query is suppose to combine another table into a wide table. From my questions before about getting records from going down to going across:
>>>
>>>id    timefield         field1  field2  field3   field4
>>>1      01/01/00 15:45    hi      0       check   field
>>>1      01/01/00 7:48     bye     1       double  main
>>>2      01/01/00 14:51    hi      0       check   field
>>>2      01/01/00 8:48     bye     1       NULL    main
>>>3      NULL              get     0       fake    NULL
>>>3      NULL              get2    1       fake    NULL
>>>4      01/01/00 16:05    get1    1       fake    NULL
>>>
>>>need to get into this form:
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform