No announcements
-
1 VotesWho will be announced the next Microsoft TechNet Guru? Read more about September 2017 competition
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...Sticky | 1 Replies | 221 Views | Created by [Kamlesh Kumar] - Friday, September 01, 2017 9:58 AM | Last reply by [Kamlesh Kumar] - Tuesday, September 19, 2017 8:41 PM
-
0 Votes
POSTING TIPS - Code, Images, Hyperlinks, Details
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're asking for ...
-
0 Votes
CONTAINSTABLE does not respond
Hi, When trying to search for a text like "1.2.3.4" using the CONTAINSTABLE function, there seems to be no response and it keeps on loading and sql memory gets ...Unanswered | 2 Replies | 44 Views | Created by Navinchander J K - 16 hours 42 minutes ago | Last reply by Xi Jin - a few seconds ago -
0 Votes
Transpose Table part of a stored proc
Hello again! This time I am trying to transpose the following table... CREATE TABLE [SurveyInterface].[tblSUFGenericCounts]( [ReferencePeriod] ...Proposed | 3 Replies | 45 Views | Created by MyleneC - 4 hours 53 minutes ago | Last reply by S Kumar Dubey - 48 minutes ago -
0 Votes
Determine if job executed as part of schedule
Hi All, As it says on the tin, is there any way to determine if a job has been executed as part of a schedule or someone manually invoked the ...Unanswered | 1 Replies | 44 Views | Created by RyanAB - 5 hours 52 minutes ago | Last reply by Vivek Janakiraman - 2 hours 3 minutes ago -
0 Votes
Query advise
Hi I have these two queries to bring up respect IDs; SELECT ID FROM SetupOrderStatus WHERE (OrderStatus = ...Unanswered | 4 Replies | 56 Views | Created by Y a h y a - 5 hours 34 minutes ago | Last reply by RyanAB - 3 hours 11 minutes ago -
0 Votes
Needing Help with Creating a New Stored Procedure to Interact with a Home Health Software application
I'm working on an SP dealing with an Application at work; I will try to do my best in describing what the SP should accomplish: When ...Unanswered | 3 Replies | 91 Views | Created by DSteele41 - 10 hours 48 minutes ago | Last reply by DSteele41 - 3 hours 41 minutes ago -
0 Votes
Dynamic sql
Hi there, I am keeping on getting the error below when trying to execute the embedded SQL. Any help would be appreciated Msg 214, Level 16, State 3, Procedure ...Unanswered | 2 Replies | 34 Views | Created by Tshindaye - 6 hours 12 minutes ago | Last reply by Erland Sommarskog - 5 hours 0 minutes ago -
2 Votes
Pleas help! - Passing the values inside the query and then executing the query with a UNION
Hi, I have one table with all the table names. Eg: #TableDetails Create table ...Proposed | 5 Replies | 63 Views | Created by Manesar - 11 hours 29 minutes ago | Last reply by Guoxiong - 5 hours 23 minutes ago -
0 Votes
help with Pivot and group by
I have records in table where I need to know count of customers who have opted for various promotions. Output : Travel_flag ...Proposed | 2 Replies | 48 Views | Created by vishal.... _ - 6 hours 51 minutes ago | Last reply by vishal.... _ - 6 hours 27 minutes ago -
3 Votes
Help in update query please
Hi - Some dates are NULL in Sysdate column. Currently Sysdate has only one row with date value and others are NULL. How I can copy same date value in Sysdate column for all others sysdate column ...Answered | 4 Replies | 37 Views | Created by Kevin Ruth - 7 hours 59 minutes ago | Last reply by Kevin Ruth - 7 hours 41 minutes ago -
0 Votes
multiplying next column and subtracting with rows
Hi everyone, I am facing one problem where i am not getting how to multiply column to get output using sql query. below is the example given ...Unanswered | 7 Replies | 62 Views | Created by Ajay Singh Rawat - 12 hours 52 minutes ago | Last reply by Jingyang Li - 8 hours 25 minutes ago -
0 Votes
SQL query to find the number of OSD(task sequence) builds in last 30 days
Hi, I am looking for some sort of SQL query which would give me the list of machines which have been build using OS Task sequence in the last 30 days. or, may be ...Unanswered | 4 Replies | 53 Views | Created by Mark 15 - 13 hours 39 minutes ago | Last reply by karun_r - 9 hours 34 minutes ago -
2 Votes
length of nvarchar column in system tables
Hi - The query below shows the datatype of each column in a table but it does not display the length that was defined for nvarchar columns. Where is that data stored? In other words, what ...Answered | 3 Replies | 5617 Views | Created by Knot - Sunday, December 02, 2012 3:27 AM | Last reply by Tom Phillips - 9 hours 40 minutes ago -
0 Votes
Unexpected Transaction rollback
User originally reported that the application was not saving her changes. After further review, determined that 1 specific record would "Roll back" for some unknown reason. I ...Answered | 14 Replies | 101 Views | Created by MattHKC - Wednesday, September 20, 2017 12:35 PM | Last reply by MattHKC - 12 hours 14 minutes ago -
0 Votes
Index + INCLUDE
I am curious to know when to use index with "INCLUDE" and when not. And what are the pros and cons of both. Aniruddha http://aniruddhathengadi.blogspot.com/Unanswered | 4 Replies | 55 Views | Created by Aniruddha Thengadi - 15 hours 18 minutes ago | Last reply by Atif-ullah Sheikh - 13 hours 49 minutes ago -
1 Votes
"EXECUTE AT" with Dynamic Linked Server Name
I would like to do something like DECLARE @LinkedServerName VARCHAR(255); SET @LinkedServerName = ('SOME SQL TO RETRIEVE LINKED SERVER ...Answered | 9 Replies | 2028 Views | Created by delish - Tuesday, November 01, 2016 6:11 PM | Last reply by Ghassan El Nemr - 15 hours 11 minutes ago -
2 Votes
How to execute the Query which is inside a field in a table
Hi, I have a database with more than 100 tables. As a Quality check, I have been asked to find out the NULLs, Blanks and Zeros for each and every column in all ...Answered | 6 Replies | 110 Views | Created by Manesar - Wednesday, September 20, 2017 8:41 PM | Last reply by Atif-ullah Sheikh - 15 hours 38 minutes ago -
0 Votes
Drop User-Defined Table Types
I do have this query that will select the types that i wanna drop, i just don't know how to drop the output of this query. SELECT * FROM sys.types WHERE is_table_type = 1 AND name ...Answered | 9 Replies | 126 Views | Created by Dikong42 - Tuesday, September 19, 2017 7:10 AM | Last reply by Xi Jin - 17 hours 9 minutes ago -
0 Votes
How to combine more queries and make a single query to optimize it?
IF OBJECT_ID('tempdb.dbo.#Total_Water_m3', 'U') IS NOT NULL DROP TABLE ...Unanswered | 2 Replies | 61 Views | Created by MB82-20 - Wednesday, September 20, 2017 9:58 AM | Last reply by Will_Kong - 17 hours 54 minutes ago -
0 Votes
Can I use DBCC CLONEDATABASE command for creating a copy of database without any data for production environment?
We have an extremely large database with well over 30 thousand objects and 10 of TBs of data. I want to create a copy of this ...Unanswered | 12 Replies | 147 Views | Created by Emine Bozlar - Wednesday, September 13, 2017 10:59 AM | Last reply by Xi Jin - 18 hours 7 minutes ago -
0 Votes
write t-sql
i want to judge whether it is a special color. The special color is E1400. The character before 1400 must be E. The letter after the first letter E must after a number, The 1400 cannot ...Answered | 5 Replies | 86 Views | Created by katherine tan - Wednesday, September 20, 2017 11:46 AM | Last reply by katherine tan - 18 hours 54 minutes ago - Items 1 to 20 of 87200 Next ›
No announcements
