SELECT     sysobjects.name AS ObjectName, syscomments.text AS DDL

FROM         syscomments INNER JOIN

                      sysobjects ON syscomments.id = sysobjects.id

WHERE     (sysobjects.xtype IN ('U', 'V'))

Filter accordingly.

To find out which PolicyNumbers are duplicated,

Select T.PolicyNumber, TempCount, GECount from

(Select PolicyNumber, COUNT(PolicyNumber) as TempCount

from #temp group by PolicyNumber ) T

join

(Select PolicyNumber, COUNT(PolicyNumber) as GECount

from GE_ReservesFile group by PolicyNumber) G

on...

First, you need to know the file position of your 11282006 differential backup from your 'E:\MSSQL\BACKUP\db1_backup_11012006' backup file. Use

RESTORE HEADERONLY from disk = 'E:\MSSQL\BACKUP\db1_backup_11012006'

Take nore of the POSITION number of...

Is there a unique (no duplicate) column common to both tables? Is PolicyNumber Unique?

Try this first on both tables..

Select COUNT(distinct PolicyNumber) from ...

Compare the results. If You still get 123...

Create Full Text Indexes on your catalog and use the FREETEXT predicate in your select statements. You can also look into FREETEXTTABLE for returning resultsets by rank.

To give way for version 10.0. Hahaha!

I believe he is talking about Crystal Reports as he mentioned in one of his other posts. This is the classic header detail report.

If you normally load the data (bulk), the index statistics would normally be off. You can use ...

select * from tbl_ORD_CUST (Index(idx_order_id)) where c_order_id = @x

Source : Select dept_id, dep_name, member_name from table1

Grouping : dept_id

Grouping Header : Dep_name

Details Section : member_name

Hahaha! I really enjoy reading the thread when it's posted by Best!

Use a custom delimeter.

If you read Ninja's links,

http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/arrays-in-sql.html

you'd find out that your syntax should be..

EXEC('

SELECT [' + @Weight + '] FROM ShippingRates WITH (NOLOCK) WHERE ShipMethod=''' + @theShipMethod +...

Use the return statement in your procedure to return an Integer value.

i.e.

Create proc ReturnTest

as

declare @E int

 select 1/0

 set @E = @@error

If @E <> 0

begin

 print 'Error encountered'

 return @E

end

Picture it this way...

Suppose I only want 10 random numbers of any number from 1 to 10. Your solution will give me the numbers 1 to 10 in a random...

Please note that 'Last Run Date' contains both the date and the time the job was run. Running MAX on it would consider both the date and time.