gmrose (9/20/2011)

---

Perhaps "first" means the order in which the data was inserted into the table. It's like "First come, first served". This may not be the perfect SQL...

That does NOT define an order. There must be a column that will tell you what is "first". For...

When in doubt you should consult the datatypes and what they can handle. http://msdn.microsoft.com/en-us/library/ms187752.aspx

I am not familiar with that product and never heard of that table but, can you cast that column as a varchar?

select cast(Owner as varchar(max)) as Owner from tbl_RBS_UserRole

That looks more like a report than a query. Presentation should be done at the client and not when pulling the data. This would be a pretty simple report in...

How about just putting a begin transaction on the first line and a rollback on the last line? At least if you accidentally run the entire open window of queries...

Not sure what your question is. If you are looking for connection string format try http://www.connectionstrings.com/%5B/url%5D. If you are looking for something else try asking again to explain what you...

Sqlsavy (9/19/2011)

---

Hi All,

I'm upgrading SQL 2000 database to SQL 2008.I can find SQL 2000 collation on SQL 2008 as well.

1. Is SQL_Latin1_General_CP1_CI_AS(SQL2000) is similar to SQL_Latin1_General_CP1_CI_AS(SQL 2008)?

2....

You are in the same boat. If you are doing this totally in a stored proc you would either have to use dynamic sql or create clr stored proc.

Pretty hard to interpret what you are saying. I think you are saying you want a 1:1 relationship between the two tables? If so just make your primary key be...

Convoluted to say the least. It also doesn't work...

Most days right here on SSC. Of course I am barely qualified to be a T.A. compared to...

I think you are correct. I like the comments. 😉 Definitely demonstrates you understand what is happening. Remember that YOU need to understand what the code is doing. It is...

Your syntax error is EXACTLY the same one from a couple posts ago. Basic syntax of a case statement...

jbalbo (9/16/2011)

---

Hi,

I have this statement:

insert into @TEMPTABLE (TAG_NAME, TAG_DATA)

select TAG_NAME = 'CUST_ALLERGIES',

TAG_DATA =CRT.FullName + '~' + M.GENERIC_NAME

FROM MEDICATION M WITH (NOLOCK)

INNER JOIN CLIENT_ALLERGY CA ON M.OID = CA.MEDICATION_MONIKER

Inner join...