Viewing 15 posts - 226 through 240 (of 428 total)
It is not exactly what you asked for, but isn't this what you meant to get? This gives you the total of what every company needs to pay to the...
October 6, 2011 at 12:57 am
I would rather try something like below query. It uses window function row_number() to partition by server - status combination, ordering descending on the update_date. All most recent server -...
October 5, 2011 at 3:56 am
TDSapp (10/4/2011)
I hope I have given you enough details on what I need help with.
You could give us the criteria for a customer being in group 1 or group 2......
October 5, 2011 at 1:05 am
derekr 43208 (10/3/2011)
This is the result:
(18 row(s) affected)
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'GO'.
Msg 102, Level 15, State 1, Line 6
Incorrect syntax...
October 3, 2011 at 6:29 am
mapperhd (10/2/2011)
However, I need to keep only the columns that are not equal. Let's say there are 12 columns in the two records being compared. If columns...
October 3, 2011 at 1:34 am
UnionAll (10/1/2011)
Convinced to store XML directly in a table.
A follow up question, let's say for example the XML file that's sent has 3 tags as below.
Always a blank field...
October 2, 2011 at 4:41 am
Better not make the column's type [xml]. If you do make it an [xml] column, you will not be able to store a file that happens to be malformed; i.e....
October 2, 2011 at 3:13 am
I agree with that: storing the document itself is the best audit you can have. You may however still, next to storing the documents, read the orders from them to...
October 1, 2011 at 2:11 am
Can't you generate the xml, then read it to find the orders in there for the audit? If it's an audit you want to be sure the xml generation didn't...
September 30, 2011 at 11:41 am
You don't need to know the exact number of rows in the temp table to know you need to continue. Knowing there is at least one row is sufficient. So...
September 30, 2011 at 11:29 am
I think below query does what you want: return the columns from @stock, plus from all rows that have the same INDEX_CODE as that on the row and have an...
September 30, 2011 at 5:55 am
Can you give us some ddl and sample data so we can verify what we're doing? This code is very hard to read with all those generated names and aliases....
September 30, 2011 at 2:56 am
Apart from the T-SQL syntax errors that Drew gave you a solution for, you also seem to have a misconception on the use of namespaces in xml.
The xml document you...
September 29, 2011 at 9:43 am
Even if the serial values are unique within each table (for example by a key constraint), there may still be duplicates when trying to insert them. This is due to...
September 28, 2011 at 4:21 am
It's this link[/url] I'm talking about. If you do not supply the information we need, that will be an opportunity missed for you.
September 28, 2011 at 3:55 am
Viewing 15 posts - 226 through 240 (of 428 total)