find if all fields are there - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

find if all fields are there

Author

Topic

helixpoint
Constraint Violating Yak Guru

291 Posts

Posted - 2003-06-19 : 08:44:08

I have 2 tables:
tempquote and tempquotedetail

I need to be able to check if certain fields and not <null> or not empty.
tempquote and tempquote detail are joined by tempQuoteID.

So basically I need to know if the is data in the following fields in
tempquote:
quoteDate
quoteDateThrough
quoteNotes

and in tempquotedetail:
machineID
contactID

I pass a unique number to tempquote using a stored procedure. If all the
data is there, I need to send back the fields that are missing???
Does anyone have an example of this????

______________________
David Fetrow
HelixPoint LLC.
http://www.helixpoint.com
davef@helixpoint.com

Interested in Affordable Email Marketing?
Check out the HelixMailer at http://www.helixpoint.com/helixmailer.asp
If you are interested in becoming a Reseller of HelixPoint products, contact
davef@helixpoint.com
______________________

mr_mist
Grunnio

1870 Posts

Posted - 2003-06-19 : 08:51:32

I don't understand your requirements.

What exactly do you want to see in your output?
What is the DDL for the tables?
What do you mean "pass a unique number"?

"If all the data is there, I need to send back the fields that are missing???". If all the data is there, then there will be no missing fields...

-------
Moo.

helixpoint
Constraint Violating Yak Guru

291 Posts

Posted - 2003-06-19 : 09:05:09

I am passing the SP:

' Add Parameters to SPROC
Dim parameterQuoteCookieID As New SqlParameter("@QuoteCookieID", SqlDbType.NVarChar, 50)
parameterQuoteCookieID.Value = QuoteCookieID
myCommand.Parameters.Add(parameterQuoteCookieID)

I can't explain it any better???
If quoteDate is null, then I was hoping to pass back like a comma seperated string of field names like quoteDate,machineID

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-06-19 : 09:38:47

Give us some sample data, and what you expect to get back as results based on that sample data.

I apologize if English is not your native language, but this makes no sense:

quote:

If quoteDate is null, then I was hoping to pass back like a comma seperated string of field names like quoteDate,machineID

- Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources