Any suggestions? I'm getting an error when trying to use an UPDATE statement inside of a function. error: Invalid use of side-effecting or...
thanks ghemant 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]
thanks jagblue 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)...
excellent! thanks all for your input [H][Y]
Hello All, 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...
hello all, I used the ascii value char(9) at the end of each word in my procedure: SELECT rtrim('MY')+char(9)+rtrim('WORDS')+char(9)+rtrim('ARE'...
Hello all, 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
Hi All, 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.
