dbalmf (3/6/2014)

---

Hi All,

I have a Stored Proc which populates a table and then uses BCP to output the table into a flat file and lastly ftp the file out to...

You could always use

select cast((35622.15/2) as decimal(15,2)) AS P1, 35622.15 - cast((35622.15/2) as decimal(15,2)) AS P2

Yep, it should be replicated.

Log Shipping takes care of stored procedures, et al. The thing it does not (at least how we use it) do is to keep the jobs and security synchronized.

Welsh Corgi (3/4/2014)

---

How can I calculate and return the previous Date at 18:00 Hours?

Here is a miserable attempt:

DECLARE @RunDate SmallDateTime

DECLARE @CurrentDate SmallDateTime

DECLARE @RunDateWoTime SmallDateTime

SET @CurrentDate = GETDATE()

SET @RunDate = DATEADD(day,-1,@CurrentDate)--...

Dirrect the query to a temp table saving the count then output based on criteria and if you need the table do a query of the temp table.

Glad I could help.

Do you understand what I did?

The value of the trigger is that it will fire from the stored procedure or say SSMS. So creating a stored procedure to populate the audit may not be...

Here is quick and dirty:

Declare @startdate datetime = cast(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)as Date)

Declare @enddate datetime = cast(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())+1, 0)as Date)

SELECT wh_num, QtyReceived, QtyShipped, Adjustments, endBalance

FROM (

Select sum(act_quantity)...

halifaxdal (2/28/2014)

---

Steve Jones - SSC Editor (2/28/2014)

---

Personally, I like the logic clear so if I glance at this in a year, or someone else does, it makes sense. I'd do...

I almost said that but could not remember. :hehe:

This happened to one of our developers.

We tried everything with the intellisense setup with multiple reboots. No luck.

He had to reinstall SSMS to get it to...

If your column name was mcol

SELECT RIGHT('00000' + CAST(mcol AS VARCHAR(10)), 5)...

Look at Eugene Elutin post.

In your code the CROSS JOIN APF is not correct. Remove it and you might get something back.

In Eugene's post he...

It looks like you did not get all the code copied.