Search Results

Search found 16890 results on 676 pages for '2008 archive'.

Page 291/676 | < Previous Page | 287 288 289 290 291 292 293 294 295 296 297 298  | Next Page >

• Append Results from two queries and output as a single table.

  - by tHeSiD

  I have two queries that I have to run, I cannon join them But their resultant tables have the same structrure. For example I have select * from products where producttype=magazine select * from products where producttype = book I have to combine the result of these two queries, and then output it as one single result. I have to do this…

  Read the article

• What's the VS shortcut for type hierarchy?

  - by Abhijeet Kashnia

  What's the equivalent of eclipse's Ctrl+T for Visual Studio? Preferably no third party tools.

  Read the article

• Help with a query

  - by stackoverflowuser

  Hi Based on the following table ID Effort Name ------------------------- 1 1 A 2 1 A 3 8 A 4 10 B 5 4 B 6 1 B 7 10 C 8 3 C 9 30 C I want to check if the total effort against a name is less…

  Read the article

• Find a variable with a given value in VS2008

  - by Aaron

  I have an instance variable with several members, many of which have their own members and so on. Using the debugger and watch variables, I found a string variable with a specific value that I need by diving into this variable's members. However, after spending some time on other things and coming back to this, I am now unable to find where…

  Read the article

• What are your most-recommended Visual Studio preferences?

  - by Zack Peterson

  There are so many little options and settings within Microsoft Visual Studio. Which adjustments do you recommend to others?

  Read the article

• CLR: Multi Param Aggregate, Argument not in Final Output?

  - by OMG Ponies

  Why is my delimiter not appearing in the final output? It's initialized to be a comma, but I only get ~5 white spaces between each attribute using: SELECT [article_id] , dbo.GROUP_CONCAT(0, t.tag_name, ',') AS col FROM [AdventureWorks].[dbo].[ARTICLE_TAG_XREF] atx JOIN [AdventureWorks].[dbo].[TAGS] t ON t.tag_id =…

  Read the article

• Move SELECT to SQL Server side

  - by noober

  Hello all, I have an SQLCLR trigger. It contains a large and messy SELECT inside, with parts like: (CASE WHEN EXISTS(SELECT * FROM INSERTED I WHERE I.ID = R.ID) THEN '1' ELSE '0' END) AS IsUpdated -- Is selected row just added? as well as JOINs etc. I like to have the result as a single table with all included. Question 1. Can I…

  Read the article

• Sql server execute permission; failure to apply permissions

  - by WestDiscGolf

  I've just migrated from SQL2000 to SQL2008 and I have started getting an execute permission issue on a stored proc which uses sp_OACreate. The rest of the system works fine with the db login which has been setup and added to the database. I've tried: USE master GO GRANT EXEC ON sp_OACreate TO [dbuser] GO But this fails with the…

  Read the article

• How can i do re coding without assign null value?

  - by Phsika

  How can i do below without assign null value "Tex=null"? static void Main(string[] args) { FileInfo f = new FileInfo("C:/temp/Arungg.txt"); StreamWriter Tex; Tex = null; if (!f.Exists) { f.CreateText(); } else …

  Read the article

• Qt, Color Picker Dialog?

  - by high6

  Is there a color picker dialog for Qt like the following? Also it needs to have a OnColorChanged signal which is called when ever the selected color changes. I want to give a live preview when they are changing the colors, that is why. Using google I could only find this one that was a triangle in side of a circle and personally…

  Read the article

• Visual Studio IDE - how do you quickly find the implementation(s) of an interface's method?

  - by Jess

  Is there a quick way to find all of the implementations of, not references to, an interface's method/property/etc? Here's some sample code: public class SomeClass : IBaseClass { public Int32 GetInt() { return 1; } } public interface IBaseClass { public Int32 GetInt(); } public class SomeOtherClass { ISomeClass…

  Read the article

• Missing Status Bar in Visual Studio?

  - by Marcel

  Note: This question and answer is a full copy from Kelly Brownsbergers Blog. I do post it as a convenience to others. From time to time, my status bar disappears. I used to believe this was due to a botched install or add-in. I recently upgraded to Team System Test Edition, and my status bar again disappeared. For the last…

  Read the article

• sqlserver how to set job priority

  - by Buzz

  Is there any way to set one job priority higher then other, In my case there are two jobs those are working on same set of tables,first JOB-A which is running every 12 hr and other JOB-B is every 10 minutes , i think at some time when they run simultaneously JOB-B is getting in to deadlock and get failed, i google the topic…

  Read the article

• random number in VC++

  - by BillDickson

  int randomNumber = (double)rand() / (RAND_MAX + 1) * (10 - 0) + 0; is the code I'm using, it is getting a random number, but is getting the SAME random combination every time? Can anyone see what I'm doing wrong?

  Read the article

• CustomError not working properly

  - by IrfanRaza

  Hello friends, I am using following setting for customError. < customErrors mode="On" defaultRedirect="GenericErrorPage.aspx" < error statusCode="403" redirect="NoAccess.aspx" / < error statusCode="404" redirect="FileNotFound.aspx" / < /customErrors I have a folder "Admin" having access to…

  Read the article

• Recursive CTE with alternating tables

  - by SOfanatic

  I've created a SQL fiddle here. Basically, I have 3 tables BaseTable, Files, and a LinkingTable. The Files table has 3 columns: PK, BaseTableId, RecursiveId (ChildId). What I want to do is find all the children given a BaseTableId (i.e., ParentId). The tricky part is that the way the children are found works like…

  Read the article

• Can't get GetModuleFileNameA to work, keep getting error 'missing type specifier...'

  - by flavour404

  Hi, I am trying to use 'GetModuleFileNameA' but I keep getting the error 'c4430: missing type specifier - int assumed'. From reading the results from my google search I am guessing that it is from my use of NULL: char Filename[MAX_PATH]; //this is a char buffer GetModuleFileNameA(NULL, Filename,…

  Read the article

• What is the most effective and flexible way to generate combinations in TSQL?

  - by SDReyes

  What is the most effective and flexible way to generate combinations in TSQL? With 'Flexible', I mean you should be able to add easily combination rules. e.g.: to generate combinatories of 'n' elements, sorting, remove duplicates, get combinatories where each prize belongs to a different lottery,…

  Read the article

• Performance of inter-database query (between linked servers)

  - by Swoosh

  I have an import between 2 linked servers. I basically got to get the data from a multiple join into a table on my side. The current query is something like this: select a.* from db1.dbo.tbl1 a inner join db1.dbo.tbl2 on ... inner join db1.dbo.tbl3 on ... inner join…

  Read the article

• Visual Studio Colour Settings

  - by Ian

  I've got a custom colour set in Visual Studio and one of the colours when debugging is making things a bit of a misery. Unfortunately I can't figure out which one it is, and when going through and changing all the light background ones, it still remains. Can anyone point me in the right…

  Read the article

• asp:QueryStringParameter and empty query string parameter

  - by abatishchev

  I haveasp:GridView displaying client requests using asp:SqlDataSource. I want to limit displayed information by client: View.aspx has to display everything, View.aspx?client=1 has to display only requests from client ID #1. So I'm using <asp:QueryStringParameter Name="client"…

  Read the article

• How to insert values using Joins in asp.net stroed procedure?

  - by Samba Siva

  CREATE PROC [dbo].[K_HRM_Insert_VehicleAssign] @vehiclename varchar(50), @empname varchar(50), @updatedby varchar(50), @updatedon datetime as begin insert into K_MasterEmpDetails ME inner join K_HRM_Vehicle_Assign VA on VA.[empname+id] = ME.Firstname +' '+ME.Lastname+' -…

  Read the article

• Installing a custom project template with Visual Studio Installer project

  - by ulu

  Hi! I've created a custom project template, and now I need to deploy it together with my product (i.e., it should be installed by the same msi I use for the main installation). I'm using a Visual Studio Installer project. One option is to use a custom action and manually copy a…

  Read the article

• Lambdas in C++/CLI

  - by Xaver

  How to use lamda expressions in C++/CLI?

  Read the article

• help troubleshooting deadlocks in sql server database

  - by Makach

  I've got two database servers, (1) production (2) test on the production database I get frequent deadlocks and I'm trying to find out what is causing it. I take a backup of the database in production and restore it in test and when I perform the exact same scenario that…

  Read the article

< Previous Page | 287 288 289 290 291 292 293 294 295 296 297 298  | Next Page >