my first guess is that the table is a HEAP.

if the table is a HEAP (meaning it does not have a clustered index) when individual rows are deleted from the...

the function found at the end of this article is very highly rated among my peers here on SSC:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

select * from table

where numberColumn in

(SELECT Item FROM dbo.DelimitedSplit8K(@x,',')

it looks like not in Parallel Data Warehouse 2008, no sequences, sorry.

they are appear to available in Parallel Data Warehouse2012

Sequences were introduced in SQL server 2012, and each PDW...

this can be a little misleading, especially when it comes ot using sp_helpprotect.

that procedure lists the objects that the public role,(in this specific example) can see,

if you look at the...

i'm lost in the terminology here: what's "the internal email field"?

my first guess would be...

http://www.red-gate.com/SupportCenter/content/SQL_Compare/knowledgebase/SC_Permissions_Required

VIEW DEFINITION and VIEW SERVER STATE are what's recommended, it looks like; otherwise you get data filtered based on what schema/objects you CAN see.

it took me a while just to massage your sample data into a usable format.

i ran out of gas just getting this data consumable, maybe someone else can run teh...

the zero-changes to the application thing is the tough part;

i know it's possible to use certificates to allow a view to decrypt data, and then i assume you could...

Luis Cazares (12/10/2013)

---

Lowell (12/10/2013)

---

if you group by both EMPID and PrimaryRater, you don't get the "end Date" you were looking for according to your sample data, so im not sure...

basically, you assign the results to a DataSet; since a DataSet contains a collection of DataTable,s you can then iterate through each datatable, or assign, say a grid's datasource to...

well, whenever you use any of the aggregate functions(MIN,MAX,COUNT)

you have to have one or more GROUP BY column(s).

IF you group by just EMPID, you can only end up getting...

typically what i've done in the past is to limit access to the table to require stored procedures.

the stored procedures get signed, so they can be called by other...

asranantha (12/10/2013)

---

its not given exacetely results and doj format data 0 not added .

2/23/211...

based on your response, i guess you cannot consider fixing the datatype.

here's an example based on your sample data;

the column BackToFormattedDate is what you are asking for

;WITH MyCTE([id],[name],[doj])

AS

(

SELECT '1','abc','3/1/2011'...

wouldn't switching to a union work, i think? i think the AND would short circuit any table scan right away, and will perform a bit better.

SELECT

*

FROM ...