If you are reading from the sproc, trying to populate your form you can do this:

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset

'Call the stored procedure, passing it the parameter,...

Insert into a temp table that will be blown away. Then create an "unmatched" query by left joining my existing table with the temp table. Off the top of my...

Well, adding him to the db_ddladmin role worked!!! But what else can happen :S

The user is a manager and doesnt know about F11, so he doesnt get into the DB...

I believe you have to roll your own. I recently took on a job where this was being done with a C# program using ADOCE to transfer data between an...

Cdate() is now Cast( yourvariable AS DATETIME) or you can also use CONVERT(YourVariable, DATETIME, 112)

ISNULL() is ISNULL() in SQL too, but actually works like NZ() in access. ISNULL(SomeValue, ValueIfNull)

UCASE() is...

wow, I tried it for next month (February) and it returns the 28th, pretty cool.

declare @31st datetime

set @31st = '19341031' -- any 31st

declare @now datetime

set @now = dateadd(month,1,getdate())

select dateadd(month,datediff(month,@31st,@now),@31st)

----------------------------------------

2005-02-28 00:00:00.000

Great date samples guys! I love the archives!

In using Kens example above, wouldn't this be better for LastDayLastMonth?

Dateadd(Day,-Datepart(day,@TruncDate)+1,@TruncDate) -.0001 as LastDayLastMonth

This is simply FirstDayThisMonth - .0001 thus giving me (for...

Sorry, I was pulled away and thought I was answering the question when I returned

Can you not set a variable for the path...

You need to kick off any users first:

DECLARE @dbname as VARCHAR(50)

SET @dbname = 'YourDataBaseNameHere'

DECLARE @strSQL varchar(255)

PRINT 'Killing Users'

PRINT '-----------------'

CREATE table #tmpUsers(

spid int,

eid int,

status varchar(30),

loginname varchar(50),

hostname varchar(50),

blk int,

dbname varchar(50),

cmd varchar(30))

INSERT INTO...

Are there any reason why you cannot simply switch to unbound forms? If not, are you binding your forms to tables or to views? If you can make a view...

If you'd rather go the pre-built route, try downloading a trial copy of asqldiff109a.exe from http://www.adeptsql.com/download.html?aff=href

It works pretty sweet, although it was a bit too expensive for me...

The answer was in the archives! Darn, sorry for the post!

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=2903&FORUM_ID=8&CAT_ID=1&Topic_Title=Get%20the%20value%20of%20an%20autoincrement%20identity%20col&Forum_Title=T-SQL