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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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)
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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
-...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 18, 2012 at 2:05 pm
SQL_Surfer (3/14/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 11, 2012 at 3:22 pm
aitchkcandoo (3/11/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 11, 2012 at 12:09 pm
Jeff Moden (3/10/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 11, 2012 at 3:48 am
http://lmgtfy.com/?q=how+many+rows+can+I+have+in+an+excel+spreadsheet
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 11, 2012 at 3:22 am
Viewing 15 posts - 1,891 through 1,905 (of 2,452 total)