You need to provide DDL and sample data...

Would this work?

DECLARE @DB VARCHAR(100) = 'MyDB'

SELECT *

FROM @DB.sys.check_constraints

If not, why would it work in dynamic SQL?

Obviously, you've found an approach that does work though.

It can be done with a cross-schema trigger, but that is...

Change the COLLATE for one of the columns.

Try this:

create table my_table(id1 nvarchar(10), id2 varchar(10))

SELECT TABLE_NAME, COLUMN_NAME,CHARACTER_SET_NAME, COLLATION_NAME

FROM information_schema.columns

WHERE TABLE_NAME = 'my_table'

insert into my_table VALUES ('-1','-1');

insert into my_table VALUES ('1','1');

SELECT MAX(id1...

Jeff Moden (11/21/2012)

---

dwain.c (11/21/2012)

---

Jeff Moden (11/21/2012)

---

Oh man.... I can't remember if it was Lowell or Magoo or ??? but we've been through this problem before (couple of years ago?) and...

Aw shucks, Master. T'weren't nuthin'!:blush:

Jeff Moden (11/21/2012)

---

Oh man.... I can't remember if it was Lowell or Magoo or ??? but we've been through this problem before (couple of years ago?) and somebody posted some...

I didn't...

Call me weird or whatever but I don't think this is particularly messy at all using a simple cross tab query.

First, Michael's set up data with a couple of additional...

Try it like this:

DECLARE @Valid_PolicyId INT

DECLARE @PolicyIdInput VARCHAR(100) = '222222222222222222222'

DECLARE @PolicyID INT

DECLARE @Err INT = 0

--check if PolicyId inputed--

IF ISNULL(@PolicyIdInput, '') = ''

BEGIN

RAISERROR ('Policy...

Sure! Anything is possible in the SQLverse. Assuming of course that when you say "consecutive" the Date column controls this. Try the following:

CREATE TABLE #Test(

[Date]...

How about something like this?

;WITH Amounts AS (

SELECT CurrentLine, Amount, RowNumber, [Difference]=CAST(0 AS FLOAT)

,[Rows Subtracted]=CAST('N/A' AS VARCHAR(13))

...

Eugene Elutin...

Eugene,

If you're going to cast aspersions on my code with garbage data, I think you should first look to your own. Try this:

select

SUBSTRING(email, CHARINDEX('.', email)+1,CHARINDEX('@', email)-CHARINDEX('.', email)-1)

...

Eugene Elutin (11/21/2012)

---

PRINT 'Dwain.C COLLATE + CROSS APPLY'

SET STATISTICS TIME ON

SELECT @Email=RIGHT(

STUFF(a.email

...

SELECT email...