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 ...
-
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 | 103 Views | Created by Javier_Martin - Friday, February 27, 2015 10:41 AM | Last reply by Reshma Mahabir-Poeran - 5 hours 25 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 | 93 Views | Created by dba60 - Friday, February 27, 2015 4:09 AM | Last reply by dba60 - 7 hours 3 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 ...Unanswered | 4 Replies | 67 Views | Created by iwadds - 10 hours 51 minutes ago | Last reply by Niting123 - 8 hours 3 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 | 16 Replies | 210 Views | Created by Jason A Long - Wednesday, February 25, 2015 4:20 PM | Last reply by Tom Cooper - 8 hours 27 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 | 114 Views | Created by jaggy99 - Thursday, February 26, 2015 12:04 PM | Last reply by jaggy99 - 10 hours 12 minutes ago -
0 Votes
Query - Urgent
Status Value a 23 b 21 c 44 Need query to display the below ...Unanswered | 3 Replies | 83 Views | Created by KIRAN KUAMR - 15 hours 4 minutes ago | Last reply by Jingyang Li - 14 hours 12 minutes ago -
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 | 65 Views | Created by Dre01 - 14 hours 49 minutes ago | Last reply by Jingyang Li - 14 hours 23 minutes ago -
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 | 85 Views | Created by neolim - 17 hours 9 minutes ago | Last reply by Prashanth Jayaram - 14 hours 41 minutes ago -
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 | 86 Views | Created by mhodges77 - 17 hours 9 minutes ago | Last reply by mhodges77 - 14 hours 59 minutes ago -
0 Votes
INSERT EXEC Statement Cannot Be Nested
I AM GETTING THE FOLLOWING PROBLEM WHEN I EXECUTE THIS QUERY: DECLARE @i INT DECLARE @Lenght INT; DECLARE @Publication ...Proposed | 4 Replies | 134 Views | Created by carlosadrr - Thursday, February 19, 2015 12:02 AM | Last reply by krotha - 15 hours 46 minutes ago -
0 Votes
String Aggregate Concatenation
Link on aggregate concatenation with variable: CREATE FUNCTION CSVLanguage (@Title as varchar(50)) RETURNS ...Answered | 12 Replies | 18133 Views | Created by Kalman Toth - Sunday, July 04, 2010 9:01 PM | Last reply by Alexey Stepanov - 16 hours 8 minutes ago -
0 Votes
Oracle OPENQUERY results in ORA-01858: a non-numeric character was found where a numeric was expected
I have this OPENQUERY on our SQL Server ...Unanswered | 1 Replies | 43 Views | Created by ITBobbyP - 17 hours 34 minutes ago | Last reply by Tom Phillips - 17 hours 9 minutes ago -
0 Votes
Can I use NOT IN for 2 conditions
' + tp.Source, GETUTCDATE() FROM [etag].[Tag_Processed] tp WHERE tp.Source NOT IN (SELECT bamap.Name FROM ...Unanswered | 4 Replies | 147 Views | Created by greghanson - Monday, February 23, 2015 11:27 PM | Last reply by Patrick Hurst - 17 hours 15 minutes ago -
0 Votes
How to write a SQL Code to load some files into a SQL Table
Hi All, I have a folder named "Test" which has lets say 3 sub folders named "Sub1","Sub2","Sub3".All these folders have some X number of ...Proposed | 7 Replies | 225 Views | Created by SqlDev12 - Tuesday, February 17, 2015 11:54 PM | Last reply by pituach - 17 hours 18 minutes ago -
0 Votes
Generate Create Table Statements
Hi, the problem is: My company want to migrate our SQL Server DB to Winwows Azure Server (currently we have our own domain and server), but Azure doesn't support the sentence 'Into' ...Unanswered | 6 Replies | 74 Views | Created by MCastilloG - 18 hours 20 minutes ago | Last reply by Patrick Hurst - 17 hours 19 minutes ago -
0 Votes
select latest rates
hello experts, i have a database having purchase (suppliername, receiptdate, billno, ui) ui is primary key in all ...Unanswered | 5 Replies | 70 Views | Created by Sushil Agarwal - 22 hours 50 minutes ago | Last reply by Patrick Hurst - 17 hours 25 minutes ago -
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 ...Unanswered | 3 Replies | 62 Views | Created by DIEGOCTN - 18 hours 54 minutes ago | Last reply by Patrick Hurst - 18 hours 36 minutes ago -
2 Votes
Clubbing two statements into one in Stored Procedure
I am writing a stored procedure and one of the statement goes like ...Unanswered | 2 Replies | 65 Views | Created by SyedF - 20 hours 2 minutes ago | Last reply by Patrick Hurst - 19 hours 49 minutes ago -
2 Votes
Escaping a whole string variable in T-SQL
Hi, is it possible to escape o whole string variable in T-SQL like it is possible in PowerShell? In PowerShell it works like this: $PSstring = ...Answered | 16 Replies | 119 Views | Created by Stefan Horz - 21 hours 37 minutes ago | Last reply by Stefan Hoffmann - 20 hours 3 minutes ago -
0 Votes
Help with TSQL please.
If a user belong to server role, I want to return unique server role. Please see the result want below. I am using SQL 2012. Thank you so ...Proposed | 6 Replies | 97 Views | Created by NguyenBL - Friday, February 27, 2015 5:07 AM | Last reply by Jingyang Li - 21 hours 42 minutes ago - Items 1 to 20 of 75346 Next ›
No announcements
