Viewing 15 posts - 1,861 through 1,875 (of 5,502 total)
This thread has a similar requirement.
I posted a "quirky update" over there you might be able to modify.
Edit: Craig, you beat me to it. Again.
February 22, 2011 at 3:36 pm
gemni7 (2/22/2011)
the article you mentioned is a long but very informative, i really need to understand this... thanks for mentioning this...
February 22, 2011 at 3:27 pm
As an alternative to the PIVOT syntax you could have a look at the CrossTab and DynamicCrossTab article referenced in my signature.
It's not as easy as using Excel, but Excel...
February 22, 2011 at 2:40 pm
Something like this?
(Please note the rows are not ordered as your expected output since your original query doesn't include an ORDER BY)
SELECT
fee_portion, fee_percent, settle_date, fee_atty, manager, primary_attorney,
[Settle Amount]...
February 22, 2011 at 2:30 pm
All I could come up with is using the "Quirky Update" method:
You'd need to add another column to your table or copy the data into a temp table if you're...
February 22, 2011 at 2:15 pm
Jack Corbett (2/22/2011)
I have not. My opinion is that if you need to protect the code, and if it is really proprietary, it belongs in the business layer, not...
February 22, 2011 at 1:06 pm
I would use SSIS to store the CSV list into a staging table with a single column.
Then I would call a sproc with a fast split string function (e.g. DelimitedSplit8K)...
February 22, 2011 at 1:01 pm
Search this site for "concatenate FOR XML PATH".
February 22, 2011 at 11:59 am
Based on your sample data there are no consecutive rows for the sensorID in question with the required 5min gap.
I think it would help a lot if you could post...
February 22, 2011 at 11:52 am
Jeff Moden (2/21/2011)
...I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin folk resluss en tha lak.
Here's my ESL...
February 22, 2011 at 11:39 am
sdffdfad faadffad (2/22/2011)
February 22, 2011 at 10:48 am
tt-615680 (2/22/2011)
LutzM (2/21/2011)
Your expected result and the "sample data" provided so far don't seem to...
February 22, 2011 at 10:31 am
oconnor_dp (2/22/2011)
Try this example:http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/69b87bea-a943-4e53-8bfc-6a5e9213c2f4
Please mark as answer if you find it helpful.
Is there any specific reason for posting a solution on another website for a question asked here??
February 22, 2011 at 10:26 am
Darundo (2/21/2011)
...Any suggestion? Or additional information you need please let me know
Please provide table definition, sample data and expected results based on those sample.
February 21, 2011 at 2:15 pm
AJ-636201 (2/21/2011)
Hey Thanks Creig,So such a query can not be improved, there will always be an index scan.
So i think i got my answer:crying:
Thanks
There is (at least) one option left:
You...
February 21, 2011 at 1:02 pm
Viewing 15 posts - 1,861 through 1,875 (of 5,502 total)