edward_hall76 (11/13/2012)

---

ok. where I work not all people know how to write tsql code and if they mess up the tsql they do not know how to fix it is...

the issue here is GUI dependancy;

you've got to get used to using the TSQL window for your commands, instead of using the GUI tools.

if you right click on a...

duplicate post.

no need to cross post to multiple forums; it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

SQL...

Tava (11/12/2012)

---

briancampbellmcad (11/12/2012)

---

Both the PO_Number and HeatTicketNumber are already Varchar as the table datatype... so (?) no need for conversion (?)...

I ran the code above and now have a SQL...

ok, let me twist the question around on you...

why can't you update all the rows at the same time, where WIN is null, and ts_started is less than an hour,...

looked a little deeper, this is a syntactically correct version that only inserts the rows that have INSERTED.Transaction_Type = 'From Bulk Assignment'

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[trPopulateJournalEntries]

ON [dbo].[tblTransactions]

AFTER INSERT

AS

BEGIN

...

it would be simple concatenation;

if the types happen to be integers, you might need to convert them to varchars:

INSERT INTO tblSWJournal

(tblSWJournal.Ledger,

tblBulkPurchases.Amt)

SELECT

CONVERT(varchar(30),INSERTED.HeatTicketNumber)

+ ':'

+ CONVERT(VARCHAR(30),INSERTED.PO_Number),

INSERTED.Unit_Price

FROM INSERTED

well i cannot get a prototype to work;

this is the code i used for testing; i don't get any errors in the trigger, and a rollback command works fine, but...

Steve Jones - SSC Editor (11/12/2012)

---

A login trigger may help you here, but in conjunction with an application role. You might be able to trigger an application role as part...

zulmanclock (11/12/2012)

---

The problem i am faced with is my company uses a thrid party application. This application needs to have all the users assigned to a role which has...

I don't believe you can redirect the connection to another database... essentially the connection asks for login info/permissions only

yes maybe with an initial database gets passed in with the credentials,...

Darth do you have a Calendar table?

for me, business days, well, depend on our specific business.

for example, the quarter for today's date is from 10/1/2012 to 12/31/2012.

there are 92...

on my dev machine I have the last 4 versions of SQL installed.,and i have a port layout scheme to make it obvious to myself,

my default instance is 2005 listening...

in 2005, there's the surface area configuration utility to add yourself:

in 2008, you need to start the service in single user mode, and add yourself.

http://www.bradg.co.za/?p=51

i think it's...