i believe an "autologin" is nothing more than a shortcut that is passing the required parameters.

so if you want it to auto login, you add the parameters, and if you...

also, a view can use or call a function, so if the proc can be converted to a function, that is another option.

you cannot manipulate any column that is ntext,text or image from the INSERTED or DELETED...

depending on what the procedure was doing, you might be able duplicate the logic from the proc in a view by using a CTE or two, but again it really...

Bob Cullen-434885 (3/28/2012)

---

Thanks, Lowell. That sort of makes sense, but why, then, does not the SELECT ... FOR XML do that escaping in the first place? If that isn't guaranteed...

that is not a valid xml/html entity character;

it has to be escaped as [amp]pound; or & pound;(no space between...hard to describe html on the forum)

http://www.w3schools.com/html/html_entities.asp

the full list of entities to...

this index:

CREATE NONCLUSTERED INDEX other_systems on MyTable(

other_system_id ASC

)

INCLUDE (other_system_key)

would be good for qa query like

SELECT

other_system_id,

other_system_key

FROM MyTable

WHERE other_system_id = 42

it would not benefit a query...

i know you can force a query to use a specific index, would that help?

SELECT ContactID

FROM Person.Contact WITH (INDEX(AK_Contact_rowguid))

i do it the same way, strictly because I'm sending individualized emails; the typical "Dear [Firstname]" emails to each email address i get from multiple rows in a...

try this at the end, instead of the wordier version; i'm using isnull to do the same basic logic as the if statements.

--even this test is not necessary...but left so...

that was a minor syntax issue...the where statemetn was occurring before the join;

change to this:

SELECT

lw.name_code, lw.nc_seq, lw.name_type, lw.age, lw.race, lw.sex,

split.ItemNumber,

Item = CAST(REPLACE(QUOTENAME(split.Item,'"'),'"','') AS integer)

FROM [FAYOSSIRMS].[rms].[dbo].[lwnames]...

where the sample values 'abcd' and 'ijkl' there to show that the clientid is alphanumeric, or are all the id's really numeric?

if they are numeric, you can convert them to...

remove the GO statements.

a GO statement ends the previous batch,and destroys the declared variables as well.

if you remove the GO statmeents, the variables will still be there, and you are...

assuming all the values are numeric, you should explicitly convert it to int inside the sum:

SUM (CONVERT(int,ZL_Count))

alternatively, the better solution is to make sure your destination table has that column...

so...yo want elapsed time converted to years:months:hours:minutes:seconds, and...