And not only that, even if you are selecting all, you should specify a field list always to account for the order of the columns yourself and not leave anything...

My first recomendation is not to denormalize it.

The second is

I don't see why you need a cursor though

UPDATE Tbl_Indexes SET Index_Desc = SFI.dbo.KeywordString(Index_OldID , Index_Type )

This is another variant:

create function dbo.udfCamelCase(@strin varchar(500))

returns varchar(500)

AS

begin

declare @copy varchar(500), @i int, @len int

set @copy = lower(ltrim(rtrim(@strin))) 

select @copy = upper(left(@copy,1)) + substring(@copy,2, len(@copy)-1), @len = len(@copy)

set @i = charindex('...

Agreed!

..it just simply put both column side by side.

To do that then you need to know which row goes with which row as Mark suggested above!

or better yet -- HOW YOU...

DECLARE @userID as nvarchar(10),

 @myTable as nvarchar(10),

 @strUser as nvarchar(100)

 SET @myTable = 16707

 SET @strUser = N'SELECT ' + @user-id + ' = UserID from dlr_' + @myTable + '_User where UserLName =...

select

      a.RegDate as A_RegDate,

      b.RegDate as B_RegDate,

      (case When A.RegDate > b.RegDate Then A.RegDate Else B.RegDate end) as  Max_RegDate

from

 TableA a

Full outer join

 TableB b

 on a.RegDate = b.RegDate

As long...

declare@Path varchar(128) ,

@FileName varchar(128)

select@Path = \\ServerName\ShareName\' ,

@FileName = 'file.txt'

declare @fe int

declare@File varchar(1000)

select @File = @Path + @FileName

exec master..xp_fileexist @File, @fe out

if @fe = 1

print 'exists'

else

print 'not exists'

Just so you know Access mdb files compress very well. Use any zip utility and transfer the zip file. Every once in a while performa a compact and repair as...

I have two questions for you though:

1. Do you have an index (unique) on table1.EmpNo and on table2.SocSecNo ?

2. How many rows on each table independently ?

exec sp_helprotect @username = 'YOURUSER'

btw you should be using roles instead of users

HTH

Jeff,

One solution to this kind of problems is to use the "pooling job method". Supposed you have a table that is monitored by a job and all your app has...

Nita,

That setting will try to start it but because it should be started already as a service it won't do anything. The messages that you see is because it has...

I have a friend who develops on case-sensitive servers and his opinion is that what he develops will also work on case-insensitive ones. He will love to see this one.

BTW...

>>I can connect with those logins using any other tool.<<

are those --> 6.5 Tools ?