if you change your collation as seen below, you should see the results you expect:

CREATE TABLE [t1] (

 [txt] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [nbr] [tinyint] NULL

) ON [PRIMARY]

GO

when you...

select dateadd(mi,1439,'05/07/2007') returns 2007-05-07 23:59:00.000

select dateadd(s,86399,'05/07/2007') returns 2007-05-07 23:59:59.000,

so create a statement like :

WHERE DATEFIELD BETWEEN '2/1/2007' AND  dateadd(mi,1439,'2/6/2007')

this will turn into an interesting thread, I'm sure...

If you take my data and put it into a database structure, the data is still mine, right? So If I learn...

this is a common issue, because the field you are querying contains date AND time....so records exist that are 02/05/2007 10:49:00 AM for example, which is not less that 02/05/2007..it's...

seems like kinda of a catch 22...you want to use sp_executesql, which is limited by it's paramater to a NVARCHAR 4000, but your command is potentially larger than 4000 chars.

I...

ugg... programming a solution because someone doesn't like to click print 3 times.....they don't need to File...Print...change to 3...just teach them to click the print button off the tool bar...

just to clarify, an option or checkbox must have the CHECKED in it's definition:it's a keyword, and not the "value"

<FORM METHOD=POST ACTION="">

<INPUT TYPE="checkbox" NAME="firstcheck" value="Value to send Via GET or...

I think we need a bit more information before we can really offer meaningful suggestions...

by syncronization of data, do you mean one way, from 2000 to 2005, with a change...

can't you simply export as comma or tab delimited, but name the the file xls so that it will open in the expected program? I know I do that all...

not an "automatic" way that I'm aware of;

you can make it a habit  to recompile objects on a regular basis (exec sp_recompile object name) for all procs, views and functions,...

newid() is the function most people use in order to get random order, and random counts use the rand() function.

I had to build the schema and data in order to...

just pasting some code that might be helpful: my snippets catalog named this "Find and Replace TEXT/NTEXT" this is really for when you cannot display a TEXT/NTEXT because it's more...

losts of good suggestions here...I wanted to mention that you should look at what the jobs are doing as well....maybe they can be replaced outright.

I had a similar issue where...

connection broken is typically a one time kind of error, where you lost your connection to your database, whether a cable was kicked out, an admin killed your spid, or...

you'll want to do the following:

do this on test first, and not production. I'm recommending using Enterprise manager for part of this, because it will handle a lot of the...