Very nice article, Thanks !

Very good suggestion, thank you 🙂

You can add source and destination table's schema as parameter of SP and use there in code.

I have tried it for 2005, I think it will work for 2008 also.

It is always easy to just run the query rather than do it from SSMS Maintenance Plan Wizard.

Hi all SSC Members,

Happy new year!!

Try this query:

Select

Produit,

Count(Compte),

Count(CASE Date WHEN '01/01/2010'...

I think this query will help you

select PatientID,first_treatment_id,TreatmentStartDate,TreatmentEndDate,STUFF((SELECT ',' AS "text()",

TreatmentID AS "text()"

FROM patient P

where P.PatientID =B.PatientID and P.TreatmentID <> B.first_treatment_id

FOR XML PATH('')),1,1,'') as Other_treatment_Ids from (select PatientID,Patient.TreatmentID as...

i get error 'RETURN statements in scalar valued functions must include an argument.'

when try to create to that function.

if shorttime in hh:mm format then just used:

select CAST((cast((datediff(minute,[EmpSIN],[EmpSOut])-datediff(minute,[FirstIn],[FirstOut]))/60 as varchar(10))+ ':' + cast((datediff(minute,[EmpSIN],[EmpSOut])-datediff(minute,[FirstIn],[FirstOut]))% 60 as varchar(10))) AS TIME),

This setting may help you

sp_configure 'show advanced options', 1

RECONFIGURE

GO

sp_configure 'transform noise words', 1

RECONFIGURE

GO

This setting may help you

sp_configure 'show advanced options', 1

RECONFIGURE

GO

sp_configure 'transform noise words', 1

RECONFIGURE

GO

You can use where exist i think that will be faster

select * from Table a where exists(select 1 from V_LOAD_COMBINATION where V_LOAD_COMBINATION.Date = a.Date and V_LOAD_COMBINATION.Country = a.Country )...

I think you can also use cross apply for it.

SELECT dbo.invend.fpartno, A.FirstEmail,B.SecondEmail,C.ThirdEmail

FROM dbo.invend INNER JOIN

CROSS APPLY(SELECT top 1 dbo.apvend.fcemail as FirstEmail from dbo.apvend.fcemail AF...

Yes, right that will return 31 with that input.