Kurt W. Zimmerman (8/12/2011)

---

Sean Lange (8/12/2011)

---

I think the more important question is how can you eliminate your cursor and therefore not really care about some of the subtle details. 😛

Honestly...

But you aren't doing anything inside the loop except writing a line to the screen...

...use the query with the left join here...

set rs = server.CreateObject("adodb.recordset")

rs.open sql, conn

while not rs.EOF

Response.Write("<tr><td class='fielddHeader'...

That is because you don't have proper spacing in your string. You can always "response.write sqlz" prior to executing it so you can debug your sql. Also, you could use...

Just a table alias so you don't have to type out the whole name again. You can make the alias anything you want, or not even use it. I find...

See explaining the problem can lead to much better code. 🙂

try this in your first query instead:

select isnull(b.User_Name, 'Not Available') as UserName, ISNULL(P2_Date_Acknowledged, 'N/A') as Result1

from Investment_Advisor ia

left join Investment_Advisor_Part2...

tomperson349 (8/12/2011)

---

Ok guys I have another question for you. I am using this query:

sql = " select b.User_Name "

sql = sql & " from Investment_Advisor b "

sql...

Just a swag at what you are after...

create table #Nums

(

col1 int,

col2 int,

col3 int,

col4 int

)

insert #Nums (col1, col2, col3, col4)

values

(90, 20, 60, 5),

(50, 10, 0, 8),

(0, 0, 0, 0),

(20, 5, 10,...

By definition a function canNOT return more than one value. That value could be a table of course which is referred to as a TVF (table valued function).

Look at the...

Not a lot of detail to go on but...

I assume you enter this record and then update it? Get the identity when you insert and pass it to your update...

YHChan (8/11/2011)

---

hi,

recently i have make a mistake which i forgot to put in the 'where' statement and cause the all record from a table ( around 3 million ) updated,...

And why are all your variables varchar(700)?

Because @scope_Id is null. I assume you are calling this from your page which means the connection is new and therefore scope_identity() is null.

It isn't going to work like that at all. You have now defined two aliases for the first column.

Microsoft has examples using the AdventureWorks database for all of their topics. You will have to figure out what topics you need help with. The topic of sql server is...

SQL Server is a pretty broad topic. The Microsoft tutorials are a good place to start.