Hi Todd & Gail

I'm looking into this now. Index rebuilds are 3am. It's an odd system, most columns are covered, and one of our accounts tables has 30m rows. Will...

This calculates daily totals for the last whole week, monday through saturday:

DROP TABLE #ContactRoutingDetail

GO

CREATE TABLE #ContactRoutingDetail (queueTime INT, StartDateTime DATETIME)

GO

INSERT INTO #ContactRoutingDetail (queueTime, StartDateTime)

SELECT 10, '2008-01-31 11:23:32.937' UNION ALL --...

Robert

I grew up in the Highlands too and if I could find work up there which paid half as well as down here in London, I'd be back up there...

Importing data into a live table isn't generally good practice unless it's a repetitive process and problems have been sorted on previous imports.

Instead, import into a staging table, which...

ok.

Looks to me like the 2nd/3rd and 4th filter blocks are exactly the same - is this correct?

It helps to see all of the code - I can see @AND...

Art

You need to assign a value to the varchar variable @AND. Until you do, the value is NULL. Then read the following section in BOL: [SET CONCAT_NULL_YIELDS_NULL].

You also need to...

Try this:

[font="Courier New"]SELECT em.statecode, COUNT(em.statecode) AS ct

FROM employer em

LEFT JOIN interview iv

ON iv.companyname = em.companyname

AND iv.division = em.division

WHERE iv.companyname IS NULL

GROUP BY em.statecode

ORDER BY em.statecode[/font]

It...

Nick

Not really. From BOL:

Remarks

This setting is used only in the interpretation of character strings as they are converted to date values. It has no effect on the display of...

Try this:

[font="Courier New"]-- Make a new file from the template

DECLARE @CMD VARCHAR (1000), @Dir VARCHAR(50), @Today VARCHAR(10), @Spreadsheet VARCHAR(100), @return_status int

IF OBJECT_ID('tempdb..#Output') IS NOT NULL

DROP TABLE #Output

CREATE TABLE #Output (CopyResult...

There's a nice tutorial for using sp_executesql with output parameters here[/url].

Cheers

ChrisM

Having posted the above, I'd like to point out that I really really really hate correlated subqueries because they are more often than not an indication that the author of...

The OP states "When a problem happens associated with one of these tags, the alarm field changes from a 0 to a 1. When the problem is corrected, the machine...

Well done Loner! Good luck on the day - and let us know how you get on!

Haha I know what you mean! Most of the problems are now solved by using subreports,...

Hi Damon

Here's the current scenario: "Summary Profit & Loss - Consolidated" is a linked report; the main report picks up CompanyGroup and Fiscal Year from static lists. It also picks...