mageshh11 (7/5/2011)

---

Thanks for your quick response. But

Sorry it is actuall my mistake. I given the sample output wrongly.

The output should be: (All the rows from master even if rows are...

If I understand your question correctly, this could be an answer:

-- create temp tables

DECLARE @master-2 TABLE (

ID int NOT NULL PRIMARY KEY,

Name varchar(4)

)

DECLARE @Details TABLE (

ID int NOT NULL,

Name char(4),

[Date]...

Tom, I'll borrow your test data...

Another possible solution:

IF OBJECT_ID('tempdb..#Employee') IS NOT NULL

DROP TABLE #Employee

IF OBJECT_ID('tempdb..#BudgetCode') IS NOT NULL

DROP TABLE #BudgetCode

CREATE TABLE #Employee (

EmployeeId int NOT NULL PRIMARY KEY,

EmployeeCode...

Almost forgot: here you will find a great blog post by Jonathan Kehayias that deals with cost threshold for parallelism:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx

Also, consider that sometimes a parallel plan is not the best...

I heartedly agree. I had to set it to 20 on my main OLTP instance, but...

Looks like I missed a lot of things during the weekend...

Congratulations to Gail, Jeff and everyone else who got renewed!!!

:-D:-D:-D:-D:-D

He...

Personally, I don't like the StackOverflow model. There's no...

One of the worst Celko posts ever.

He must have stepped on dog poop today.

Joe, I suspect the OP won't find your post very useful.

Nor do I, indeed.

Satnam Singh (6/29/2011)

---

One strange thing i have just observed. In the entire block of code in one section there are two conditions seperated by AND operator, if i comment any...

I'm sorry, I don't understand. Can you please post the expected results based on your sample data?

I highly doubt this can be done, but I'm waiting for other members' suggestions, if any.

There's some information that you have to share in order to have a chance to receive a sensible answer.

Take a look at this article and post the information required:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Regards,

Gianluca

Cast to a fixed length character type:

select 'PL01'+'_'+ CAST(vendor as char(7)) +'_'+shipto as DocumentNo

from Product

Hope this helps

Gianluca

EDIT: fixed typo