Sorry...the full portion of the question is here.

Hi Noeld,

I like your replies and I 100% agree to that.

I have a question. Could you please explain in detail.

I have...

Hi Noeld,

I like your replies and I 100% agree to that.

I have a question. Could you please explain in detail.

I have a stored procedure "getbyloancust"

The logic of the stored procedure...

http://support.microsoft.com/?kbid=210249

I hope the above link will help you out.

Thanks,

Ganesh

Follow this link which will give a detailed idea about the error trapping.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;240221

Thanks,

Ganesh

This is pretty straigt forward. I have also faced the same kind of problem.

Open the excel sheet, Copy the content of the cell and paste it to notepad,Select the column,Right...

As per the error you have stated, I doubt the data file is missing. Pls cross check whether the file exists.

Thanks,

Ganesh

I will give the framework to do that. There might be some syntax error also. Pls do adjust.

CREATE FUNCTION First_Last_Week_Date(@Weekno int, @Year int)

RETURNS varchar

AS

BEGIN

DECLARE @ReturnString ...

Pls follow this link.

http://www.databaseanswers.org/data_models/index.htm

You will find the database model for it.

Thanks,

Ganesh

select Person.Name,Property.Name

from PersonProperty

join Person

on Person.PersonID = PersonProperty.PersonID

join Property

on Property.PropertyID = PersonProperty.PropertyID

where Property.PropertyID =2

AND Property.PropertyID =6

AND Property.PropertyID =9

Thanks,

Ganesh

1.Run this

UPDATE STATISTICS TableName(Indexname)

WITH FULLSCAN, NORECOMPUTE

2.Alter the view by giving the order by clause. Something like this.

Create view myView as

Select top 100 percent * from Tablename

where...

Ordered Data Files:

Using ROWS_PER_BATCH:

Controlling the Locking Behavior:

Search for all these topic from BOL.

Question 1: While doing a BCP,foreign key constraint will not be checked by default. If this is the...

You can call stored procedure by the following way.

USE pubs

GO

SELECT a.*

FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',

'dbo.YourProcedureName') AS a

Thanks,

Ganesh

Yes. Provided the date file location is shared.

exec master..xp_cmdshell 'bcp "select * from Northwind..Customers" queryout "\\Ec2pin124241\CallDTS\Customers.txt" /c /t"," /Usa /P /S EC2PIN124241\EC2PIN124241'

Hope this suffice your query.

Thanks,

Ganesh

--FirstDayofMonth

select datename(dw,CONVERT(DATETIME, CONVERT(VARCHAR,datepart(M,getdate())) + '/1/' + CONVERT(VARCHAR, datepart(YYYY,getdate()))))

--LastDayOfMonth

select datename(dw,dateadd(dd,-1,dateadd(mm,1,convert(varchar(7),getdate(),120)+'-01')))

Thanks,

Ganesh

http://www.sql-server-performance.com/stored_procedures.asp

For best performance, all objects that are called within the same stored procedure should all be owned by the same object owner, preferably dbo, and should also be...