No, you can't swap the conditions between FROM and WHERE. In your same query, get the second condition (orderid not null) to the join clause, you will see the difference...

May be if you want to do this frequently, then create an udf and do the update as shown below.

CREATE FUNCTION dbo.ALLVALUES(@Category varchar(100))

RETURNS varchar(1000)

AS

BEGIN

DECLARE @allnames varchar(1000)

SELECT @allnames = COALESCE(@allnames +',','')...

Hi,

Will this work for you??

SELECT RIGHT('PRAKASH',LEN('PRAKASH')-2)

Thanks

Hi Jeff,

Thanks for the input on my query.

Hi Garadin,

The initial requirement gave me an impression that the second table does not really depend on the data_period table...

Hi,

I am recently into SQL Server programming and assuming we need a single row for each line, I have written this query which is giving the results as expected....

Its throwing the same error,

TABLES cannot be dropped

Msg 3609, Level 16, State 2, Procedure sp_MSdrop_pub_tables, Line 17

The transaction ended in the trigger. The batch has been aborted.

The only configuration...

Thanks Steve for your reply,

I checked the name again and its correct and tried the other proposed way of keeping subscriber and running this procedure but I got the same...

Hi,

I have read an article here which talks about retrieving the SQL statement during a block/deadlock.

Have a look, this might help you about the information you are looking for.

Hi,

As said in the previous comment, its actually the requirement and the environment which decides what to go for. There are two ways of it,

1. In place upgrade

2....

Hi,

I had a similar problem in the past and creating a linked server on the remote server pointing to this server solved the problem and could insert data into...

hi,

CREATE TABLE TEST(empid int, empcode varchar(5))

INSERT INTO TEST values (1,'s1')

INSERT INTO TEST values (1,'s2')

INSERT INTO TEST values (1,'s3')

INSERT INTO TEST values (2,'s1')

INSERT INTO TEST values (2,'s2')

INSERT INTO TEST values...

Hi

If I want to set the return value of a stored procedure to a variable, this is how I would do

declare @int as int

Exec @int = uspGetEmployeeManagers 12

PRINT @int

If I...

Hi,

Under the server instance name, u can see 'SQL server Agent' -> Jobs -> New Job - > Schedule -> New and select the schedule.

If you cant see 'SQL...

Hi,

I have created a linked server recently from SQL server 2005 to SQL server 2000. Can you give some more information on where exactly you are having the problem?

Regards,...

Hi,

As it was pointed out rightly in the previous reply that a linked server can be used, also if it is not being used in any stored procedure and...