I'm getting an error when trying to use an UPDATE statement inside of a function.
error: Invalid use of side-effecting or...
would you know what table I need to join with sys.objects so I can retrieve the table name and the table create date?
Is there a way to query table names and the date the tables were created?
thanks in advance [:D]
I think I simplified things a bit. The actual table has 16 columns that I need to compare to find the lowest value out of those 16...
Any ideas on how to tackle this using SQL:
column A = 10
column B = 20
column C = 30
column D = the lowest value of the 3 columns (which would be 10)...
thanks all for your input [H][Y]
I'm inserting into a table via the back end. (using a stored proc)
I think my insert locks the table because there is a delay on the front...
Well I really started to like functions becasue they are reusable. I thought subqueries contribute to performance issues.
I have a function that evaluates if a record exist. I return a char(1) y or n. The function works fine but what is the general rule of thumb when...
you can also try this to query a LINKED SERVER
SELECT * FROM [LINKEDSERVERNAME].DATABASENAME.dbo.TABLENAME
definately open EM and connect to the database where the table resides. query the table SELECT * FROM TB_CF_TRADE_BILLING just to be 100% sure the...
thanks for the suggestions I will take a look and evaluate ;-)
I took a look at their site. http://www.idera.com/Products/SQLdm/
Looks like a good product. Thank you.
any other suggestions welcome.
Can anywone share their thoughts on SQL Server monitoring tools specifially for perfomance and maintenance? maybe something with:good out-of-the-box...
well I removed the rtrim() and cast char(28) -- (I used 28 because out of all the fields, 28 is the max number of characters)
I used char(9)...
The data is presented in a front-end (Quark) and the designer created a grid look and feel to the layout. Yet the text doesn't come over in a fixed...
I used the ascii value char(9) at the end of each word in my procedure: SELECT
Using SQL2005 importing I do not see the option to import an xlsx file. Is this a SQL service pack issue?
as always thanks for you help
Thanks Adriaan and good point. <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />it's all good
I am investigating other options for returning the data to the calling reports or web apps.
Since both a table-valued function and stored...
Separate names with a comma.