You're welcome. 😀

SQLTestUser (9/9/2013)

---

Convert(datetime, DATEDIFF(day, 0, GETDATE())) worked

IF EXISTS(

select 1 from Xlog where LogDATE >= cast(getDate() as date) -- should this be datetime if i have Sql server...

John.Hagen (9/9/2013)

---

Hi Everyone

I am creating a view which involved concatenation of 2 int columns.

The data in the columns look like

Column 1 ...

So just to reiterate, you have a system but you can't share the design. You need to build a hierarchy but you can't share or create any sample data. Even...

What you are seeing can drive you nuts if you have to go back and forth in compatibility. Datatypes in 2008 are available even in 2005 mode (like the table...

There is nowhere near enough information for anybody to be able to tell you "how to build it". Is this a brand new thing and you are trying to design...

I glanced at your post on github. There really isn't enough information to provide much in the way of assistance but there are a couple of pieces of your query...

pieter 46001 (9/9/2013)

---

Tis should at least send me a mail regardless of if statement.

Use ABCTRAINING

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

alter TRIGGER TAXPERCENT

ON [dbo].[AP101_VOUCHER_DISTR] AFTER insert AS

declare...

Can you post the entire contents of your trigger?

I suspect that the intention was to demonstrate that ISNULL will pick up the first datatype in the list which in this case is char(1). Therefore the value of returned...

John.Hagen (9/6/2013)

---

Ok, adding the deleted in front of that column makes it work. I am getting the records into the tables as needed. It is also entering 10 rows of...

Without more information than that it is pretty difficult to provide much of a detailed answer...and this question requires a detailed answer.

Please take a few minutes and the read the...

You have met at an extreme disadvantage here. I have no idea what your table looks like. Those are...

Sean Lange (9/6/2013)

---

John.Hagen (9/6/2013)

---

Hi Everyone

I have a merge statement which ends with the following

WHEN NOT MATCHED BY SOURCE THEN

DELETE;

Now I need to record the deleted records in a...

John.Hagen (9/6/2013)

---

Hi Everyone

I have a merge statement which ends with the following

WHEN NOT MATCHED BY SOURCE THEN

DELETE;

Now I need to record the deleted records in a table ...