No announcements
Forums [ view all ]
-
Select allSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server Data WarehousingSQL Server SearchSQL Server SpatialSQL Server Samples and Community ProjectsMicrosoft StreamInsightDatabase DesignSQL Server MigrationSQL Server Master Data ServicesSQL Server Application and Multi-Server ManagementSQL Server PowerPivot for ExcelSQL Server PowerPivot for SharePointSQL Server ManageabilitySQL Server Distributed ReplaySQL Server Data Quality ServicesMicrosoft HDInsight (Windows and Windows Azure)SQL Server Data Tools
-
Select allAnnouncements for all ForumsForums Redesign - Q&A / DiscussionsWhere is the Forum For…?Forums Issues (not product support)Suggestions and Feedback for the ForumsOff-Topic Posts (Do Not Post Here)MSDN and TechNet Profile and Recognition System Discussions
-
Select allVisual C#Visual BasicVisual C++C++ Standards, Extensions, and InteropParallel Computing in C++ and Native CodeVisual F#Microsoft "Roslyn" CTP
-
Select allVisual Studio General QuestionsVisual Studio Setup and InstallationVisual Studio ExtensibilityVisual Studio Tools for Office (VSTO)Visual Studio EditorMSBuildVisual Studio LightSwitch ExtensibilityVisual Studio LightSwitch - General QuestionsLightSwitch HTML Client PreviewVisual Studio Visualization & Modeling ToolsTesting with Visual Studio Test Manager (MTM)Test Tools in Visual Studio 2010 and 2012Visual Studio Unit TestingVisual Studio Diagnostics (Debugger, Profiler, IntelliTrace)Visual Studio Tools for Applications (VSTA)
-
Select allUI Design for Windows Store appsTailoring your Windows Store app for hardware and devicesBuilding Windows Store apps with HTML5/JavaScriptBuilding Windows Store apps with C++Building Windows Store apps with C# or VBBuilding Windows Store games with DirectXTools for Windows Store appsPublishing Windows Store apps
-
Select allApplication Compatibility for Windows Desktop DevelopmentDeveloping Windows Desktop Applications with Power ManagementWindows Desktop Development for Accessibility and AutomationDirectShow DevelopmentGeneral Windows Desktop Development IssuesWindows Desktop Development for Ink, Touch, and Tablet PCMedia Foundation Development for Windows DesktopMicrosoft Message Queuing (MSMQ)Network MonitorWindows Desktop Optical Platform DiscussionPeer-to-Peer Networking for Windows DesktopApplication Security for Windows DesktopWindows Desktop Sidebar Gadget DevelopmentUser Interface development for Windows DesktopVisual C++Windows Desktop DebuggingWindows Desktop Search DevelopmentWindows Desktop Search HelpWindows Filtering Platform (WFP)Windows Imaging Component (WIC)Windows Desktop Perfmon and Diagnostic toolsWindows Desktop Pro-Audio Application DevelopmentWindows Desktop SDKWindows Desktop Web Services API (webservices.dll)Windows Desktop Winsock Kernel (WSK)Windows Hardware WDK and Driver DevelopmentDevelopment with the Windows Sensor and Location PlatformWindows Desktop Ribbon DevelopmentWindows Hardware Testing and CertificationC++ Standards, Extensions, and InteropMessage Analyzer
-
Select allDeveloping for Windows PhoneTools for Windows Phone developmentShare your "How To" samplesPush NotificationsIn-App AdvertisingMango Update (Archived)Expression Blend for Windows Phone
-
Select allDeveloping Apps for Office 2013General Office DevelopmentAccess for DevelopersExcel for DevelopersOutlook for DevelopersWord for DevelopersOpen XML Format SDKVisual Studio Tools for Office (VSTO)
-
Select allWindows Azure DevelopmentWindows Azure Troubleshooting, Diagnostics & LoggingWindows Azure Storage, CDN and CachingWindows Azure SQL DatabaseConnectivity and Messaging - Windows AzureManaging Services on Windows AzureSecurity for Windows AzureWindows Azure Purchasing, Pricing & BillingWorkflow Manager 1.0Service Bus 1.0Windows Azure Active DirectoryWindows Azure Active AuthenticationWindows Azure Media ServicesWindows Azure BizTalk ServicesWindows Azure Virtual NetworkWindows Azure Virtual MachinesWindows Azure Pack
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0VotesPOSTING TIPS - source code, screen images, details within...
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you want to show us what you see on ...2 Replies | 37066 Views | Phil Brammer - Tuesday, December 01, 2009 10:19 PM | Last Reply Ed Price - MSFT - Monday, May 20, 2013 2:38 PM
-
Sticky0Votes
Solutions to Common T-SQL Problems
The Volunteer Moderators andAnswerers who support the Microsoft MSDN SQL Server Forums have created a Wiki to present Solutions to Common T-SQL Problems. Check here to see if ...0 Replies | 56047 Views | Arnie Rowland - Saturday, April 12, 2008 2:52 PM
-
Proposed0Votes
Could I do this with less code?
create table #jim (name varchar(100), createdon datetime) -- drop table #jim create table #jim2 (name varchar(100), createdon datetime) -- drop ...6 Replies | 207 Views | James R Traub - Friday, July 05, 2013 11:27 PM | Last Reply Vedran Kesegic - 1 hour 34 minutes ago -
Unanswered0Votes
Extract Values from XML column of SQL
Hi, I have a column named "XMLColumnwhich" in a Table named "demandRequest"contains an XML as follows <RequestEntity ...1 Replies | 72 Views | Stick.Hello - 3 hours 31 minutes ago | Last Reply Dan Guzman - 3 hours 6 minutes ago -
Answered1Votes
SQL udf returns incorrect value
I have a UDF that returns the number of hours worked in a day from ...3 Replies | 81 Views | DeanSanderson - 5 hours 0 minutes ago | Last Reply Duane Dicks - 4 hours 40 minutes ago -
Unanswered2Votes
Ascii table in SQL
create table #ASCII(id int, a char(1)) declare @x INT set @x=0 while @x2 Replies | 97 Views | Bill M. Geronatsios - 9 hours 9 minutes ago | Last Reply Dan Guzman - 6 hours 53 minutes ago -
Proposed0Votes
How to delete rows not in all 3 tables
How do I write a query to delete all the rows in all 3 tables that do not match values in the other tables so all 3 tables have the same values for X in them and the same number of ...15 Replies | 326 Views | duanewilson - Thursday, July 04, 2013 2:37 AM | Last Reply --CELKO-- - 8 hours 5 minutes ago -
Answered0Votes
Distinct in select query
Hi, I have a table with two columns. Table:Station column:Bmu , Cmu Bmu/Cmu 6/ ...2 Replies | 87 Views | syed javid ali - 10 hours 24 minutes ago | Last Reply syed javid ali - 9 hours 49 minutes ago -
Answered1Votes
get the day from date value in SQL Server
Hello, I want to know how can I (in sql server) get the day of week(eg Mon, Tue, Wed, etc) when a specific date is being given to the stored ...5 Replies | 62814 Views | Marais van Zyl - Friday, May 11, 2007 10:53 AM | Last Reply Salahuddin Quazi - 15 hours 53 minutes ago -
Unanswered0Votes
VBscript - Parametrized SQL Insert Statement (CM11874)
Good day all, I need to create a VBscript to perform the following: Gather the Supplier Name information from the Company DB, using a Stored ...1 Replies | 152 Views | GregoryLock - Friday, July 05, 2013 4:35 PM | Last Reply Jesús López - 16 hours 12 minutes ago -
Answered1Votes
Getting Previous Date In a new row
I have a task to achieve. I am sure it would be simple but i am confused...Here is following how i need data in a new column name "RECORD END DATE" ID EmpID ...4 Replies | 235 Views | Anji1407 - Friday, July 05, 2013 7:57 PM | Last Reply Anji1407 - Friday, July 05, 2013 9:03 PM -
Proposed0Votes
cannot set the result of a select statement to a variable : Select statements included within a function cannot return data to a client.
I am trying to set a User function to get alphas, Betas and R2 from a linear regression within sql. I can get the data through the select statement, but it fails to register as a ...3 Replies | 160 Views | Upsydian - Friday, July 05, 2013 4:54 PM | Last Reply Tom Groszko - Friday, July 05, 2013 8:12 PM -
Proposed0Votes
Returning 0 when no records exist in a sql query
How can I return a 0 when no records exists in an ms sql query? I'm unable to use ISNULL or COALEASE functions since no rows are being returned at ...14 Replies | 260 Views | ADS97_ - Tuesday, July 02, 2013 6:47 PM | Last Reply Naomi N - Friday, July 05, 2013 7:30 PM -
Proposed2Votes
Insert into table A and Update Table B (Identity_ID)
Hello , I am trying to do some thing like this, Insert into Table_A which has Identity Column , and then update ...6 Replies | 238 Views | SQLServer2k8 - Wednesday, June 26, 2013 4:47 PM | Last Reply Kalman Toth - Friday, July 05, 2013 6:37 PM -
Answered0Votes
How to get previous month data?
Hi, In my SP, I am having a variable which is @As_Date varchar(10) and it is holding date value (MM/DD/YYYY format) Now I want to ahieve the following ...3 Replies | 152 Views | UltraDev - Friday, July 05, 2013 8:52 AM | Last Reply --CELKO-- - Friday, July 05, 2013 6:35 PM -
Answered0Votes
How to subtract 1 from variable which holds date (like 12/31/2013)?
Hi, Can you please advise how do I subtract some number from the variable @Var which is holding some date value (MM/DD/YYYY format) I ...8 Replies | 162 Views | UltraDev - Friday, July 05, 2013 6:39 AM | Last Reply --CELKO-- - Friday, July 05, 2013 6:27 PM -
Proposed0Votes
How to display only 'full' months
Hello, I am looking for some help on the following: How to write a query that displays the result in two columns: Column 1 should contain a sum of all 'completed' ...5 Replies | 167 Views | SPEHE - Thursday, July 04, 2013 11:10 AM | Last Reply --CELKO-- - Friday, July 05, 2013 6:19 PM -
Proposed0Votes
TSQL-UDF-Function Help
Hi Experts , I have a requirement where I have to create a FUNCTION Where I could Pass Two Parameter 1)ColumnName 2)Table Name ...18 Replies | 358 Views | Rihan8585 - Thursday, July 04, 2013 8:48 AM | Last Reply --CELKO-- - Friday, July 05, 2013 5:51 PM -
Unanswered0Votes
Dealing with text, ntext, image pointer problem from VFP
Hi everybody, I had the similar problem before and even documented it in this blog post Dealing with the "The text, ntext, or image pointer value ...2 Replies | 137 Views | Naomi N - Wednesday, July 03, 2013 6:15 PM | Last Reply Naomi N - Friday, July 05, 2013 5:30 PM -
Answered0Votes
sql select query for maximum occurance
Hi, I have a number column , in that i have many repeated numbers. I want to display which number had occured maximum number of times and its allied columns by using a ...12 Replies | 186 Views | syed javid ali - Friday, July 05, 2013 11:37 AM | Last Reply Hunchback - Friday, July 05, 2013 5:28 PM -
Proposed0Votes
Group By Question
I work at a Medical Group which deals with 30 different health plans. Our issue is that Membership data comes from the health plans and populates our Database If an Employer offers multiple ...8 Replies | 242 Views | Ray1127 - Tuesday, July 02, 2013 7:54 PM | Last Reply Ray1127 - Friday, July 05, 2013 4:32 PM -
Unanswered0Votes
T-SQL: Set Value of Variable based on subquery result in a Update Trigger
I'm having difficulty figuring out how to do this. I'm trying to use an Update Trigger to write cumulative values from all records in two fields in the udEEOTrackingHours table to another ...2 Replies | 139 Views | ConstPM - Thursday, July 04, 2013 7:14 PM | Last Reply --CELKO-- - Friday, July 05, 2013 3:59 PM - Items 1 to 20 of 64732 Next ›
