Viewing 15 posts - 1,861 through 1,875 (of 5,504 total)
My pleasure. 😀
But all the honor belongs to Jeff for posting this solution and continuously improving it.
As a side note: do you completely understand how it works and when you...
February 23, 2011 at 12:01 pm
please search this site for DelimitedSplit8K. It will point you to a function that will be much more efficient than your loop. The function mentioned above could be used as...
February 22, 2011 at 5:12 pm
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
Viewing 15 posts - 1,861 through 1,875 (of 5,504 total)