Viewing 15 posts - 106 through 120 (of 599 total)
Combine Insert and Select into one call?? But of course - all the time. It's nothing new.
We've been doing that in ASP.NET ever since 2005 when we started working with...
November 12, 2014 at 1:19 am
I would get a windows group created with these users in it and then give that group read only permissions on the cube. I give the cube permissions via management...
November 3, 2014 at 1:51 am
A regular theme for fancy dress night at sailing national championships is to dress as the name of your boat. If we ever go I plan to dress as Sir...
October 31, 2014 at 7:59 am
It's so automatic that I had to think hard as to whether I'm mis-reading something in your post, but this is what we do to deploy reports.
We set up project...
October 30, 2014 at 9:17 am
Have a look at the TableDiff utility which comes with SQL Server - C:\Program Files\Microsoft SQL Server\100\COM\tablediff.exe is where mine is located.
You'll probably have to Google for the instructions but...
October 27, 2014 at 2:47 am
Notepad++ and MS Office at work. At home it's Miicrosoft's OneNote using OneDrive to sync seamlessly between desktop, laptop and windows phone. I can scan or find on the web...
October 27, 2014 at 2:23 am
katland226 you might hate stored procedures now and I hope one day you will understand them and favour them in your development as I do, but I also hope you...
October 23, 2014 at 3:33 am
Many people don't realise that you can just open up management studio (sql server 2008 onwards), select your server, select databases and right click the column headings to choose which...
October 23, 2014 at 3:12 am
I see only "JOIN" so that's INNER JOINs on all your tables i.e. if one is missing a record then nothing returns for that whole output row.
I would use...
October 15, 2014 at 3:45 am
convert(datetime, substring(replace(MANUFACTURED_DATE,'/',''),5,2) +
substring(replace(MANUFACTURED_DATE,'/',''),3,2) + substring(replace(MANUFACTURED_DATE,'/',''),1,2),112)
That's just so unnecessary - read the Books online entry for convert. (tip: highlight the word convert in your query in management studio and press...
October 9, 2014 at 1:07 am
Ah, you need to learn the tool controls. It's an "easy when you know how" thing.
Above those three in the report data window is a New dropdown.
Choose new datasource....
October 6, 2014 at 1:58 am
why not just back it up on 2005 and restore it on 2008?
create any sql logins on the 2008 server and relink the orphaned users
and while you're at it...
October 6, 2014 at 1:47 am
crussell-931424 (10/2/2014)
Hearing the word Final makes me realize how far behind I really am.
We're still trying to UPgrade databases onto SQL Server 2008!
October 3, 2014 at 1:30 am
We're still concentrating on getting everything up to 2008 and consolidating servers onto windows 2008R2 with plenty of virtualisation.
I don't think 2014 has had UK government security sign off...
September 19, 2014 at 4:42 am
I've rewritten some of our report writers' cursor queries lately, mainly thanks to going on Itzik Ben-Gan's Advanced T-SQL course last year and reading his Inside SQL Server 2008 T-SQL...
September 19, 2014 at 1:22 am
Viewing 15 posts - 106 through 120 (of 599 total)