Eric M Russell (4/23/2014)

---

In addition to the issue pointed out by Sean, that the variable will not get assigned if there is no result returned from MyTable, you also need...

Thank you!

I find reading MS help a bit confussing as there are a lot of see something else. If you are lucky they even include a link.

Your...

Eirikur Eiriksson, I read the info and it does not give a reason.

technet

It is recommended that SET @local_variable be used for variable assignment rather than SELECT @local_variable. For more information,...

Do you want who is logged on? (sp_who2)

Notice the 1.0 versus original 1 as t-sql will return...

Look at msdb..sysjobhistory and msdb..sysjobs

Remove the quotes from around the parameters. '@Criteria1' should be @Criteria1

djmoodyjames (4/10/2014)

---

DB2 guy here, about to begin a conversion project...

I wonder if someone could answer a question about column defaults when creating a table. In DB2, to create...

Because I forget about CROSSAPPLY as I have not used it as often as...

bryan van ritter (4/6/2014)

---

I have a table with the following columns:

customnr number wk1 wk2 wk3 wk4

1200 20 5 6...

Jason, I do not think that is the problem. However that might fix it.

I did a quick test

create table Props (mapparam varchar(20));

INSERT INTO Props values (44.01);

select mapparam from Props;

update...

Guess I am not the only one not reading today. 🙂

Yep I see that now. Again sorry for the misstep.

Sorry just reread your reply.

What have you tried?

SELECT DISTINCT ?