Tagged Questions
2
votes
3answers
131 views
Join/merge two tables, improvise/make up “missing” entries
I have two tables, tbl_foo and tbl_bar, and I want to join these tables with tbl_foo.foo_id = tbl_bar.foo_id in the on-clause. However, for each tbl_bar.baz_id there should be one row for each ...
1
vote
3answers
121 views
how to find a missing case using proc sql in sas?
I would like to use proc sql in sas to identify if a case or record is missing some information. I have two datasets. One is a record of an entire data collection, that shows what forms have been ...
1
vote
1answer
20 views
Calculate variance of frequencies when dataset does not contain entries of frequency zero
I have a dataset that has three fields: id, feature and frequency. What I want to do is find out, for a group of given id's, which feature has the largest spread of frequencies. The result I want is ...
1
vote
3answers
195 views
t-sql query that returns missing records
I have a query (ContactFormTypesRequired) that returns ContactID and FormTypeID utilizing related tables that are not shown below. This is a list of FormTypes that each Contact should have related to ...
0
votes
1answer
164 views
SQL Server 2008 finding missing rows [duplicate]
I have a huge DB and one table in particular is missing rows. I know this to be true but I need to find the gaps and show them. The primary key is the sequence number column. I need to show the actual ...
0
votes
2answers
156 views
Analyzing data from same tables in diferent db instances
Short version:
How can I map two columns from table A and B if they both have a common identifier which in turn may have two values in column C
Lets say:
A
---
1 , 2
B
---
? , 3
C
-----
...
0
votes
1answer
62 views
Missing database entries with a null value in row, when performing a linq statment
so here's the sql query:
Select distinct A.CategoryName, A.CategoryID, B.ProjectID
from [EvalTool].[dbo].[Category] A
Left Join [EvalTool].[dbo].[CategoryAndProject2] B
On A.CategoryID = ...
0
votes
1answer
233 views
nHibernate SQL logging + stack trace together
I'm having an issue in where records occasionally go missing from our production database. This is a .NET MVC 2 app with nHibernate. It has been worked on by several developers over the last few ...
