Here's a screen shot...

Thanks for the reply Ramesh.

I'm having a hard time getting this to work. Here's what I'm attempting to do.

I've added the "User::DateTimeVar" variable to the package. Then I created a...

Jeff...Thank you so much! This works great.

BTW...I just started reading your post about the "Tally" table.

I am now officially on a quest to eliminate my cursors and loops. 🙂

Thanks for the reply Lynn!

I'm trying to update the [TotalMonthlyBill] with the [Minimum] if the [Minimum] [Minimum]...I only want the results of (LastMonthsTotal * Price). Make sense?

If you...

I've almost got it figured out. Here's what I came up with. Please note recordid 107...that's where I'm just not getting it.

DECLARE @recordid varchar(50), @sql2 varchar(1000)

DECLARE crs CURSOR FOR

SELECT...

Thanks for the reply Gosta. Getting the proc to run is not the problem. Getting the proc to run under a SQL account that has very limited access is where...

I think I figured out what the problem is, but I still don't know how to fix it.

The error happens when trying to access a postgres server from within our...

Jack Corbett (4/14/2009)

---

Are the credentials used by SSRS the same as the ones you are using in SSMS?

Can you use OpenQuery in SSMS? The first error looks like Ad...

Yup...I stumbled on that site today in my search for a solution. That's where I got the idea for the original function.

Good news. I figured it out. Here's what I...

Lowell, Thanks for the reply.

Let me clarify what I'm trying to do. I have a column that has a Timestamp (epoch unix timestamp) datatype. I need to create a function...

I've been holding out on updating to sp3. What are the caveats to watch out for? My current setup is mirroring to stand by SQL 2005 server and replication to...

I tried setting the SQL server max memory to 2.4GB and still used over 2.6GB. Everything was looking great, zero blocked processes and the CPU average was down from it's...

How about dynamically creating that same date format -2 days?

I found an unlikely culprit...the Max Worker Threads. They were set to 2048 and as soon as put in the default of 0 and restarted SQL...the memory climbed to the...

Sorry for the vague description of the issue. The SQL Server in question is using around 1.8GB of memory. The other two SQL Servers that have the /3GB switch enabled...