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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.