Be sure to check out the change I made to the code I posted above. The join to sys.objects isn't even needed.

komal145 (5/18/2012)

---

Sorry my criteria changed!!!

Entry_id Eventy_type_id( not unquie) Event_value( not unique)Event_datetimeusername

16pending05/17/2012 23:30ABC

16Pending letter05/17/2012 24:31DCBSA

11newinforecieevd05/17/2012 24:32Adsadhsa

18EA05/17/2012 24:33Asafcsd

16pending05/17/2012 24:33Asdsac

TABLE A scenario 1

TABLE A scenario 2

Entry_id Eventy_type_id( not unquie) Event_value( not unique)Event_datetimeusername

21carrierexception05/17/2012...

You are really doing a lot of extra work that you don't need to be doing.

SELECT

s.name AS schemaName,

t.name AS TableName,

...

What is your expected output?

Okay. I was noticing some things about the original query. The first query with the LEFT JOINS; the joins between...

sporoy (5/18/2012)

---

Hi, we have log shipping between one primary and two secondary SQL Server 2008 R2 servers,

in the secondary instances' error log there are (after each restore) although secondaries...

Welsh Corgi (5/18/2012)

---

Lynn Pettis (5/18/2012)

---

Welsh Corgi (5/18/2012)

---

I wrote some Stored Procedures using CTE but not that much.

How could I convert the code below to CTE?

SELECT s.Name AS SchemaName ,

...

Have you don this: Run DBCC CHECKTABLE to verify consistency.

What were the results?

First, you can't rename an instance. If you want to use the default instance, you have to install another instance. Then you have all the issues of moving...

Welsh Corgi (5/18/2012)

---

I wrote some Stored Procedures using CTE but not that much.

How could I convert the code below to CTE?

SELECT s.Name AS SchemaName ,

...

halifaxdal (5/18/2012)

---

Lynn Pettis (5/17/2012)

---

Perhaps this:

set @sql = 'select count(1), sa from deviationbycategoryandsa where [' + @Category + '] = 1 and sa = ' + '''' + @sa + ''''...

With as little information provided, not sure. When and how was it encrypted? What tool was used to encrypt the file?

Do you have the SQL Browser service running? If no, then dynamic ports are going to be an issue. The SQL Browser service listens on port 1434 and...

Slight change, needed to add a second column to the table variable. You may need to adjust the...

Jeff Moden (5/17/2012)

---

Thomas Stringer (5/16/2012)

---

I tried searching for some explanation before posting, but I found nothing close to what I'd like to know. Ask SSC seems to be a...