GilaMonster (10/18/2008)

---

The error message is fairly clear. The data types don't match. A VARCHAR(max) is not the same as a DirectoryInfo. What are you expecting to be passing to this...

I have blogged about this. Please see my post at:

http://dbalink.wordpress.com/2008/06/15/find-user-tables-and-their-columns-info-in-sql-server/

please document the issue and solution and post it somewhere...optionally, you can post in my blog: http://dbalink.wordpress.com 🙂

mycol's data type is INT

My Update would look something like this:

UPDATE dbo.mytable

...

The videos tutorial of Paul Nielsen on TSQL (SQL Server 2005) is great! I believe it is from Total Training. If...

Ariadne (8/8/2008)

---

I think there's a company in Tulsa, Oklahoma that is planning to offer a SQL Server University type thing where you apply and if you are selected for the...

You can download a Red Gate's Trial Software that comes with a Free eBook. The ebook is a good source. Find it here: http://www.devx.com/RedGateVS/Door/37320

You can also check some...

It would be great if you also post your specific questions here. 🙂

Try to get you cursor value from a table. I think the problem lies in here:

declare get_patient_id CURSOR for

...

You can only use the License once. Those are NOT trial versions.

It could be that you are dropping the temporary table inside the cursor. try:

Close mycursor

Deallocate mycursor

Drop Table #mytemptable

-Marlon Ribunal

Learn how to use the tools (execution plans, optimizer, etc). I don;t think they do much good until you understand the underlying nature of the beast.... And our tracking db...

You can also get Visual Studio 2008 Prof Ed, Windows Server 2003, etc if you are eligible...

if you are a student or have a student son/daughter, nephew/niece that is on technology field, take a look at this: https://downloads.channel8.msdn.com/Products.aspx

I actually used the IP address of the server in my script: