This is a workaround to your requirement:

declare @a varchar(10), @b varchar(10), @c varchar(10), @d varchar(10) = '00'

set @a='1'

set @b='2'

Set @c=+@a+@d+@b

Select @c

set @a=112

set @b=2

Set @c=+@a+@d+@b

Select @c

Hope this helps.

+1

Which edition did you download?

Try running the below mentioned query as a single query:

select s.Itemid from #sequence s join #item i on s.Itemid=i.Itemid

I think this must be returning more than one "Itemid". If that...

There are a lot of people who can help you here. For that please post DDL, sample data and an example result set of what you are expecting so that...

Yes you can do that...if the SP does what you are asking it to do

Lynn Pettis (4/26/2012)

---

dwain.c (4/26/2012)

---

I was looking at a stock table with the columns Part Number and Part Description. I just found out that we have over 95 tables that contain...

hmm...yes...could be...that's very logical Jared.

A very good shot in the dark. 🙂

sqlfriends (4/26/2012)

---

I am using red gate SQL compare tool.

I did a comparison that generats delta schema script.

I see there are some statements like :

EXEC sp_refreshview [Tests].[BusinessReport]

My question is when to...

Jeff Moden (4/26/2012)

---

vinu512 (4/25/2012)

---

OK...my bad...lets forget about printing the names.

I just want the names to be stored in 5 temp variables so that I can use them further.

Can that be...

jmiceli (4/26/2012)

---

I am not trying to hijack this thread; I am just making this information available to any interested parties.

We have this same structure except that the 2005 named instance...

No problem.

ALways happy to help...

What method did you use to import the Data??..."DTS Wizard" or you did it by creating a Job through "BID Studio"?

You need performance...right??

The best performance you can get is by getting all the data on 1 server and then perform whatever actions you want to perform...

Its...