Viewing 15 posts - 316 through 330 (of 345 total)
Yes, I remember mutex from OS class oh so long ago. Couldn't think of the term. Thanks for that.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 11, 2011 at 9:36 am
What is nice about an Access project is that it has a natural connection to SS so you can always just reference CodeProject.connection. But if it's an mdb, you can...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 4, 2011 at 7:42 am
If it's a database file instead of a project file, it's not any more complicated. But let me ask this: why send your data through parameter calls of a SP...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 4, 2011 at 7:22 am
If your Access file is an adp connected to the SQL Server database, then just use VBA like this:
Dim rs As New ADODB.Recordset
rs.Open "EXEC [usp_MyProcedure] " & ID, CodeProject.Connection
If Not...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 3, 2011 at 3:02 pm
ok, let's try from another angle. type this in a query window in SSMS and execute it. let me know the response.
alter table [table_name] add primary key ([column_name])
of course, replace...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 1, 2011 at 7:03 pm
Set the PK in SSMS. When you reopen your Access project it should reconnect and recognize the PK.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 1, 2011 at 6:32 pm
blackwell (1/31/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 1, 2011 at 3:27 pm
Use SQL Server Agent to make jobs to run your queries.
http://msdn.microsoft.com/en-us/library/ms189237.aspx
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 20, 2011 at 11:17 am
For the sake of my OCD, combine the two inserts in the trigger:
ALTER trigger [dbo].[InsertJoinWebsiteEVS]
on [dbo].[Members]
for insert
as
SET NOCOUNT ON
insert into EVSActions ( Membership, EVSActionTypeID, ActionDate )
select
Inserted.Membership,
case when Inserted.bitUser_MonthlyOptIn = 1...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 19, 2011 at 2:24 pm
If there are optional foreign keys in your main table, then left join. This should get those values:
select t.CNSTransID,
t.DataSource,
t.UserID,
CAST (t.ExternalFileDate as DATE) ExternalFileDate,
t.ExternalFileIdentifier,
t.OrgSysTransID,
s.HiNetMajor,
t.HiNetMinor,
t.SettleCurrCode,...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 19, 2011 at 2:15 pm
This article was posted earlier this week:
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 14, 2011 at 1:28 pm
I guess I should be clearer. The trigger is breaking when concatenating the msg with the @Last_Login_Date, so I wrapped it in a CAST. You didn't see that error because...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 13, 2011 at 4:40 pm
I think your trigger is erroring out. Run this to update GSquared code:
ALTER TRIGGER LastLoginDate ON dbo.users AFTER update
AS -- first error fixed here
--//ColumnName
DECLARE @Last_Login_Date datetime, @msg varchar(500);
IF EXISTS
...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 13, 2011 at 4:31 pm
Your query can't get any simpler for better performance. But HowardW has a point, why use the subselect at all?
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 13, 2011 at 11:47 am
Actually we're only after the points. I hear the winner gets to choose from an xbox and a mountain bike.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 12, 2011 at 4:29 pm
Viewing 15 posts - 316 through 330 (of 345 total)