Looking at your SQL it appears you are tring to find BP_BusinessNature cols with a value 1 in them where the field holds a comma separated list of values -...

Cindy is right - but should probably also have said UNION ALL is much quicker as SQL does not have to search for duplicates - so if you don't need...

You probably want to change def of proc to

CREATE PROCEDURE missing_iconnt_data(@p_sitecode INTEGER = Null,@p_fromsalesdate DATETIME,@p_tosalesdate DATETIME)

This means that if @p_sitecode is not specified it will take value Null

Your WHERE then...

Beware of changing the database collation - SQL 200 very helpfully does NOT change the collation of individual columns when you do this - they all remain as the old...

You don't say what front end you are using that gives this problem - if it is Query Analyzer just use

Tools/Options and adjust the Maximum Characters Per Column setting

If it...

They are also very useful if you are trying to capture changes to some particular data fields to apss through to other databases to allow data links between databases for...

I assume your file is always abcYYYY_MM_DD.txt - in which case use an ActiveX script as first step in the DTS job to make up the file name (you can...

It probably serves you right as it is not a great idea to do something as slow as a cross server insert from something that really needs quick and tidy...

Of course if the data structure was better normalised it would be easier - i.e. the ScheduleTime's should be in a linked table if there is more than one possible...

You might want to check if you have Jey Service Pack 8 for Win 2003 installed

It definitely was possible to restore just a table in SQL 6.5 - it was a great choice in some circumstances esp when DB was large so retoring whole DB...

I have seen the "no databases visible in Enterprise manager" issue before - I have a notebook computer that I sometime run database on with the databases located on a...

If you are talking about pulling the network cable out of one switch and plugging it into another then in my experience you can get away with doing this (I...

ADO streams are the way to go - below is VB6 code to do this

Dim cn As New ADODB.Connection

Dim cmd As New...

SELECT * from t Where year(t.testdate)=(year(getdate())-1) and month(t.testdate)=month(getdate())