Tomm Carr (8/27/2008)

---

rbarryyoung (8/27/2008)

---

Yeah, I've been playing around with a version like that one, Noel. Except that I think that you have the A's & B's reversed: you...

For Inner JOINs there is no logical difference and the Query Optimizer is free to take advantage of that fact. So, usually there is no difference and if there...

Sure try this:

USE [TargetDB]

GO

Declare @sql NVarchar(MAX)

Select @sql = Replace(definition, '[dbo].[get_info]', '[dbo].[get_info_customer123]')

From SourceDB.sys.sql_modules

Print (@sql) --NOTE: will cut off at TextWidth, which is usually 255-8000 bytes

EXEC (@sql)

Try it like this:

alter procedure UPDATEHISTORYCURRENTYEAR

@year varchar(10) = NULL

AS

IF @year IS NULL Select @year=datepart(yyyy,getdate())

....

not according to BOL guys:

This setting is used only in the interpretation of character strings as they are converted to date values. It does not affect the display of date...

noeld (8/27/2008)

---

I felt that I had to post my version 😀

SELECT a.ShiftID

, a.TableID

, a.StationID

, a.EmployeeID

, a.CounterDateTimeStamp

, a.MusselCount

, a.CounterTimeSpan

,(SELECT TOP 1 b.MusselCount

...

Modified version: for some reason the Coalesce() makes the optimizer go stupid:

Select [ShiftID]

,[TableID]

,[StationID]

,[EmployeeID]

,[CounterDateTimeStamp]

,[MusselCount]

,[CounterTimeSpan]

,MusselCount - (Select...

Good point. Gus. It could be set on SQL Mail instead.

If you need to stay within SQL Server alone, then the easiest way is probably to use the SQL Agent Job system.

Write a stored procedure that will call your query(s)/proc(s)...

Please do not cross-post.

FYI, you got your Set IDENTITY_INSERT On/Offs backwards.

sweetdeal42 (8/27/2008)

---

There are over 340 rows in the table so I need to do the mapping in the most efficient way.

I am wondering if there is some t-sql trick...

This is a little too abstract to give a clear answer. Can you give some examples, please?

Even better, see this article for how to get better answers from the...

If DBMail works everywhere but in the Agent Alerts, then I would check out their definitions.

Here's an example :

select nchar(0x3A0)

This displays the Greek capital letter Pi. This can esialy be stored and retrieved from any column in a table with an NChar, NVarchar datatype.