If you execute the following command in QA, it will give you information about the number and names of the files for that database abckup:

RESTORE FILELISTONLY FROM <Database Name>

The RESTORE...

And just a note of caution here, it would be wise if you did not use langauge that might offend others (your post #33), especially when they are also trying...

Depending on whether the table will be used in a join with other tables, and assuming that ID is the join key, then possibly you could make it the clustered...

Try this link:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=547

Not sure that this will solve your problem, but you can use the 'SET DATEFIRST' T-SQL command, for example:

--store the current datefirst setting

declare @datefirst int

select @datefirst = @@datefirst

--reset the datefirst setting to...

By rewriting your statements, I get the following:

select sum(Sales)

from dbo.vw_SumContentPack

where [Date] IS NOT NULL

select sum(isnull(Sales,0))

from dbo.vw_SumContentPack

Is it? If so, then the differences are quite plain!

Alternatively, the first sum should be dbo.vw_SumContentPack.[Sales], instead of dbo.vw_SumContentPack.[Date]?

You are better off using a function. Read up on 'create function' in BOL.

Try this; it seems to work with the following selected sample data:

declare @sql varchar(1000), @sql2 varchar(1000)

--select @sql = 'ICE CREAM FOR THE INEPT STRING PARSER FUNCTION 55PT 767565'

--select @sql =...

Not sure if the problem is related to the 'text data' attribute or the varchar(1000) attributes or both! Here are a couple of things to look out for:

1. Make sure...

The link to the article you specified does state that the meta data for both push and pull subscriptions are removed at the publisher by the 'Expired Subscription Clean-up Job'....

One approach would be to create a sub-query to obtain the most recent LastUpdatedOn date grouped by ID, e.g.

select ID, MAX(LastUpdatedOn) as LastUpdatedOn from TableX group by ID

Then simply join this select...

You cannot make changes to the data from the 'results pane'. The easiest way would be to re-write your select statement into an update statement.

Alternatively, if you perform the same...

Since you have one less column in the target table, you can use a format file to specify the required format. Type 'format files' in BOL to find out more.

You can use the CASE statement to test for parameters that were not passed in; if the test returns true then simply set the argument to itself, for example:

select *

from table_1...