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 ...
-
Proposed0VotesMDF and NDF files size is growing
We are using BODS for ETL. One of the drive size is coming close to the limit in BO server.mdf and ndf staging ,dwh log files are stored in this drive. Is there ... -
Unanswered0Votesgenerate more traffic
Dear experts, tell me how could i have more traffic to this site cetatti.com -
Unanswered0VotesPivot Query help needed
Hi all, select Group_Age,Group_Class, sum(No_of_OD_Claims)No_of_OD_Claims, sum(No_of_tp_Claims)No_of_tp_Claims from ... -
Unanswered0Votessql query needed
i need few queries if you guys can help me out as i am doing some auditing task manually. 1.query that list all user in specific server with restore DB ... -
Discussion0VotesI want AVG of a query
='20130501' AND SMD_ODOC_DT<='20130531' AND SMD_STTS='F' AND ... -
Unanswered0VotesQuery Question
Hello All, DECLARE @TEMP TABLE ( Calls INT, DT DATE ) INSERT INTO @TEMP VALUES ( 10, '2013-05-18' ... -
Unanswered0VotesAdd records where no record is captured (hospital data)
Hi, I am going to start by explaining the problem, if anyone has run into this type of problem then any advise would be appreciated. Our hospital system captures ... -
Unanswered0Voteseasier way to pivoting the data
Hi, I have a table with currently 23 million records and it is keep increasing. Now I have to do pivoting on prog_nam, so for n number of users are there and each ... -
Answered0VotesMS SQL script
Hi , i am using a TSQL script to backup my DBs , i am running it from MS SQL 2005 i also am running a "SQL Server Analysis Services Commands" script ... -
Proposed1VotesAppending 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 ... -
Unanswered0VotesDealing with Auditing data - is there a cleaner way?
'20130601' GROUP BY at.Transaction_ID, at.Table_Name, at.[Action], ... -
Unanswered0VotesStrictly Academic: How do I best explain in mathematical terms what this does?
Techies-- I want to be able to express how I've matched data from 2 separate tables; reporting on the action in a single line in mathematical terms-- its been 20+ years since I've ... -
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” ... -
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+ ... - Items 1 to 20 of 64382 Next ›


