No announcements
-
0 VotesPOSTING 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 want to show us what you see on ...
-
0 Votes
SQL Query Script
Hi, Please help me how to write a SQL script to get the below results. Here are is my sample table data script and also the calculations description. Sample table ...Unanswered | 5 Replies | 64 Views | Created by ReddyNar - 3 hours 37 minutes ago | Last reply by Jason A Long - 7 minutes ago -
0 Votes
SCD TYPE 2 LOGIC
Hi Guru, I Have two tables like below format, one is master table and second the stag table. I need implement scd tye 2 with below logic. Here source table ... -
0 Votes
time different excluding overlap period
hello experts, i m looking for a time difference between 2 data excluding the overlap period. declare @tbl table(id int, startTime datetime, endTime ...Unanswered | 8 Replies | 116 Views | Created by Yazdani ISTS - Thursday, February 26, 2015 8:08 AM | Last reply by Jason A Long - 1 hour 7 minutes ago -
0 Votes
Activity for a user
Hi , I have 2 tables as shown below CREATE TABLE LogDetails ( ...Unanswered | 5 Replies | 111 Views | Created by mirandaroopa - Friday, February 27, 2015 12:39 PM | Last reply by ryguy72 - 4 hours 6 minutes ago -
0 Votes
How to get table result from XML
Hi I am new to XML, I was playing with node, but wasn't successfull I have XML fragment DECLARE @XML xml = ' <E1EDP01 ... -
2 Votes
Help on custom function...
@Now BEGIN SET @NextMaintenanceWindow = @StartTime END END ELSE IF @RecurrenceType = @RecurrenceType_DAILY BEGIN IF DATEADD(MINUTE, @Duration, ...Unanswered | 3 Replies | 100 Views | Created by Narcoticoo - 11 hours 3 minutes ago | Last reply by Narcoticoo - 8 hours 54 minutes ago -
6 Votes
LAG & LEAD functions... Any Way to Retrieve the 1st non-NULL Values?
My question is this... Has anyone found an elegant way of getting the LAG & LEAD functions to move to the 1st NON-NULL value within the partition, rather than simply using a hard-coded offset ...Answered | 17 Replies | 262 Views | Created by Jason A Long - Wednesday, February 25, 2015 4:20 PM | Last reply by Jason A Long - 10 hours 25 minutes ago -
1 Votes
CASE in Stored Procedure Not Working
Why is this not working? SET NOCOUNT ON; SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT ... dbo.Components.*, CASE ...Proposed | 3 Replies | 71 Views | Created by mmmtbig - 11 hours 6 minutes ago | Last reply by Vaibhav Chaudhari - 10 hours 49 minutes ago -
3 Votes
It's time for the TechNet Wiki T-SQL "Great Guru Love-in"! You too can get some loving!
February at TechNet Wiki usually involves a lot of love... We love to read. We love to learn. We ...Discussion | 4 Replies | 306 Views | Created by XAML guy - Monday, February 09, 2015 9:16 PM | Last reply by pituach - 13 hours 43 minutes ago -
0 Votes
My INSERT is inserting duplicate data
Hello OP removed the Original Post.Unanswered | 15 Replies | 146 Views | Created by cwilliams211 - Thursday, February 26, 2015 7:36 PM | Last reply by Kalman Toth - 13 hours 51 minutes ago -
0 Votes
BRIEFLY DESCRIBE INSERT STATEMENT ???
Do we need a table name to insert ?? Why ???? Explain in detail ???Proposed | 6 Replies | 101 Views | Created by sumitsen - Wednesday, February 25, 2015 3:11 PM | Last reply by ryguy72 - 14 hours 31 minutes ago -
0 Votes
Search and replace string inside a column
Hi, in my table there is Column A with Type NVARCHAR. i need to search inside all the rows in that column to find the string "_TH" and remove it ...Proposed | 4 Replies | 94 Views | Created by iwadds - Saturday, February 28, 2015 1:32 AM | Last reply by Erland Sommarskog - 18 hours 22 minutes ago -
2 Votes
Raiserror behavior in TRY-CATCH block
Hi all, I have a behavior and cannot explain and would like to get your opinions. I am playing with sqlserver 2012 error handling and notice a ...Proposed | 6 Replies | 128 Views | Created by Javier_Martin - Friday, February 27, 2015 10:41 AM | Last reply by Reshma Mahabir-Poeran - 21 hours 36 minutes ago -
0 Votes
SQL query has strange behavior on sql server 2014
Hi All, I have a very weird situation where a front end entity framework query (cannot be modified easily) made up of SQL views that are used in subquery format. It generally runs ...Unanswered | 3 Replies | 108 Views | Created by dba60 - Friday, February 27, 2015 4:09 AM | Last reply by dba60 - 23 hours 14 minutes ago -
1 Votes
Spreading Amount across financial year based on Start and End Date
Hi All, I have a table which can be downloaded from the link below. The table contains property Market Rent and period the new rent is applicable. I need to generate a ...Unanswered | 6 Replies | 126 Views | Created by jaggy99 - Thursday, February 26, 2015 12:04 PM | Last reply by jaggy99 - Saturday, February 28, 2015 2:11 AM -
0 Votes
Arithmetic overflow error converting expression to data type int. Why in this case?
Hi guys, it is Friday and I am really tired but.. WITH CTE AS ( SELECT LEN(CONS_ID) AS PROCA FROM TryCons) SELECT SUM(PROCA) FROM ...Proposed | 3 Replies | 81 Views | Created by DIEGOCTN - Friday, February 27, 2015 5:29 PM | Last reply by Erland Sommarskog - Friday, February 27, 2015 11:19 PM -
0 Votes
Query - Urgent
Status Value a 23 b 21 c 44 Need query to display the below ...Unanswered | 3 Replies | 104 Views | Created by KIRAN KUAMR - Friday, February 27, 2015 9:19 PM | Last reply by Jingyang Li - Friday, February 27, 2015 10:11 PM -
0 Votes
logic for negative amount
I have a money field which is 10 in character The requirement is for example -365.67. should come ...Proposed | 3 Replies | 94 Views | Created by Dre01 - Friday, February 27, 2015 9:34 PM | Last reply by Jingyang Li - Friday, February 27, 2015 10:00 PM -
1 Votes
How to execute a sql script against selected databases in the same SQL Instance
Hi, I have a SQL Instance hosting a number of databases. I want to execute a .sql script for selected databases only, and NOT for all databases in the Instance (so ...Answered | 10 Replies | 98 Views | Created by neolim - Friday, February 27, 2015 7:14 PM | Last reply by Prashanth Jayaram - Friday, February 27, 2015 9:42 PM -
0 Votes
An SQL Script for detecting fragmented Indexes
Is there a script that I can run on a 2008 or a 2012 sql server to tell me all the tables and indexes that are fragmented over 30% and has over 100 pages? Thanks ...Answered | 10 Replies | 108 Views | Created by mhodges77 - Friday, February 27, 2015 7:14 PM | Last reply by mhodges77 - Friday, February 27, 2015 9:24 PM - Items 1 to 20 of 75350 Next ›
No announcements
