I should have mentioned that I have the Algorithm_Literals

in two schemas 'cyp' and 'ctl'.

I regret the omission.:blush:

The problem is that I have primary keys for tables with the same...

manub22 (3/14/2012)

---

I also faced lot of issues while setting up database mail first time. But finally managed to configure it.

So I've put all of those steps at one place, check...

capn.hector (3/14/2012)

---

This should be what you are looking for. First one checks if the object exists in the sys.objects "Table" and then drops it if true, the second checks...

Thanks!

I enabled Database Mail and used the Wizard to configure Database Mail on another instance of the machine I'm have trouble with.

I can send SMTP MAil through telnet.

Something that I...

Thanks for all of the help. 😎

Thanks for all of the help.

I appreciate it very much.

A problem that I'm running into on this is that it creates a second colum once it encounters the END in the CASE Statement.

I need one column of output.

CONVERT(CHAR(4), YEAR(EffectiveDate))+

CASE...

I agree that I did not state my question very well.

The format of the column the data was being inserted to was the format that I specified and no it...

That was dumb, thanks.

Thanks for the code.

When I tried to add the day for another Column I get a syntax error.

CONVERT(CHAR(4), YEAR(EffectiveDate))+

CASE

WHEN LEN(MONTH(EffectiveDate)) = 1

THEN '0'+CONVERT(CHAR(1),MONTH(EffectiveDate))

ELSE CONVERT(CHAR(2),MONTH(EffectiveDate))

CASE

WHEN LEN(DAY(EffectiveDate)) = 1

THEN '0'+CONVERT(CHAR(1),DAY(EffectiveDate))

ELSE...

--select cast(datepart(month,getdate()) as varchar(2)) + cast(datepart(day,getdate()) as varchar(2)) + cast(datepart(year,getdate()) as varchar(4))

I'm using the DatePart Function but I need to include a CAST.

Pam Brisjar (3/12/2012)

---

See my response to your other post (the one in the Data Warehouse group). I posted an example of doing a join between openquery and a SQL Server...