those queries are not returning the weired desired result

DECLARE @Customers TABLE(

REGISTER int,

CUSTOMER varchar(50),

CITY varchar(50),

COUNTRY varchar(50))

INSERT INTO @Customers

SELECT 1 ,'PELE', 'SANTOS' ,'BRAZIL' UNION ALL

SELECT 2 ,'RONALDINHO', 'BARCELONA' ,'SPAIN' UNION ALL

SELECT 3 ,'ROMARIO', 'RIO DE JANEIRO' ,'BRAZIL' UNION ALL

SELECT 4...

BO -

RESTORE

NORECOVERY

Instructs the restore operation to not roll back any uncommitted transactions. Either the NORECOVERY or STANDBY option must be specified if another transaction log has to...

then start SQL "Server Network Utility"

SQLCMD -L

"combine the three parameters Floor,Suite and Room and compare it with Floor" how do you combine the 3 params ? You need to post more details go get a solution...

check BO for CONVERT

start->run cmd-> ISQL -L

go to start .... SQL 2005--- SQL Server Configuration Mnager and enable protocols for Network Configuration

yes they are able just make sure to change the tcp/ip port for one of them

DECLARE

@T TABLE(MemberNbr varchar(15),AlternateMemberNbr varchar(15),PlanType

No offense was intendet there Asim but it seems that you are a real beginner. If your software is commercial than I would suggest you to get a pro opinion...

Asim you better say in words what you try to accomplish. You are allready on a wrong route ...

Just so that you know every time that you CALL your stored...

your logic has 1 flaw tho ...

in the select your selecting TWO KNOWN values

SELECT CalcAction FROM ClaimCounts_Test

WHERE CalcAction='Total Record Count'OR CalcAction='Record Count of Unique Claims '

ORDER BY CASE...

To view the job history

1. In the details pane, right-click a job, and then do one of the following:

   • Click View Job History if you are viewing the...