jbalbo (10/19/2012)

---

does anyone know what I have setup wrong here?

INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)

SELECT DISTINCT TAG_NAME = 'CUST_ALLFOOD', TAG_DATA =(M.GENERIC_NAME + CONVERT(VARCHAR(MAX),ca.Notes)

INNER JOIN CLIENT_ALLERGY CA (NOLOCK) ON C.OID_LINK =...

There is nowhere near enough information to be able to help here. Please see the first link in my signature about best practices when posting questions.

Nice job posting ddl and sample data. Unfortunately it is very unclear what you are trying to do. Can you explain how you came up with the values that you...

briancampbellmcad (10/19/2012)

---

Did I get the data you needed or other information for the testing? Just can't seem to find what could be wrong with this trigger...

CREATE TRIGGER [dbo].[trDecrementBulkPurchases]

ON [dbo].[tblTransactions]

AFTER INSERT

AS

BEGIN

UPDATE...

gowri.4ever (10/18/2012)

---

with the script you provided I need to check for every table in the database..and there are more than 100 tables....it will be a very complicated and time taking...could...

So run the query I posted. It will show you that information and...

gowri.4ever (10/18/2012)

---

hi,

I cannot use the redgate and all...what i was asked to do is to copy all the tables in a database into a temp table and then do the...

gowri.4ever (10/18/2012)

---

Hello Everyone,

I need to check if all the tables in a database are same(have same columns and datatypes) to all the tables in another database. and these two databases...

Your trigger is intended to update tblBulkPurchases. I don't have any data in that table. I can' test your trigger because the update has no rows to update.

The best is to post an insert...

pwalter83 (10/18/2012)

---

Sorry Sean,...

ChrisM@home (10/18/2012)

---

Brandie Tarvin (10/17/2012)

---

It's a disgrace, a disgrace I say. Why do you want to know what I know I know? It's a disgrace, a disgrace I say.

Young fella, do...

Thank you for the ddl and sample data. However your requirement mentions a column TEU. This is not present on any of the tables you provided.

Gail is totally right. There is no need for a while loop here at all. All you are doing is copying a table to another table.

insert #tblTest

select cn, dn

from #tblGroups

Not...

Did you read Gail's post?

Pay close attention to the second part.

or,...