There is scope for another function work hours in a daterange

regards

john

Use Transactions is better then rowloc

begin tran

1.INSERT INTO tab1

2.DELETE from tab1

commit tran

regards

john

A small correction

create proc MarriageStatus (@EPNAME VARCHAR(10), @status VARCHAR(3)

AS

BEGIN

UPDATE EMPLOYEES

SET STATUS=CASE WHEN  @status='YES' THEN 'Y' else 'N' end

where

create proc MarriageStatus (@EPNAME VARCHAR(10), @status VARCHAR(3)

AS

BEGIN

UPDATE EMPLOYEES

SET STATUS=CASE WHEN  @status='YES' THEN 'Y' else 'N'

where

emp_name=@EPNAME

END 

go

exec MarriageStatus 'Rajdeep' ,'N'

send...

Theoretically speaking select distinct is the best way but, which are the fields you want to be distinct may change in each case.

Virtually these are the problems of people who...

information schema objects are extractions of sys tables see,

select * from sysobjects where name like 'sys%'

But I think you are seeking some other thing,posting your corret requirement will enable other experts...

Hi ,Hi

Poor Developer Guy ,They are dreeming but to certain extent you can help them ,say for example adding filtering options to...

I agree .

I have few doubts regarding this

First of all if my domain is DOM1 then how shall I do this in sqlserver1 running in PDC ,

sp_grantdbaccess...

Good Idea ,

Once in bluemoon import means ,just save the file in dbase format and then import

regards

john

This problem is can be sorted out by either

1. Select the column in excel right click ,select format cells, in category list select text  press ok. This will solve the problem .
2.  If...

We have

We have to appreciate this work ,this is going to be use full while we are going for development of access control portion of very large database applications.

For...

Oh my lord,

There is no need to say much on this error , While parsing a query the first parser will go for a replace for the alias names...

Standards will come only after ideas , else the fate of many ISO standards would have been some thing else .

To make it client independent better go for...

Hay you are doing good job but consider my suggestion also,the discussion is moving away from the topic "Generate Next Numbers with SQL Server"

CREATE TABLE TBL_SEQ_PATTERNS...

you can just populate a log table with select Last_Disp , Kount=count(*) ,en_date=getdate() from dbo.vw_AZ_Leads_Dialable group by Last_Disp also its more general ,and works even if...