Forum Replies Created
Viewing 15 posts - 4,411 through 4,425 (of 13,460 total)
-
RE: Stored Procedure
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: MSDB database not responding
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:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Concatenate IN TRIGGER two fields into one in this line of the TRIGGER T-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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: automate t-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,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Concatenate IN TRIGGER two fields into one in this line of the TRIGGER T-SQL?:
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
...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Concatenate IN TRIGGER two fields into one in this line of the TRIGGER T-SQL?:
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
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SQL Login Trigger
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SQL Login Trigger
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...Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SQL Login Trigger
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...Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SQL Login Trigger
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,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Number of Business Day in Current Quarter
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Sql server 2012 connection
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: No login access to SQL
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.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Creating index
Artoo22 (11/12/2012)
kapil_kk (11/3/2012)
I want to create non clustered index on a view to check the limit that how many non clustered index can be created on a view.Why?
i think it's...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: LinkedServer for Excel Worksheet
that package adds the ACE drivers, which are not the same as the OleDB.
it's just like adding the drivers for MYSQL, SQLite or any of the many ODBC drivers for...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 4,411 through 4,425 (of 13,460 total)