This looks like Year, Month, Day? You have 112 as your year.

But more importantly WHY not use datetime datatypes. And if you MUST separate out the portions WHY varchar...

These types of questions are designed to test your knowledge of the subject. The response is not a single answer but should start a discussion between you and the interviewer....

That is what I was guessing...

Lowell (3/12/2012)

---

i do this in a programming language so i can use regular expressions;

There are two issues to look at...are two procs EXACTLY the same , character for character, or...

could you just determine the checksum of the text column from sys.syscomments. Then in your rollout script you just include that in your check to determine if the current database...

Not 100% sure this is what you are looking for since you sample output had nothing to do with the original data.

Something like this?

select rooky.rid,cooky.nid,nooky.nname,cooky.total,isnull(

(

select top 1 x.total from cooky...

CraigIW (3/12/2012)

---

Hi Sean,

Sorry, I'm a bit tired. You are right about the ISNULL. It is there as the column is nullable, but the expressions are equivalent.

The UDF is...

Conceptually this is challenging. Do you specify the target and compare the others against that? If you are rolling out sprocs to a hundred db's what do you need to...

Excellent job with ddl and sample data. However each time I read your description of the desired output I am more confused than I was after the previous reading.

Can you...

I agree with Eugene. Insert with OUTPUT will accomplish exactly what you are looking for.

create table #abc

(

col1 int identity,

col2 varchar(10)

)

create table #bbb

(

col1 int,

col2 varchar(10)

)

insert #abc (col2)

output inserted.col1, inserted.col2 into #bbb...

Charmer (3/12/2012)

---

Charmer (3/12/2012)

---

But the thing is i did not create the stored procedure...

it was previously created by some one....Now i changed it as you guys told that there would be...

CraigIW (3/12/2012)

---

Hi Usman,

You suggest swapping

ISNULL(ManualSales.ManualSale,0) = 1

for

AND ManualSales.ManualSale = 1

AND ManualSales.ManualSale IS NOT NULL

but I don't think these are logically equivalent? The original would include NULL but...

Charmer (3/12/2012)

---

Sean Lange (3/12/2012)

---

I have to agree with Jessie here....WHY are you passing sql as a parameter???? I am going to take a guess that you will now execute the...

I have to agree with Jessie here....WHY are you passing sql as a parameter???? I am going to take a guess that you will now execute the sql passed as...

you're welcome.