You have to split up the values in table 2. If you put this into a temp table, you can join this with table 3.

You can create a new query and use this as a sub-query within. You can GROUP BY this new query on 'TheMonth' and incluse a SUM on the 'Sales' column.

@Chirag: on the internet I've found "Min_active_rowversion() was introduced in SP2 for SQL Server 2005".

In my opinion you should let file handling be done by the OS and not SQL, because each is made for a different purpose.

Most likely you can find programs or...

Hi

Use this to change the value in field [VoxFilePath] for all records that are 31 days old.

UPDATE Recording

SET VoxFilePath = REPLACE(VoxFilePath,'\\10.2.1.20','\\serv02')

WHERE DATEDIFF(day, RECSTART, GetDate()) = 31

Put this code in an...

In addition to my first post in this topic:

Someone allready created a SP (SP_Generate_Inserts) to script the contents of a table to INSERT commands. Look at this url: http://vyaskn.tripod.com/code/generate_inserts_2005.txt

But maybe it is more easy to use a backup-restore procedure to create and fill a database.

Can you clearify why you want/need to script it?

For my knowledge there is no complete scripting available for what you want to do.

You can easily generate a script to create your tables and even the database (right click...

You can also create a backup of the current database and restore this backup on the new server and with the new database name. The advantage is that you can...

maybe some of these links will provide you enough information to create what you want:

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/2691/

http://www.sqlservercentral.com/Forums/Topic442795-8-1.aspx

http://www.sqlservercentral.com/Forums/Topic517308-338-1.aspx

To return the value of a SP use this:

CREATE PROCEDURE dbo.Dummy

@Dummy int

@Output varchar(50) output

AS

...

CREATE PROCEDURE dbo.Dummy

@Dummy as int

AS

SELECT *...

For my understanding...

According to the connection string, the application connect to SQL using integrated security. That means the Windows-logins of the user is forwarded...

ezekielen (7/17/2008)

---

Take care with the DTS. Try to test them in 2005 environment.

To edit DTS in SQL SERVER 2005 you need a microsoft tool named: SQLServer2005_DTS.msi , is available...