LOL had same issue (~100M) .... BUT do you have a proper way to say WHICH of those records are the VALID ones? It might not be the MAX(ID) take...

Depending on how much data you need to be available for "every day work" you might wanna consider "archiving" some of data since you must have a lot of data...

ali.m.habib (7/28/2009)

---

select [LINKEDSERVER1].DB.dbo.T_DATE('D')

this run the function...

Mike Levan (12/18/2007)

---

when i tried doing this

select startDate from tblemp where startDate between '1/1/2006' and '12/31/2006'

i dont get that date range, why?

startdate is varchar(100), I Cant change that in the...

you should read some articles about Manipulating And Using DateTime Data...

problem is when you pass param you pass a string and the SQL engine does the conversion for you. If you want to work all the...

If you really want to use the format with parameters than you CAN T put your command into a variable and have more than 4k chras since for SP_EXECUTESQL complex...

DECLARE @beginDate varchar(30)

DECLARE @EndDate varchar(30)

DECLARE @emp varchar(4)

DECLARE @dbName sysname

SET DATEFORMAT MDY

SET NOCOUNT ON

SET QUOTED_IDENTIFIER OFF

SET @beginDate = '12/5/2007'

SET @endDate = '12/15/2007'

SET @Emp = 'abcd'

SET @dbName= 'BO2'

DECLARE @SQLCmd nvarchar(4000)

SET @SQLCmd =...

You better post the error that your getting (doubt that your string is longer than 4k nchars)

DECLARE @beginDate datetime

DECLARE @EndDate datetime

DECLARE @emp varchar(4)

DECLARE @dbName sysname

SET DATEFORMAT MDY

SET NOCOUNT ON

SET @BeginDate...

binaries will be on both nodes data files and log files will be on the shared drive

check SELECT TOP n .... too might be enaugh for what you need

try

SET @BeginDate =...

SET NOCOUNT ON

DECLARE @T Table(id integer,date datetime,bbb varchar(15),mob varchar(15))

DECLARE @CustomerID int

SET @CustomerID=1

INSERT INTO @T SELECT 1,'20071231',null,null

INSERT INTO @T SELECT 1,'20061023',null,null

INSERT INTO @T SELECT 1,'20051114',null,'0774444444'

SELECT TOP 1 *,COALESCE(bbb,mob) Result FROM @T...

One question some machines that need not be considered are in the tmp table. They are not in the final results. So the end results are fine. Will it improve...

--I think the whole design is flawed...

--nothing tells me when the machine is working K with no complains. In your sample data WHAT will tell me that there were no...