If you have a million row table and you send select /Columns/ where /criteria/

to the app it will send alot more data across the network but will process (depending...

You would have to ensure you create the orders one at a time and wrap it in a transaction so that the sequence returned is unique.

You could also implement a...

CREATE TABLE dbo.TempOrders (

OrderType varchar(1) NOT NULL,

OrderYear int,

OrderSequence int,

OrderNumber AS ( OrderType + RIGHT(CAST(OrderYear as varchar(4)),2) + '-' + RIGHT('000' + CAST(OrderSequence as varchar),3) ),

PRIMARY KEY ( OrderType, OrderYear,...

You could add the "Other" values to your lookup tables with an OtherFlag or ExcludeFlag and then filter them out on your selects for dropdowns. That would let you always...

Here is some good code you can leverage for the DST issue.

It will have to be modified for your specific needs but is a good starting point.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28712

you can change the system time on your SQL servers to be all the same timezone or you can have the timezone accurate for each location and insert all your...

try to build a variable for your query

DECLARE @QueryString varchar(500)

SET @QueryString = 'Select * from mail_merge where Supervisor_Email = ' + @Supervisor_Email

Change

@query = 'Select * from mail_merge',

To

@query = @QueryString,

Without knowing the design I am just giving my rule of thumb, which would to be create tables such as the ones below.

SourceA --> SourceANotesLink --

SourceB --> SourceBNotesLink...

I would make it a seperate table for when they decide they want multiple notes.

"BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression and less than or equal to the value of end_expression.").

if you set...

your original dataset posted was

2008-08-10 01:48:00.000 3

2008-08-10 01:54:00.000 3

2008-08-10 02:00:00.000 13 1

2008-08-10 02:06:00.000 3 2

2008-08-10...

CREATE TABLE #OrderedSet ( SeqId int IDENTITY(1,1), StartDate datetime, value float, Sequence int )

INSERT INTO #OrderedSet ( StartDate, value )

SELECT StartDate, Value FROM #Conditional

DECLARE @SequenceId int

WHILE EXISTS ( SELECT 1...

it sounds like the second condition you added is an integer and the data is char/varchar

IE if you are doing something like

DECLARE @Parm int

SET @Parm = 22

SELECT * FROM...

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

the timestamp column is a column type that has system generated binary data in it.

typically used for replication.