Sean Lange (7/17/2012)

---

There is no easy or fast way to do this. You are asking to search all columns in all tables. This is horribly slow. I wrote the following...

opc.three (7/2/2012)

---

Charmer (7/2/2012)

---

I cleared the previous issue..but again i have come across with the folloeing where i don't have any idea of it...

[WMI Event Watcher Task] Error: Watching for the...

I cleared the previous issue..but again i have come across with the folloeing where i don't have any idea of it...

[WMI Event Watcher Task] Error: Watching for the Wql query...

I tried this...

but unfortunately , i get a...

Yes, Lynn....i did exactly like you said...

Thank you very much Lynn....You have been a great asset to this SQL community...we are proud of it..:-)

Gullimeel (6/29/2012)

---

Try this as well.. This is based on Lynn's DML

select

td.ID,

td.Unit,

td.SysCC

from

#TestData td

...

Lynn Pettis (6/29/2012)

---

Now, did you take the code that I posted based on David's post to see if that did what you wanted? If so, did it based on...

I am sorry Lynn. yes,it will work for sure..i tested it...

i have attached the screen shot of the result...

for example

in caseNo 120005, we got rows having SysCC column as...

INSERT [dbo].[CADInc] ([CADNo], [RptDttm], [District], [IncidentID], [ProductID]) VALUES (2012000001, CAST(0x00009FCC00FFD238 AS DateTime), NULL, 100040002662851, 2)

GO

INSERT [dbo].[CADInc] ([CADNo], [RptDttm], [District], [IncidentID], [ProductID]) VALUES (2012000001, CAST(0x00009FCC00FFD238 AS DateTime), NULL, 100040002662851, 2)

GO

INSERT [dbo].[CADInc]...

The above is the SQL query that i use in here......

For each caseno it must show the all the records excpet SysCC column has a value 9...for a CaseNo, if...

Sorry Friends, i was not able to post my DDL and DML last night....I am sorry Lynn.....

USE [MyDB]

GO

/****** Object: Table [dbo].[CADInc] Script Date: 6/29/2012 2:04:16 PM...

Welsh Corgi (6/26/2012)

---

I was wondering if you informed the client how much it was going to cost them to upgrade to the Enterprise Edition.

I just got approval to upgrade to...

I conveyed the problem to my higher authorities and clients. And they told that they will try upgrading to enterprise edition. So once if they upgraded it, i believe that...

SJanki (6/25/2012)

---

Hello, The problem was...

yes of course Lynn, I totally appreciate it..because feed back is not just a...