jamesheslin123 (5/6/2014)

---

So let's say I have a table Orders with columns: Order# and ReceiptDate. Order#'s may be duplicated (Could have same Order# with different ReceiptDate).

I want to select Order#'s...

vamsye (5/6/2014)

---

SELECT [DEFINITION]

FROM SYS.SQL_MODULES WHERE [OBJECT_ID] = OBJECT_ID(@OBJECTNAME)

I know I can use SP_HELPTEXT to get linebreaks, The reason I want to use this is I can exclude comments section from...

ChrisM@Work (5/6/2014)

---

PIVOT / UNPIVOT haven't been told about the output column limitation of SELECT. Here's how to get 10,001 output columns from a SELECT:

DROP table #Sample

Create table #Sample (Empid int...

vamsye (5/6/2014)

---

TABLE NAME ...

Stefan Krzywicki (5/6/2014)

---

GilaMonster (5/6/2014)

---

A scan under...

pgmoschetti (5/6/2014)

---

You are right, that's a good solution. I've only an additional problem, I must think of: as you said, it is a bulk delete. This bulk delete will be...

KGJ-Dev (5/6/2014)

---

Hi Chris,

Thanks for your reply.

could you please help me on making the below query to fetch top 5000 records. currently it only take 6 records.

SELECT *

FROM

(

select Val,Cat,ROW_NUMBER() over (partition...

pgmoschetti (5/6/2014)

---

I have a trigger that executes AFTER INSERT, UPDATE, DELETE. Is there a way to disable and then reenable only the "AFTER DELETE", letting AFTER INSERT, UPDATE act normally?

Thank...

Nassan (5/6/2014)

---

we are migrating ms access 2007 databases to sql server 2008r2 and we are getting invalid data format error in data columns between access and sql and we...

You could...but that defeats the purpose of relational data. Consider what...

For anybody else wanting to view this query I formatted it.

SELECT DISTINCT FC.CASE_ID

,UPPER(FC.CASE_NUMBER) AS CASE_NUMBER

,UPPER(REPLACE(FC.CASE_SHORT_TITLE, CHAR(13) + CHAR(10), '')) AS CASE_SHORT_TITLE

,FC.CASE_STATUS_DESCR

,FC.CASE_TYP_DESC

,FC.CASE_SUB_TYP_DESC

,UPPER(AJ.DISPLAYNAME) AS JUDGE

,UPPER(PP.DISPLAYNAME) AS PARTY_DISPLAYNAME

,UPPER(AP.ATTORNEY_DISPLAYNAME) AS ATTORNEY_DISPLAYNAME

,CASE

WHEN RC_PARENT.PARENT_CASE_ID IS...

What exactly is the question? It seems like you want a list of filtering predicates? The sql you posted has multiple select statements....

aajavaherian (5/5/2014)

---

if i was describing lets say classes and students where each student can be in more than one class and each class can have multiple students. Or how about...

Phillip.Putzback (5/5/2014)

---

Do you use a naming convention for lookup tables so report writers have a way of noticing them before they go create their own? Their own schema or ...

Glad that worked for you!!

I don't know of any other way to preform what I need to do other...