No it certainly won't. The result portion...

Something like this MIGHT be what you are looking for although it is not totally clear what you are trying to get.

where year(DOS) =

CASE

WHEN AD.DM_ConfirmationID = 2 --Agreed

and year(isnull(AE.AE_PatientEncounterDate,...

There are lots of syntax AND logic errors. in the short snippet you posted.

For syntax errors check case statement BOL entry.

How about some ddl, sample data and a clear understanding of what you are trying to get for a result?

prikshna67 (3/22/2011)

---

Run the following code.

create table demo(id int primarykey,number nvarchar(max))

go

create trigger dbodemo

on dbo.demo

for insert

as begin

declare @pk Nvarchar(max)

declare @pkey nvarchar(max)

declare @str nvarchar(max)

select @pk = column_name from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'demo'

select...

where columnA is not null or columnB is not null or ....

You have no table in your select...

select count(Differenceyrs)

from MyTable

group by Region,Provider,QtrName

where differenceyrs > 0

SELECT CAST('<Root><Comment year="2009" info="This will ''kill'' my server..." /><AdditionalData bit="1" int="12345" /></Root>' AS xml).value('(/Root/AdditionalData/@bit)[1]', 'bit') AS [PseudoFieldName]

This works just fine.

The problem is you have mixed quotes.

info="This will " kill " my server..."

change it to

info="This will '' kill '' my server..."

and it will be fine.

Square peg meet my friend round hole.

The string you have

'<Root><Comment year="2009" info="This will " kill " my server..." /><AdditionalData bit="1" int="12345" /></Root>'

is not valid xml hence the reason...

If you are doing this from a .net site you can use System.Uri server side before it hits sql to get what you need like this.

string myOutput = new Uri("http://www.sqlservercentral.com/Forums/Topic1080875-1291-1.aspx").Host;

After reading your latest posts I am more confused about what you are trying to do than I was before. I don't understand why you have to convert html to...

I think unless you were able to capture this via trace you are pretty much outta luck. Pretty much impossible to find the date that something that no longer exists...

That is a really strange requirement. So basically you have two copies of every row???

what about something like

select distinct col1, col2, 1 as SortOrder

union

select distinct col1, col2, 2

order by SortOrder,...

Please don't crosspost. The original thread is here