Viewing 15 posts - 721 through 735 (of 2,894 total)
...
The only thing is the European format. which it does the decimal point instead of the comma to separate thousands.
...
Who told you that? It's not European format. We don't use...
January 31, 2013 at 3:07 am
johnnycash (1/30/2013)
Please excuse the dumbness of this question, but if I have an INT value of 999999 and want to display it formatted with the thousand...
January 30, 2013 at 11:00 am
Sean Lange (1/29/2013)
Or you could use and INSTEAD OF trigger and not have to worry about the transaction....
I do agree - it looks cleaner and easier!
January 29, 2013 at 9:14 am
You are welcome Forum Newbie 😉
Such a strange nick name you have... :hehe:
January 29, 2013 at 4:51 am
That is the case where table variable will be quite handy as it can keep data in rollback!
Here I've setup small sample for you. Hope you can follow the idea...
create...
January 29, 2013 at 3:46 am
DateValue is not SQL Server T-SQL function. It is a DAX one. You need SSAS in order to use it.
January 29, 2013 at 3:14 am
attempt of catch-all query detected!
I would suggest dynamic sql.
Something to read:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
January 29, 2013 at 2:40 am
...
I wonder if his fix isn't to restart the production server every night at 4 am....
I would call it anything but fix;-)
January 29, 2013 at 1:59 am
Don't blame me :hehe:
January 28, 2013 at 10:21 am
I cannot see any picture... :crying:
January 28, 2013 at 10:03 am
Try to get generated sql string out of stored proc, then execute it and post the query plan. Wihtout seeing it it's hard to guess what could be wrong with...
January 28, 2013 at 10:01 am
Cannot see sample of XML or "output" in your post...
January 28, 2013 at 9:39 am
Have you actually found which particular query in your stored proc is slow? Is the one which uses dynamic sql?
Can you please post DDL of fn_parse_multi_params_to_table?
January 28, 2013 at 9:36 am
purushottam2 (1/28/2013)
I am...
January 28, 2013 at 9:31 am
...
Have we got any chance of success?
It pretty much depends on your company criteria of "success" ...
Hopes die last!
:hehe:
January 28, 2013 at 8:44 am
Viewing 15 posts - 721 through 735 (of 2,894 total)