High Tops

i dont know which is worse, the fact that he is consistently bad...

still comparing the entire table 4...

roryp 96873 (4/19/2012)

---

There was only about 6,000 in the customer table and 7 patterns we were looking for so it really wasn't an issue. This just got my curiosity...

Steve Cullen (4/19/2012)

---

You can search the definition column in the sys.all_sql_modules view with something similar to this:

SELECT OBJECT_NAME(object_id) FROM sys.all_sql_modules

WHERE definition LIKE '%Database_A%'

This won't limit the results to database references...

well there are to options, opening every SP and looking through it or something like the following may work:

SELECT SPECIFIC_NAME FROM DBa.INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%DBb%'

that will select the names...

itskanchanhere (4/19/2012)

---

I used Teradata SQL Assistant client to execute some procedures in SQL Server. Since these had Print statements they failed...Sps without print were successfully executed.. I faced problem only...

ReginaR1975 (4/18/2012)

---

CREATE TABLE [dbo].[Orders](

[OrderNo] [smallint] NULL,

[Price] [smallmoney] NULL,

[Descr] [varchar](50) NULL

) ON [PRIMARY]

GO

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(001,30,1)

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(001,30,1)

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(001,40,1)

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(002,20,1)

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(002,30,1)

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(002,50,1)

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(002,42,1)

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(003,40,1)

INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(003,48,1)

INSERT...

ReginaR1975 (4/18/2012)

---

I have a table that has an OrderNo, Price, and Descr field. The OrderNo is like an acct number. There are multiple records with the same OrderNo. I need...

you can only do some of those things with tsql and db mail but if you add in a web programming component you can do them all. i would...

can you post your create table statements (DDL), sample data (Hard coded inserts) and your sample output (How you want it to look). if you need some help assembling...

Lynn Pettis (4/18/2012)

---

I am going to...

burn phone

The Dixie Flatline (4/18/2012)

---

SQLRNNR (4/18/2012)

---

Lynn Pettis (4/18/2012)

---

SQLRNNR (4/18/2012)

---

Lynn Pettis (4/18/2012)

---

The Dixie Flatline (4/18/2012)

---

Lynn,

My wife is a special education teacher with a lot of training and experience in behavior modification....

diapers