try this

Create

table ntexttest (sno int, val ntext)

Create

try this

Create table #orders(orderid int, quantity int)

insert #orders

select 1,3 union all

select 2,1 union all

select 3,4 union all

select 4,2

GO

Create procedure orderproc as

begin

 declare @oid int, @cnt int,@i int

 Create table #temp(orderid int, quantity...

Its very simple logic,

In All the four columns One Column only contains the value and all other's contains 0, Then dont allow any value to be true for two conditions,...

Replace the totOpen column def in Query with this, hope it will work

CASE WHEN Payday IS NOT NULL OR WRcurrentStatus = 110 OR WRcurrentStatus = 40 THEN '0' ELSE DEaltKeyValue END...

use the following query to get the desired output

declare

@test-2 table (col_1 int, col_2...

same result using CTE's

WITH ACTE ([ID],[Name],[NameCount]) AS

 (

 SELECT [ID], [Name], COUNT([Name]) NameCount FROM  MyTable1  GROUP BY [ID], [Name]

&nbsp

 SELECT B.[ID],MIN([NAME]) AS [NM]

 FROM...

try this

select * from employeedetails where edescription='employee name is ''john jackson'' and state is ''ca'''

This can allow upto 16000

declare @sql1 varchar(8000),

 @sql2 varchar(8000),

@ret int

set @sql1=N'Select * from '

set @sql2=N'sysobjects;'

exec( @sql1 + @sql2)

I think you need to capture return code, that is not possible with...

But I am able to create a synonym for a SP and successfully executed that SP using synonym in SQL 2005

CREATE

SYNONYM [dbo]