No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0Votes
POSTING 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 | 36970 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 | 55949 Views | Arnie Rowland - Saturday, April 12, 2008 2:52 PM
-
Unanswered0Votes
2 SQL Server Machine has two different outcome for record locking
hi, i have 2 sql server. server 1 is running sql server express. server 2 is running sql server 2012 BI edition. when i try to use rowlock hints on my server 1, ...1 Replies | 53 Views | Richard GYC - 1 hour 27 minutes ago | Last Reply Srinivasan Ram - 1 hour 19 minutes ago -
Unanswered0Votes
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 ...4 Replies | 72 Views | duanewilson - 2 hours 49 minutes ago | Last Reply Nissan K George - 1 hour 44 minutes ago -
Proposed0Votes
Query XML Column
Hi, I'm using SQL SERVER 2012 and need some help querying an XML field. I've read much of the documentation and still can't get it. The RegHrs(text, ...13 Replies | 153 Views | Donna Lee - Wednesday, July 03, 2013 3:56 AM | Last Reply Naomi N - 1 hour 47 minutes ago -
Unanswered0Votes
Function to read property values from DefaultProfileProvider
Hello, I wanted to create a function that reads the value for a given property for a certain user stored by the DefaultProfileProvider. The data is stored ...2 Replies | 79 Views | sudinami - 7 hours 55 minutes ago | Last Reply Tom Cooper - 2 hours 43 minutes ago -
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 ...7 Replies | 152 Views | Ray1127 - Tuesday, July 02, 2013 7:54 PM | Last Reply Allen Li - MSFT - 3 hours 13 minutes ago -
Unanswered0Votes
Email Formatting GROUP BY Query Results
How can I get sp_send_dbmail send it nicely formatted? Thanks. SELECT Year=Year(OrderDate), ...1 Replies | 65 Views | Kalman Toth - 7 hours 13 minutes ago | Last Reply rksqldba - 4 hours 11 minutes ago -
Unanswered0Votes
t-sql question
I have the following values in a table ...6 Replies | 120 Views | sqldev1 - 10 hours 54 minutes ago | Last Reply Sarat Babu (SS) - 4 hours 45 minutes ago -
Unanswered0Votes
Views and Instead of Update Trigger Limitation. Why?
I am attempting to use views and Instead of triggers to insert, update and delete rows from THE table that is exposed through a view. In my application, the views provide a ...3 Replies | 4082 Views | KCH - Wednesday, September 19, 2007 5:08 PM | Last Reply Kibby26 - 6 hours 24 minutes ago -
Answered0Votes
Query with sub query help
0 ORDER BY unpd_bal DESC) AND unpd_bal > ...10 Replies | 120 Views | rolfhersh - 14 hours 17 minutes ago | Last Reply --CELKO-- - 7 hours 12 minutes ago -
Unanswered0Votes
Error using "Insert into" where the source table in ACCESS has multi-valued datafield
I'm running a query in ACCESS database that inserts rows from a local ACCESS db table to a linked SQL table. The source table that resides in ACCESS database contains multi-valued data fields. This is ... -
Unanswered0Votes
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 ...11 Replies | 179 Views | ADS97_ - Tuesday, July 02, 2013 6:47 PM | Last Reply Naomi N - 8 hours 28 minutes ago -
Answered0Votes
added ID is always on the top.
I added two records into two tables with relationship. table 1: NameId, Date, col3... (NameId has date type integer) table 2 NameId, Date, ...8 Replies | 291 Views | 98108 - Tuesday, July 02, 2013 3:43 PM | Last Reply 98108 - 8 hours 40 minutes ago -
Unanswered0Votes
When I catch a deadlock error inside a procedure, can I see what the other transaction was?
Im wrapping some code that has resulted a deadlock situation in the past, and the code that was executing was part of a transaction that was the victim in a deadlock situation. The procedure was ...2 Replies | 68 Views | shiftbit - 15 hours 18 minutes ago | Last Reply JRStern - 10 hours 21 minutes ago -
Unanswered0Votes
Capturing errors in job steps that are actually in other procedures
procedure 2 > procedure 3(error happens here) When I run the job and log to a file and/or a table (msdb.sysjobstepslogs), I only get the error message, but not the procedure ...1 Replies | 41 Views | shiftbit - 10 hours 33 minutes ago | Last Reply shiftbit - 10 hours 25 minutes ago -
Unanswered0Votes
add new column with default value
hi sorry but i am not able to see any thread that i have posted in my activities, please suggest me what to do. i am not able to find my ...3 Replies | 114 Views | tsql_new - 11 hours 51 minutes ago | Last Reply Jingyang Li - 10 hours 52 minutes ago -
Proposed0Votes
Job fails from warnings? Null value is eliminated by an aggregate
Executed as user: ... ...SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. The step ...7 Replies | 136 Views | shiftbit - Tuesday, July 02, 2013 9:07 PM | Last Reply shiftbit - 10 hours 57 minutes ago -
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 ...0 Replies | 50 Views | Naomi N - 11 hours 11 minutes ago -
Unanswered0Votes
syntax for loading fixed width file into sql server
Hi, USING SSMS I want to load fixed width file to my sql server table. I do remeber the process but forgot the syntax. Can anyone share with me that ...3 Replies | 64 Views | Murali dhar - 11 hours 37 minutes ago | Last Reply Murali dhar - 11 hours 18 minutes ago -
Proposed0Votes
Split row to multiple rows based on dates overlapping (SQL split dates)
BOOKING_START) GO INSERT INTO [RESOURCE] (RESOURCE_ID, RESOURCE_NAME) VALUES (1, 'John Smith') INSERT INTO [RESOURCE] (RESOURCE_ID, RESOURCE_NAME) VALUES (2, 'Mary ...5 Replies | 256 Views | Manc4Ever - Monday, June 10, 2013 2:31 PM | Last Reply Manc4Ever - 12 hours 6 minutes ago -
Answered0Votes
T-sql query + not in
Hi, I need a sql query with except condition. Here is the ...8 Replies | 88 Views | Spunny - 13 hours 19 minutes ago | Last Reply Spunny - 12 hours 44 minutes ago - Items 1 to 20 of 64691 Next ›