That's what I am thinking too. There is a password that I have to decypt.

I am on the SQL Server itself. Thank you for your help, I may just have to get RedGate.

yes I am sysadmin and yes I am in on a DAC connection. I double checked my properties and the connection name is admin:SqlServerName (DomainName\MyUserName)

and yes when I run the...

If I run that it says the object is not encrypted or not found.

If I try to modify or alter I get access rights error.

The UserDefinedFunction '[dbo].[FunctionName]' cannot be scripted...

Lowell,

This is where I get lost...

BEGIN TRANSACTION

DECLARE @sql NVARCHAR(MAX)

SET @sql = N'ALTER'+@ObjectNameStmTemplate

EXEC sp_executesql...

John Dempsey (11/10/2009)

---

You can probably get away with just two Data Flow Tasks to generate the file. The first Data Flow Task would generate your Header and Detail records...

Jeff Moden (3/16/2016)

---

lkennedy76 (3/16/2016)

---

After a long hard battle of 'I don't wanna', the temp table is the best option in this scenario.

Thank everyone for all your replies. I am truly...

After a long hard battle of 'I don't wanna', the temp table is the best option in this scenario.

Thank everyone for all your replies. I am truly grateful for this...

I should have put the whole query out here. I am mixing so I need to group. Here is the whole query;

select

p.Date as [Payment to Carrier Date],

t.ConfirmationID as [Confirm Number],

t.SDate...

I put the ISNULL back and got amounts back but I am at the same cross road, the second column (OrgAmount) is not adding up to one amount.

Phil Parkin (3/15/2016)

---

lkennedy76 (3/15/2016)

---

okay guys, I am stuck. I have two columns that I need to add and make one total for a report. there are null values so I...

yb751 (3/15/2016)

---

Jason-299789 (3/15/2016)

---

@yb751

The NULL will only be eradicated if there is a row with a non-Null value, in the same column.

See the code below, when aggregating on Account.

DECLARE @myTable...

I have null values that I need to remove, ISNULL does that, why would I not use it?

Swoozie,

I think it was permissions. This was a few years ago, are you having issues with repl?

That's a nice script however it really is just simple to put the code where is looks to see if it is primary or not. That's all I did on...