Viewing 15 posts - 8,656 through 8,670 (of 13,469 total)
Ritesh glad I could help, and thank you very much for the positive feedback. It's nice to know when something works well for someone.
September 30, 2010 at 3:46 am
i think you want to avoid giving the db_datareader role in database 1.
the two roles are additive..meaning db_datareader can read EVERY view and table...so adding them to a "restricted" role...
September 29, 2010 at 9:36 pm
i hope i can explain this well...
a correlated sub query is where a column from the OUTER query is referenced in the sub query to limit the results:
SELECT
...
September 29, 2010 at 9:28 pm
here's one example using a CTE Tally Table:
with Tally as (
SELECT TOP 11000 --only need ten digits for this job, though
ROW_NUMBER() OVER...
September 29, 2010 at 9:18 pm
well, there's a few things going all wrong here;
the first one is such a large report ....three million rows.you've lost sight of what an HTML report is supposed to do.
it's...
September 29, 2010 at 8:48 pm
it's actually pretty easy;
INSERT INTO Letter_C (list of columns)
SELECT (same list of columns,same order) FROM #Temp
EXCEPT
SELECT same list of columns,same order FROM Letter_C
this will find all the...
September 29, 2010 at 7:21 pm
well all you have to do is get the csv file into a table or linked server so you can use a set based operation against it.
i do not see...
September 29, 2010 at 5:03 pm
could it be that one machine is connecting to , say, the PRODUCTION database and the other connecting to a older copy of that same DB, but hosted on a...
September 29, 2010 at 1:00 pm
you've definitely got some data that cannot be converted to int, ie empty string or 'N/a' that someone data entered;
I'd suggest changing the join and the WHERE statement as...
September 29, 2010 at 12:48 pm
there's a great article on SimpleTalk on the subject.
it's got examples of doing it two ways, via opendatasource and also Excel Automation via sp_OACreate and stuff;
this article is doing it...
September 29, 2010 at 9:32 am
man this is really interesting, but the rabbit hole is getting deeper and deeper.
if you send an email via sp_send_mail with SECURE in the subject, does your Exchange Server encrypt...
September 29, 2010 at 9:23 am
Micrsofot has a couple of Migration Assistant tools to help you migrate Oracle to SQL Server (and another one for MYSQL to SQL Server)
http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx
another alternative, if it is just a...
September 29, 2010 at 9:05 am
the critical part is adding the WHERE statement...some of your data does not contain a comma...
you want to exclude those items
--items with the offending command and extra data
SELECT LEFT(NAME,CHARINDEX(',',NAME)-1 )
FROM...
September 29, 2010 at 8:50 am
here's an example of what Wayne refered to:
With MySampleData as
(
SELECT 'Support Centres , Miscellaneous SC' As TheName UNION ALL
SELECT 'Support Centres , Care of tracey Whitehall' UNION ALL
SELECT 'Support Centres...
September 29, 2010 at 8:28 am
i believe the calculated column has to be dropped and recreated as a new calculated column.
i just tried this as a proof of concept, and I get a syntax error...
September 29, 2010 at 5:34 am
Viewing 15 posts - 8,656 through 8,670 (of 13,469 total)