i believe the alpha symbol would require an NCHAR column, and nnot a char; the alpha is in the extended ascii character set.

well an open transaction is not a bad thing.

a running process could take a lot of time to finish; so in general, you do nothing at all when there is...

i believe binary must be converted to nvarchar, right? so the conversion to varchar is failing?

select distinct

CONVERT(NVARCHAR(100), h.HRCHY_ID, 1) fConvert,

CAST(h.HRCHY_ID AS NVARCHAR(100)) fCast

from...

you posted in a SQL 2000 forum...are you stuck with SQL 2000, or are you in SQL 2005 or above?

if you Are in 2005 or above, what is your...

take a look at this article: by selecting columns aliases as html tag names like TD and getting the data as xml, this technique seems to work really well for...

with 2005 and above, this got a lot easier; there are DMV's that have the connecting IP address now;

here's an example:

--the auditing snippet below works fine in a...

well, here's the data in consumable format...i'll try to look again at what you are asking, but i used up all my brain power converting your post to something usable....

with...

for reference though, the format is not too difficult: it's INTO #Tablename just before the first from

SELECT

ColumnList

INTO #TMP

FROM ATable

JOIN OtherTables ON ...

UNION

SELECT columnList

FromBTable

Sossoliso (3/14/2011)

---

I once Supported an Finance/Accounts System which used Triggers to alert agents when a sale had been made. One day the trigger to could send out any mails... The...

yeah, i think that's the issue; the value passed, when it comes in as a string, is not guaranteed to be in the format you are expecting:

to_date(:StartDate,'MM/DD/YYYY hh24:mi:ss')

if StartDate...

I sat thru a Webinar on SQL server ; the presenter was raving about how Twitter was the best thing to learn about SQL, so easy to ask a question,...

if you use parameters instead of constructing the strings, that issue would go away, but you can doe the fix with a little bit of REPLACE magic, i think.

you need...

spin (3/14/2011)

---

hi,

just got my head around all of the responses.

so...It turns out i was running trigger to email on our test system which doesn't have the correct permissions to truncate...

i believe if the login CREATED a view, by default, it is it's owner, and thus can alter or drop the objects it creates.

if you want the login to be...

damn i knew this and didn't remember it; I'll blame it on caffiene deficiency.

you'll want to stop and start the instance in single user mode

sqlservr.exe -m -s SQLEXPRESS

http://msdn.microsoft.com/en-us/library/ms180965.aspx