table variables are notoriously slow when they get a lot of data in them, because they cannot take advantage of statistics; how many rows are in the table variable @LENNOXBILLING?...

here's the second part of your calcualtion as well, i think:

;with myCTE as (

select row_number() over (order by odometer,event) as comprow,* from

(

select row_number() OVER (PARTITION BY odometer,event order by...

clive thank you for making this so easy....the table definitions and data helps enourmously!

you rock!

here's how i'd "ignore" the double events in a row; i'm using row number and a...

sorry thought this was pure SQL;

i belive in SSIS, you have...

looks like you'll need to add a trace specifically for login events.

it's not part of the default trace, i both tested it and checked the default trace's definition...no login audits...

goodguy, why not build a view that creates the summary that you are looking for?

I avoid at all costs replacing detail data with summary data...besides the possbility of a mistake,...

three part naming conventions is how i often do it:

Select ColumnName from DBname1.dbo.Table

UNION ALL

Select ColumnName from DBname2.dbo.Table

UNION ALL

Select ColumnName from DBname3.dbo.Table

i would go with something simple:

Replace(FieldWithCrLf,CHAR(13) + CHAR(10),'')--vbCrLf

imani_technology (5/18/2010)

---

The source column looks something like this:

XYZ12A01[FOUR ODD SQUARES]LP_EXL_ID

Then I use the following REPLACE function within a Derived Column transformation:

LTRIM(RTRIM(REPLACE([Column 0],"LP_EXL_ID","")))

The destination column is varchar(200). The...

enable remote connections on your SQL 2000; i belive by default express versions set remote access as off, and you have to turn it on:

exec sp_configure 'remote access', 1

reconfigure

some great code suggestions

from a similar thread where someone needed to detect if lower case/upper case character exists:

http://www.sqlservercentral.com/Forums/Topic800271-338-1.aspx

this would check if the string is all UPPER:

DECLARE @string VARCHAR(10)

SET @string =...

the SSMS GUI has a built in report that taps the default trace , filtered by database name; it's a bit easier to use that querying the default trace directly:

yeah i'm thinking TSQL/SQL Server might be the wrong tool for the task...you can do it, but it sounds like you just want a keep alive hitting your site...maybe your...

lets just cover all the bases;; you created a connection , correct? then you can expand the conenction to show the tables, multi select and drag and drop:

you VS should...

i think you jsut need to wrap the Tiutle column with the isnull function:

select RIGHT(' '+CONVERT(VARCHAR,ISNULL(Title,'')),40) AS Title

from ADDRESS;