Usually it's filtering if you aren't getting it. Or maybe some rule that snags it since the content changes daily.

They're always here: http://www.sqlservercentral.com/newsletter

DTS is the easiest way to do this. Open a new package, add a connection to SQL Server and one to your access db. specify your view and destination table,...

http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp

http://www.sqlservercentral.com/columnists/sjones/20010424135929_1.asp

You can add "print" or select statements inside for testing as well.

create procedure mytest

@myvar int, @myvar2

as

select @myvar, @myvar2, 'parameters'

declare @mysum int

select @mysum = @myvar + @myvar2

print @mysum

select @mysum

return

This should return...

What is the ASP page trying to do? You have something that's read-only and if you're trying to update it, you might get an error.

Thanks for the update and not deleting the post.

I'd make each of these a separate procedure just for readability. But I'm not sure it's more than personal preference.

I think you can continue with it. At first glance I don't see any other 2005 features in there.

As I see above, they're bit maps. So if you set the 4th bit, leaving, 1, 2, 3 at zero, you have 1000 in binary, or 8.

Since you're dealing with...

I believe only Database Mail (as mentioned above) works in 64-bit. SQLMail is a leftover from SQL 2000 and only runs on 32-bit.

SQL Server gets time from the OS, which gets it from the hardware clock. An update, like the DST we have in the US, is slightly delayed (a second or...

I'm looking forward to Simon's post and a recursive reference as well

If you haven't checked out his blog (we link it in Database...

Do the new ids need to be unique?

Is this more complicated than:

insert b select * from A

insert b select * from A

insert b select * from A

...

?

The easiest way is the advice above using the sp_ms procedures. These aren't supported, but they will likely be continued since some MS procs use them.

It was created at the request of a member for discussions about employers and issues working for them.

The original thread is here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=325486