Viewing 15 posts - 1,891 through 1,905 (of 2,452 total)
this may give you some ideas:
DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =
N'<head>' +
N'<style type="text/css">h2, body {font-family: Arial, verdana;} table{font-size:11px; border-collapse:collapse;} td{background-color:#F1F1F1; border:1px...
June 18, 2012 at 11:49 am
Methew (5/20/2012)
i do not know the internal structure(and i do not know how to know/check its internal structure)...i have this file GeoLiteCity.DAT.I am passing IP address of current user and...
May 20, 2012 at 8:12 am
J Livingston SQL (5/18/2012)
rjs123431 (5/17/2012)
We use sql server 2005 and 2008. I need to trace INSERTED,DELETED and UPDATED records in some tables in this manner.
- LogID (auto increment)
...
May 19, 2012 at 9:46 am
CELKO (5/18/2012)
Learn RDBMS and do this right.
what is the "right" way to do this?
there seems to be many ways of doing this
May 18, 2012 at 2:41 pm
rjs123431 (5/17/2012)
We use sql server 2005 and 2008. I need to trace INSERTED,DELETED and UPDATED records in some tables in this manner.
- LogID (auto increment)
- TableName
-...
May 18, 2012 at 2:05 pm
SQL_Surfer (3/14/2012)
March 14, 2012 at 5:04 pm
ok...I can see what you are trying to achieve....but why the increment by 2?
what is the business case here...........??
just curious
March 14, 2012 at 3:58 pm
dwain.c (3/12/2012)
I like being contrary so I have to ask, why are you using a calendar table?
cos of this q from Jeff
Jeff Moden (3/10/2012)
March 12, 2012 at 2:23 am
Hi neol
if you are able, then please...
provide "create table" scripts
example data
what indexes you have
the query you are actually running
execution plans...actual preferable
the results you are expecting
if the above is...
March 11, 2012 at 3:22 pm
aitchkcandoo (3/11/2012)
March 11, 2012 at 12:51 pm
for any one interested...here is a quickly mocked up Calendar table and resultant code to answer OP's original question.....by using the calendar table approach.
Obviously without pre populating the Calendar...
March 11, 2012 at 12:32 pm
aitchkcandoo (3/11/2012)
I am asking because I want to know when does one decide to move to server side analytical engine and away from Excel.
suggestion
provide a scenario where you are unclear...
March 11, 2012 at 12:09 pm
Jeff Moden (3/10/2012)
March 11, 2012 at 7:33 am
you posted this question in Analysis service forum...so can I assume you are asking about SSAS v Excel...is this correct?
Have you used SSAS..or for that matter a SQL database?
what experience...
March 11, 2012 at 3:48 am
Viewing 15 posts - 1,891 through 1,905 (of 2,452 total)