bitbucket-25253 (12/19/2011)

---

LutzM Posted Today @ 9:07 AM

Hmmm.... interesting....

Based on the (almost public available) age of the two fellows you're somewhat between 14 and 16 years old. Hard to believe that...

It works, but the day of week and time calculations don't have to be run multiple times. Apply is handy for this sort of thing:

SELECT

d.aRow,

d.aDate,

x.[Dayname],

x.TheTime,

Weekend = CASE...

pespes009 (12/19/2011)

---

its being highlighted in the temporary table above...although i did not paste that here

I think the problem is with the join on the

JOIN VR_DataLoad.prdrmkt.dbo.tbl_asset_instance ai

not that at all

Please...

You will need to work outside of the stored procedure, checking each query separately, in order to get this working. Can you do this? Here's the first part. You don't...

The one which is referred to in the second query:

isNull(#a.DisposalType, '''') AS DisposalRoute,

The second column here isn't named:

INSERT #a

SELECT

currA.numAsset_instance_id,

CASE WHEN isnull(vcca.numAsset_instance_id, 0) > 0 THEN ''Retail''

WHEN isnull(vcaa.numAsset_instance_id, 0) > 0 THEN ''Auction''

ELSE ''Unassigned''

END

FROM VR_DataLoad.prdrmkt.dbo.v_current_asset_instance currA

CASE resolves a value or column:

SELECT aValue = CASE WHEN 1 = 1 THEN 10 ELSE 20 END

Your query fails because CASE is resolving a statement.

Try this:

;WITH MyTable AS (SELECT...

Easy to check if this is the case

SELECT TOP 10 * FROM VR_DataLoad.prdrmkt.dbo.v_current_asset_instance

SELECT TOP 10 *...

Hi Sami

Can you change your data samples to DDL please? CTREATE TABLE and INSERTs. If you're not sure how to do it, read the link in my sig (please read...

Please don't cross post, it fragments replies and wastes time.

Replies to http://www.sqlservercentral.com/Forums/FindPost1223667.aspx

Hi

Can you set up your sample data for easy consumption, like this:

CREATE TABLE #Sampledata (LEVEL1 datatype, LEVEL2 datatype, LEVEL3 datatype, LEVEL datatype, ID datatype, datatype, DESC datatype, CUSTNO datatype,...

John Mitchell-245523 (12/16/2011)

---

Beware - this will bite you if any row you are updating (call it table1) has more than one match in the table you are updating from (table2)....

GSquared (12/15/2011)

---

It does not use SQL Server Database Mail.

It does use SMTP. But so does Database Mail. SMTP is simply the mail transfer method ("Simple Mail Transfer Protocol"...

This will generate different results to...

Folks may be a little reluctant to help with this because it looks - forgive me if I'm wrong - as if someone fairly new to TSQL has gone a...