No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky3VotesMicrosoft TechNet Wiki Guru - Winners for May
The results for May's TechNet Guru competition have been ... -
Sticky2VotesAre you a technology guru? Show us your solutions and become the T-SQL Guru for June 2013!!
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert, or authority on T-SQL? Show us your ... -
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 ... -
Sticky0VotesSolutions 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 ...
-
Unanswered0VotesSend email when certain Data is being inserted or changed in MS SQL Server table
I would like to know if possible and how I would achieve the following, whenever a new row is inserted into the following table (Contact) and the Confidential_flag Column has “Y” ... -
Unanswered0VotesQuery Question
Hello All, DECLARE @TEMP TABLE ( Calls INT, DT DATE ) INSERT INTO @TEMP VALUES ( 10, '2013-05-18' ... -
Unanswered0VotesGroup by, how to get individual data without grouping on it?
I have joined the job history tables creating a table with server_name varchar(25), job_name varchar(25) , time_of_execution datetime , duration int. There are about 20 servers ... -
Proposed0VotesIs this Possible?
I want to pass a table varible to a linked server to cut down on the I/O: SELECT * FROM OPENQUERY(ORDERSVR,'Select ... -
Answered0VotesQuery help needed
Hi I have a requirement and I am not sure how to go about it. I have a Shipment query Datatypes ticketnum ... -
Unanswered0VotesGetting Wrong values when updating the column based on Date Difference value is zero
Getting Wrong values when updating the column based on Date Difference value is zero. I am getting * value in the check number column. UPDATE #temp2 ... -
Unanswered0VotesHow to merge multiple columns
I'm currently working on building a database in SQL Server 2008R2 to hold UPC-A codes. The UPC codes are currently split into three different columns, the first one has the first six digits followed ... -
Answered1VotesSELECT record by nvarchar with LIKE when the criteria contains multiple whitespaces
I need to write a select query by nvarchar. For instance the query so far looks like this: SELECT * FROM Reservations.BlockResource WHERE Reason LIKE '%'+ @Reason+ ... -
Answered0VotesWhy SQL_Hungarian_CP1250_CI_AS is case sensitive ?
Hi, I have the following databaase : CREATE DATABASE Hungarian COLLATE SQL_Hungarian_CP1250_CI_AS USE ... -
Unanswered0VotesAppending text to a field that already contains text using TSQL
I want to append some text into a field that already contains text without overwriting what is already there. I want to do this using TSQL. Any help on how to do this would be ... -
Answered2VotesSQL Formatting Tool
Guys, Is there any good tool available to format the SQL Code. I have bunch of stored procedures and I want to do proper alignment and formatting of the code. I was wondering if ... -
Proposed0VotesSql statement with Case not working
'1/1/2013' AND (NOT (OrderInfo.SerialNumber LIKE N'WEB%'))) else (OrderInfo.orderdate > '1/1/2012' and < '5/1/2013') end ORDER BY ... -
Answered0VotesOptimization?? Too slow! Like Molassis!!!!
How can I optimize this? SELECT * FROM OPENQUERY(ORDERINFO,'Select * ... -
Unanswered0VotesHow to compare with Audit Table - Microsoft SQL Server 2000 - 8.00.2055
Hi, Here are two sample Tables. PLEASE NOTE: THESE ARE JUST SAMPLE TABLES CREATED TO SIMPLIFY THE QUESTION. I DID NOT ... -
Answered1VotesCounts by Time Interval
Using SQL 2008 R2 + SP 2 x64 on Windows Server 2008 R2 x64. I have a program that processes data from 10 PM to 8 AM each day. I want to get a count of how many ... -
Answered0VotesQuick SQL Sintax Help
So for reason I would rather not discuss I have to modify a really old asp page... They need it to add some simple data to a table in a SQL Server 2008 ... -
Proposed0Voteswrite sql to show data on rows and columns
Hi I am working on BI proj. wherein I want to write a SQL in such a way that it should show some attributes on rows and some on columns. Can we do that using ... -
Unanswered0VotesWork Assignment Optimization
Hi, I have a SQL database that I am developing to help manage resources working on Tasks. Each day there are new tasks that are unassigned and I am trying to write a stored proc to ... -
Answered1VotesOpenQuery Where Clause Error!!!
= @StartDate and EndDate - Items 1 to 20 of 64376 Next ›


