i think in your case this will work.

Raiserror('message %s',0,1,@rowcount)with no wait.

it will give u the message at the time of execution it self

for more details follow the like

u can use while loop instead of cursors, as cursors are always costlier.

use a temporary table get all the values to temporary table process one by one using variable.

i...

ya, my question is large no. of output parameter hurts procedures performance if yes then why ??

As per your information provided

Cannot insert the value NULL into column 'RunDT', table 'BackupDW.dbo.DatabaseBackupHistory'; column does not allow nulls. INSERT fails

this is happening cause of in your table DatabaseBackupHistory, RUNDT...

select s.stud_code, s.given_name,surname,s.year_grp,s.form_cls,x.Num_Absences

from Student s

inner join

(

select stud_code,count(*) Num_Absences

from StudAbsent

where Absent_date between @StartDate and @EndDate

and absent_Type='AFS'

group by stud_code

having count(*) >= 3

) x on s.stud_code = x.stud_code

where year_grp >...

Hi Andy,

Great article I am dying to know more about SSIS, looking forward to read the rest of the series.

thanks buddy great work

Andy,

Great article i am dying know more about SSIS, looking forward to read the rest of the series.

thanks buddy great work

Check this link :

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

Hi,

If you can join two tables with employerno. then you can easly update it by joining both table with nullify the other table its like join with null conditions.

Group by is used to grouping data or use some aggregate funtion.

if you are using group by then all the columns that are in the select list should be a...

you can do it by converting the datediff to varchar and use charindex on that.

example:-

SELECT CHARINDEX('1',DATEDIFF(mm,GETDATE()-30,GETDATE()))

you can manipulate the query as you want.

hi,

i often use output procedure to return single value list.

here is an example of that

procedure :

USE [PalladiumShare]

GO

ALTER PROCEDURE [dbo].[WICompaniesOutput]

@CompanyId BIGINT,

@CompanyName NVARCHAR(200)...

hi,

follow the links

http://www.mssqltips.com/tip.asp?tip=1667

good site to follow

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

http://msdn.microsoft.com/en-us/library/aa213233(v=sql.80).aspx

you can do it through. stuff if it is a column value. e.g.

STUFF((

SELECT ',' + CONVERT(NVARCHAR(1000),pu.UserId)

FROM dbo.WI_ProjectUsers pu

WHERE pu.ProjectId = CTE.ProjectId

ORDER BY pu.UserId

FOR XML PATH(''),

...

RAISERROR('Inside loop',0,1)WITH NOWAIT

follow the link to know more about raiserror

http://msdn.microsoft.com/en-us/library/ms178592.aspx