SELECT MIN(dateTimeStamp), CUS.customerName, CUS.CustomerID

FROM EasyRecharge.dbo.CustomerUsage CUS

INNER JOIN EasyRecharge.dbo.Customers_Dormant CNU on CUS.FromMSISDN = CNU.MSISDN

WHERE ([DateTimeStamp]

between '2009/07/01 00:00:00' AND '2009/07/08 23:59:59')

GROUP BY CUS.customerName, CUS.customerID

This is assuming that the dateTimeStamp column...

You can set up a linked server from the instance that will be running the update to the instance that the other table is on. You can then do...

update wce_ilr set student_forname= ltrim(rtrim(Student_ForeName)), surname = ltrim(rtrim(surname))....

Do something like that for each column. Let me know if this works

just remove the ;

CREATE FUNCTION dbo.testFunction

(@STARTDATE datetime,@EntDt datetime)

RETURNS TABLE

AS

RETURN

with DateList as

(

select cast(@STARTDATE as datetime) DateValue

union all

...

If you are running this query in SSMS then there is a button on the toolbar called "Include Actual Execution Plan". You can use this to display what the...

ALTER TABLE temp ADD

test int NOT NULL IDENTITY (1, 1)

GO

This will add a column named test to the temp table. You will not specify any values for this column...

I haven't tested this but I think you could just put the different stored procedures into different schemas and then assign permissions to each group by schema.

CREATE TABLE #temp (test INT, test2 VARCHAR(50))

INSERT INTO #temp VALUES (1,'matt')

INSERT INTO #temp VALUES (2,NULL)

INSERT INTO #temp VALUES (3,'test')

SELECT test, 'Row 2 will be null ' + test2,

'All rows will...

SelectCommand="SELECT Project + ' ' + Task + ' ' + isnull([Sub Task],'') + ' ' + Description AS RAS FROM RAS_Codes">

Try something like that. If a null value...

From BOL:

log_shipping_monitor_alert (Transact-SQL)

Stores alert job IDs for log shipping.

log_shipping_monitor_error_detail (Transact-SQL)

Stores error detail for log shipping jobs.

log_shipping_monitor_history_detail (Transact-SQL)

Stores history details for...

I am interested in seeing this solution myself. I hope the formatting gets fixed.

select * into newTable from oldTable

drop oldTable

create oldTable (with new structure)

insert into OldTable (column list)

select * from newTable

drop newTable

Will that work?

I can see your point but there is another side to it. Since no folder exists then no files exist either. So I don't know if I would...

What result set are you wanting to get?

That should have returned 1 row with 2 columns

Does this work?

select

(Select Count(*) As SRIP FROM dbo.tblContracts C WHERE C.ACTION_CODE='SOLD_000003'

AND C.IT_Code = 'SRIP'

AND C.ContractStatus = 'A' AND C.UnitState = 'AZ') as SRIP,

(Select Count(*) As TA...