Thats the problem when the requirement is unclear with no DDL...

Also i got a doubt here; Are there any values in the p_code, p_name columns that dont comply to the Rules of Identifiers?? [For rules of identifiers CLICK HERE...

Had u posted the necessary DDL, sample data and desired output, people would have replied and fixed your problem just at the wink of your eyes..:-)

Anyways, happy to have helped...

Am sorry buddy, i cant be of much help to u in this.. lets wait for our SSC bigwigs to attend this...

Cheers!!

For the below statment,

IF @PARTNER_CODE <> '' AND @PARTNER_NAME <> ''

add ISNULL check also and try mate.. lets see if that help...

P.S: I am writing this from home where i...

Without Table structure, or sample data we cant proceed further buddy :(.. and thats the reason tho u have 20 views, u have only 2 replies...

But for a starter, i...

Oh i get it... hmmm... i dont think we have a way to check that out using T-SQL, BUT I MAY BE WRONG.. probably with little bit of a helping...

1. After the first EXEC(@SQL), flush the @sql variable; like , SET @sql = ''

2. Check if the partnercode and partnername column values are not null and then use it...

Buddy, request unclear.. can u pls post some visual representation of your desired result based on the location and track number??

Buddy, dint get ur question fully... u mean, u now need a way to find out if the SQLSERVER and its entourage services are running using T-SQL code, am i...

Thanks Karthikeyan!! I wonder how an...

Jeff Moden (4/19/2010)

---

You still might want to read the articles that Lutz pointed out, though. I know the guy that wrote them and he put some good stuff in...

As you said no dynamic sql, i had come up with this approach.. one dis-advantage i am thinking of in this one will be the ; (semi-colon)character i am...

Hey hi, i know Jeff has given a code for your requirement, which will be 100% fast and reliable..

I just tried out some other way of coding your requirement...

I second Jeff.. any import from a flatfile should be put up in some holding table which will have nvarchar or varchar columns.. then apply your business logic and insert...