--Start by making some test data

DECLARE @TABLE AS TABLE(

[COMPANYNAME] VARCHAR(35),

[USER_id] VARCHAR(3))

INSERT INTO @TABLE([COMPANYNAME],[USER_id])

SELECT 'Company A', '101'

UNION ALL SELECT 'Company A', '102'

UNION ALL SELECT 'Company A', '103'

UNION ALL SELECT 'Company B',...

DECLARE @TABLE AS TABLE(

id UNIQUEIDENTIFIER)

INSERT INTO @TABLE

SELECT Newid()

SELECT *

FROM @TABLE

WHERE CONVERT(VARCHAR(255), id) = 'd65cafc-1435-45d3-acce-dc464f02c4b1'

How's that?

Isnull is your friend 🙂

SELECT 'ActiveProd' = Isnull((SELECT COUNT(*)

...

Try a network trace?

Maiorum

INTs don't have 0's padding. If you want to keep them, you'll have to use something else, e.g. VARCHAR.

Gianluca Sartori (7/14/2010)

---

Not sure. It's not typical quoting object names with square brackets in homework...

I could be...

John N (7/14/2010)

---

The soundex query? select custname from mastercustomer where soundex(custname) = soundex=('SCOTTIE').

result:

custname

scott

scotty

scot

....

This is what i'm looking for but is this the right contxt to use soundex? or should i...

Something tells me that I may have just answered a homework question :Whistling:

Eugene Elutin (7/14/2010)

---

your litle "cheat" will only work for cases where the second part of data is less than 10 .

Check what will happen if you add 1.10 or 2.10...

There's no data in the table variable that you've created there, so it will return zero rows.

OK. Looks to me like you're pretty new to SQL. So, can I suggest that you take some time out to ensure you understand how both examples work?

;WITH cte (...

I'm guessing here, but do...

I've actually already answered this in the thread you started on it, go check 😉

Assuming I've understood you correctly, this should be what you want.

--Once again, I'll build your test data first

DECLARE @TABLE AS TABLE(

[RequestID] INT,

[RequestItemID] INT,

[CostLocal] FLOAT,

[Qty] INT,

[Total_doller] FLOAT)

INSERT INTO @TABLE([RequestID],[RequestItemID],[CostLocal],[Qty],[Total_doller])

SELECT 331, 1036,...