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 ...
-
Unanswered0VotesSql 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 ... -
Unanswered0VotesStrange behaviour in over (order by)...sql 2012
I noticed a strange behaviour when I make a rank in sql. This code create table #prove (nome nvarchar(10), abc int, abcd int, abcde int) insert into #prove ... -
Unanswered1VotesIgnore error row when update or insert ms sql server
10 hours to finish - But, if any row is error, i can ignore it and also catch the error. After that, I use a query like: update Table2 set T2.Column1 = ... -
Unanswered0VotesGroup Name on top of rows
my Output is: Life Sciences Agriculture Life ... -
Answered1VotesHelp to Find out the correct answer to the following query
Hi, I have two tables named customer and salesorder. In the customer table i have 1000 customers,Of which 900 customers ... -
Unanswered2VotesAverage for the last ten days repeated row by row
0,REVEN,0)) AS RICAVI FROM BERLIN GROUP BY QUA) SELECT QUA, COSTI-RICAVI as media FROM CTE I got: date and average 2013-03-12 ... -
Unanswered2VotesDATEDIFF II
Hello, Some question has already been answered here, but I'm still getting a hard time, maybe you could enlighten me... (First ... -
Unanswered0VotesHow to test query performance after Storage Upgrade/Storage Migration in Sql Server
Hello All, Could some body please guide me, how to test query performance or otherway's to check particular things that performance is ... -
Unanswered0VotesHow to create table dynamically and how to get dynamically pivot columns in sql server
Hi, i have two tables that is table1 and table2 table1 tables, select * from table1 idt mmid col1 col2 col3 ... -
Unanswered0VotesSQL server 2008R2 x86 (on Windows Server 2008R2x64) fails to update XLS using JET - conflict with ACE drivers?
Hi all, ISSUE An interesting (but annoying) quirk. When I link to an XLS (Excel 8.0) spreadsheet from a 32bit instance of SQL as a linked server I can read the ... -
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 ... -
Unanswered0Votes32 bit SQL Server 2008 (R1) on XP fails to make working linked server to XLSX spreadsheet.
Hi all, I have a SQL2008(R1) database that works in a variety of environments (including SQL2008R2 variations). Towards this end I decided to make a proc that would make setting up ... -
Unanswered0Votespls..help me to send email using batch mail
pls..any one help me to send email using batch file with oracle connectivity..i need urgent..... i don no abt batch file..so pls help me -
Unanswered0VotesDifferent power shell script result using XP_CMDSHELL
Hi, I'm using this simple sql script to execute the powershell script which will call a web service. exec xp_cmdshell 'powershell.exe ... -
Answered2Votesconcern about calling store procedure multiple times during pageload
hi all, i have a project developed using C#. all the label are stored in sql db table instead of hard code it in asp UI screen. this is because we need to support multi-languages ... -
Answered0VotesMultiple SQL CMD Instances
Hi, Is there any speed benifit to running multiple SQL CMD instances side by side? Lets take away locking, key constraints etc, and I have 2 independant ... -
Answered0VotesFullText search: I cannot get the thesaurus working. What am I doing wrong?
I use the following content for the "tsenu.xml" <XML ID="Microsoft Search Thesaurus"> <!-- Commented out (SQL Server ... -
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 ... -
Proposed0VotesCounting several specific rows (using where) in the same column
Hi everyone, SQL Server 2008 newbie here! The subject says it all really, I hope! I would like the count the number of rows in a column with a specific id, ... -
Proposed0VotesINDEX of column(s) in ORDER BY with OFFSET and FETCH
I am using SQL Server 2012 to try to implement efficient paging using OFFSET and FETCH. Here's some sample code: SELECT ID, Name, ... , ColumnZ FROM ... - Items 1 to 20 of 64359 Next ›


