Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fiveeuros

    CASE statement and NULL / NOT NULL

    Hi, I'm trying to work a stored procedure with a NULL value in a case statement and can't get the syntax correct. I've got a varchar parameter (@BrokerType) that can be either 'AFFILIATED', 'NON-AFFILIATED' or 'BOTH'. The stored procedure then has a join (simple 1-1 join using a WHERE...
  2. fiveeuros

    Aggregating / grouping varchar fields

    That's just about what I was looking for... I should have searched the forums a bit more before I posted but thanks for the heads up!
  3. fiveeuros

    Aggregating / grouping varchar fields

    Hello, if I have a table like Name varchar(10), Status Varchar(10) with entries NameOne StatusOne NameOne StatusTwo NameOne StatusThree NameTwo StatusOne NameTwo StatusTwo Is there an easy way to script some SQL that would return the following: NameOne StatusOne, StatusTwo...
  4. fiveeuros

    BizTalk 2004 Remote Deployment

    Hi All, I've been able to deploy BizTalk Server 2004 to a (semi) dedicated server on our network and have also installed the development tools on my own machine (Big thanks to SgtPeppa for his reply to my last post). I've worked my way through the tutorial and it all looks good... until I go to...
  5. fiveeuros

    BizTalk Server 2004 Development noob question

    Hi, I've been reading up on BizTalk Server 2004 as I have to prepare a feasibility report for my manager. Everything I've seen has been to do with the (lengthy) installation process and prerequisites - however I have a (hopefully) simple question regarding development that I can't find a...

Part and Inventory Search

Back
Top