Forum Replies Created
Viewing 15 posts - 916 through 930 (of 13,460 total)
-
RE: Assign execute permission to all existing and new sp's for application role automatically
create a role, and then grant execute to the role; don''t grant on a per object basis, and you'll be fine.
as long as the proc uses objects only in the...
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: alien linked servers
the first handful of articles from my search points to networking issues, and not anything with SQL server itself.
[this article mentions Distributed Transaction Coordinator on the remote linked server...
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: alien linked servers
dschlobohm (6/13/2016)
after it says test okthen get this error
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or...
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: Email Notification Help using: sp_Send_dbmail, EXISTS statement, and data query
the COUNT will always exist, but it might be zero. that's not what you want to test. you want to test if any rows exist
instead just change to if exists...
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: Function to get Number from word
rash3554 (6/13/2016)
Yes, I do really need a solution. This is not a student assignment but a company project.Thx
ok, so is this a find and replace in a paragraph, or are...
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: Getting the VARBINARY data into a VARCHAR field
i got it, it's the leading char:
/*
NormalConvertBigEndianFinalResults
$1 egaP thgilF rof eeF noitcasnarTTransaction Fee for Flight Page 1
*1 egaP thgilF rof eeF...
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: Getting the VARBINARY data into a VARCHAR field
ok i'm getting close;
if i switch your values to BigEndian instead of Little, i'm getting your string, but backwards; i cannot seem to get it converted back to the last...
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: Function to get Number from word
there's a few threads on converting the opposite of this request/; numbers to words
the logic is basically the same, a bunch of find and replaces, the links and code samples...
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: alien linked servers
look at the metadata that is returned from eXEC sp_tables_ex MyAlienServer
it should return a list of items, and you could potentially drill down from there.
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: Join of two tables with sums of two different fields grouped by CustomerID
briancampbellmcad (6/13/2016)
I'm not following the placing of the literal amounts into the SQL. Shouldn't I just be using field names/:SELECT 100.00, 54215 UNION ALL
SELECT 125.00, 53252 UNION ALL
SELECT 110.00, 63225...
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: Join of two tables with sums of two different fields grouped by CustomerID
because there is a one to many relationship between charges and payments, you cannot join the tables directly, i think you need to join the summerization of those tables instead....
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 Calendar Table based on Start and End Date Help
twin.devil (6/13/2016)
Quick suggestion: you can add 6 days and you will get the end date as well.SELECT [date] as StartDate, DATEADD(dd,6,[date]) as EndDate
FROM CTE_DatesTable
OPTION (MAXRECURSION 0);
twin.devel nailed it, and...
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: Interview Questions
Sean Lange (6/10/2016)
LOL. Maybe we discount all aspects of t-sql so everybody can be a winner?!?!?!?!? :-D:-D:-D:-D
yay! everyone gets a ribbon for interviewing!
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: How to move Multiple Related Tables Data from one Database to another..
jujusa2016 (6/9/2016)
Hi,i have a similar problem. can you let me know how you resolved this issue.
post a new thread with details about what you are trying to do;
you'll get the...
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: Är du vår nästa talang inom Business Intelligence?
Translate.google.com (Swedish detected)
About the companyRGP is an international consulting company that offers qualified consulting services in Finance & Accounting, Human Capital, Information Management and Supply
Chain. We help our customers to...
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 - 916 through 930 (of 13,460 total)