gsd1 (10/29/2012)

---

Ray M,

Thanks for the quick response...

I don't know the column type to declare the table variable initially.

I have to query sysColumns table to know the columns and then...

Not the approach I...

You need to handle that in the front end. Your statement needs to complete before...

I was...

eugene.pipko (10/29/2012)

---

Hi all,

I have the following construct:

select name, value

from

( select name, value from view1

union all

select name, value from...

http://msdn.microsoft.com/en-us/library/ms178569.aspx

Jeff Moden (10/27/2012)

---

I wonder how many 3 and 4 letter swear words such a proccess will actually spell out.

I strongly recommend not using incrementing alpha-numerics for just such a reason...

You're welcome. Glad you figured it out and thanks for letting us know. 😀

prathibha_aviator (10/29/2012)

---

BriPan (10/28/2012)

---

Try this One

select

* -- What ever column you want

,(case when Customer.CustomerID >3 then Order.PO else Order.OrderID end) as 'PO/OrderID'

from

Customer

inner join CustomerOrders on Customer.CustomerID =CustomerOrders.CustomerID

inner join Order...

komal145 (10/29/2012)

---

Oh yaa.Realized the mistake.... I corrected it.It worked.Thanks.

But when I tried to run the Sp by passing @InvestorCode_FROM and @InvestorCode_TO and not giving @Investor_all.

Example

EXEC [dbo].[usp_Get_Investor] 1000 ,2000

It throws...

webtekkie (10/29/2012)

---

Hi Sean,

Yeah, it does sound like a strange request, but I'm working for a bank and we have historic data in all sorts of wierd formats. It's not...

prathibha_aviator (10/29/2012)

---

Thanks for the reply I tried using this and got some error

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar value 'Verbal' to data...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1378336-148-1.aspx

komal145 (10/29/2012)

---

Hi..I am trying to create Sp as below:

CREATE PROCEDURE [dbo].[usp_Get_Investor]

@InvestorCode_FROM INT

,@InvestorCode_TO INT

,@Investor_all VARCHAR(MAX)

AS

BEGIN

SET NOCOUNT ON

IF(@InvestorCode_FROM AND @InvestorCode_TO IS NOT NULL)

BEGIN

SELECT DISTINCT(OWN.INVESTOR)

FROM dbo.TABLEA...

webtekkie (10/29/2012)

---

Hi,

I've been given the task of creating a single unique numerical value from two composite unique alphanumeric values. It needs to be possible to convert in both directions.

So,...