Since it's an error converting from date to datetime, have you tried casting your columns as date instead of datetime?

Sean Lange (12/7/2011)

---

toddasd (12/7/2011)

---

ramanamreddy (12/7/2011)

---

Hello,

I have a column patID with some values( with some condition 1), patID with some columns(with some condition 2).How can I merge all the values into...

ramanamreddy (12/7/2011)

---

Hello,

I have a column patID with some values( with some condition 1), patID with some columns(with some condition 2).How can I merge all the values into a single patID...

Append this before your query:

select 'Name|Address_line_1|Address_line_2|City|State|Zip|Territory_Code|LDC_Account_Num|Account|POWERFLOW|POWERDROP|Unbilled|NotDue'

union all

Edit: Lowell got there first.

Oh, it's urgent. Well then, let me start right away. :Whistling:

Really, what have you tried so far? Maybe if we can see an effort at a query we can piece...

Looks like you just need to double the quotes on the trigger code except for where you use the variable. Try this:

alter PROC spReplaceAuditTrigger( @PassedTableName as NVarchar(255) ) AS

BEGIN

DECLARE @ActualTableName...

As far as I can tell, the OP is not trying to alter a table within a proc. OP has run the alter table and is now trying to alter...

Faye Fouladi (12/6/2011)

---

I have something like this in the stored proc:

...

The data for updating EpisodePackage table and updating those new fields is coming from this table variable. I also added...

Faye Fouladi (12/6/2011)

---

The Alter Table statement succedded well.

When I expand the table columns, I already see the added columns. Is there anything ellse I need to do for the stored...

jeff.coulson (11/28/2011)

---

In Access when building functions with a series of DoEvents, running append and other action queries, I utilize DoEvents between actions to assure that one event finishes before the...

So if you have three new positions coming in, E=2, K=3, and M=6, what happens to the Names (B,C,F) that were in those positions? At first I thought they were...

nfpacct (11/9/2011)

---

Sean,

you are correct some of the tables have a multiple records.

Does the query syntax correct for joining multiple tables.

select a.dtimesheetid,b.dtimesheetid,c.dtimesheetid, d.dtimesheetid,e.dtimesheetid,f.dtimesheetid

from tblPRTS ...

You are welcome. It's is one of those deals -- having an open transaction and nothing else works -- that causes so much trouble, that you never forget that type...

You're getting a lock error on the select because you are not rolling back the transaction opened earlier. But there is no need to use a transaction when there is...

bubs (11/2/2011)

---

The problem is that if the MasterReview has a metric added or deleted, I want to reflect the changes in the Peer Review table when the user clicks the...