View Complete Post
I am of the opinion that the query below can be written using a windowing function instead of the self join.
Can anyone help with this please.
FROm #hold a
where TransactionDate = (SELECT MAX(TransactionDate) FROM #hold b where b.PersonURN = a.PersonURN and b.DealerID = a.DealerID)
how to disabled the word label in my aspx page if my query is null... i dont like to show the word label in my aspx page.
im using c# .net
I am running a sql script which Inserts 500 rows and after each insert, it calls a stored procedure which diplays result in the results window. So after executing 100 rows, it throws an error that maximum number od results in the results pane has reached its limit but the query executes successfully. How can we disable the stored proc output to not display in the results pane. I do not have access to the stored procedure.
I have a SSIS 2005 pkg with an execute SQL task and a query as a SQLstatement. I want to capture a possible error generated from this query. How can I do it? Using the Result set?
I installed SSMS ToolPack and now in every query I have it would show
What does these do? Like If I run a select query within them, it runs fine, I didn't try to do anything else. I read online about this a while ago and I remember that you have to set a TRAN for begin part, but I don't know what is the use for these
as they are right now. Any help would be appreciated
hi i using a model pop up window with some textbox but when i click on textbox of model pop up focus move to back to page textbox control plz help me
I need to create a system, that will be similar to ms word style comments. So the idea is the following: on the page there are a pack of text boxes labels and so on, and user need have the way to comment each control, and save commented text, for example to DB, so the others can reed comments too.
I tried PopUpControlExtender, but it works in single way, and i cannot view all the popups in one time. Or may be i missed something and there is a way to popup all the controls at one time?
Therefore, are there any known solutions for a discribed task, based on PopUpControlExtender or something else?
Is it possible with SQL sorted in descending order according to the word?In Table I shrajeno Mastercard, Visa, Diners etc ...All Visa are the first in the order, another Mastercard, etc. ...Something does not work: ORDER BY PaymentType = 'Visa';I would not want to work in one field PaymentId (111,222,33, etc. ..) and then use the ORDER BY.Is this possible in such a way?
i have a feild in database where we store data like
i want only first to word to show in textbox1 like(only PT).