wouldn't this query return all duplicates:

SELECT Acct_Num_CH  from TrxDetailCard

WHERE (Date_DT >= cast( convert( char(10), getdate(), 121 ) as datetime )) 

group by Acct_Num_CH

having count(Acct_Num_CH) >1

with that, i think...

in my case, I have a search function that does the top 50 similar to what you were asking for///however when i need the next 50, i make sure the...

most likely true now that i re-read the question; like almost of your posts, I try to give a solid working answer on a question, when it is worthy...but i...

i have this procedure which is designed to handle FTP to a site, with some minimal validation as to whether it sent or not...hope this helps: you'd want to expand...

Assuming Resum is the same as BookNum that appears in most of the tables:

SELECT BookNum,X.PRICE + Y.PRICE + Z.PRICE AS PRICE

FROM HotelSegment

LEFT OUTER JOIN (SELECT BookNum ,SUM(Price) AS PRICE...

if the contactEnquiries table is small, the optimizer will always do a table scan regardless, and ignore the index;That means if the table is less than 8MB in size, it will always...

here is an example:

results:

the sp_addextendedproperty  Mohammed mentioned is the Description field you are talking about.

From enterprise manager, no you cannot add columns tot eh design view of the tables....but you can select it...

could this be realted to the parameter sniffing issue that sometimes occurs...that is exactly the symptom...works fine with static value, very slow with variable... search for parameter sniffing  and see...

as i remember, the trick is to select the TOP N  of a sub select:

select TOP 12 empid,empname from emp order by empid  contains all teh records you want, so...

here's an example; this is getting everything out of a table in a loop, and should give you the framework you are looking for:

Private Function ExportBlobs()

    Dim ConnObj...

yes, and that's exactly what we do in our shop...we make multiple ERD's, each related to following a specific flow of data...one for product and it's attributes, another for orders...

ok poking around the registry, i found this key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment\NUMBER_OF_PROCESSORS

now to read that from each machine on the network , i would simply create a program to read that key...

that registry entry i found is not accurate, you are right...my home machine, which is just a single processor AMD64 has a registry entry of EIGHT processors for that value...I'll...

there may be other ways, but i found this snippet on sqlteam:

-- Get the number of processors that the server has

declare @NumProcs int

EXEC master..xp_regread

  @rootkey = 'HKEY_LOCAL_MACHINE',

  @key...