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
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 | 7 Replies | 82 Views | Created by MCastilloG - 20 hours 16 minutes ago | Last reply by Eric__Zhang - 12 minutes ago -
0 Votes
BRIEFLY DESCRIBE INSERT STATEMENT ???
Do we need a table name to insert ?? Why ???? Explain in detail ???Proposed | 6 Replies | 84 Views | Created by sumitsen - Wednesday, February 25, 2015 3:11 PM | Last reply by ryguy72 - 16 minutes ago -
0 Votes
Activity for a user
Hi , I have 2 tables as shown below CREATE TABLE LogDetails ( ...Unanswered | 4 Replies | 75 Views | Created by mirandaroopa - Friday, February 27, 2015 12:39 PM | Last reply by Eric__Zhang - 42 minutes ago -
0 Votes
My INSERT is inserting duplicate data
HelloUnanswered | 14 Replies | 113 Views | Created by cwilliams211 - Thursday, February 26, 2015 7:36 PM | Last reply by Charlie Liao - 49 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 | 69 Views | Created by iwadds - 12 hours 47 minutes ago | Last reply by Erland Sommarskog - 4 hours 7 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 | 107 Views | Created by Javier_Martin - Friday, February 27, 2015 10:41 AM | Last reply by Reshma Mahabir-Poeran - 7 hours 21 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 | 96 Views | Created by dba60 - Friday, February 27, 2015 4:09 AM | Last reply by dba60 - 8 hours 59 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 - 10 hours 23 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 | 115 Views | Created by jaggy99 - Thursday, February 26, 2015 12:04 PM | Last reply by jaggy99 - 12 hours 8 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 ...Proposed | 3 Replies | 64 Views | Created by DIEGOCTN - 20 hours 50 minutes ago | Last reply by Erland Sommarskog - 15 hours 0 minutes ago -
0 Votes
Query - Urgent
Status Value a 23 b 21 c 44 Need query to display the below ...Unanswered | 3 Replies | 85 Views | Created by KIRAN KUAMR - 17 hours 0 minutes ago | Last reply by Jingyang Li - 16 hours 8 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 | 66 Views | Created by Dre01 - 16 hours 45 minutes ago | Last reply by Jingyang Li - 16 hours 19 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 - 19 hours 5 minutes ago | Last reply by Prashanth Jayaram - 16 hours 37 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 | 87 Views | Created by mhodges77 - 19 hours 5 minutes ago | Last reply by mhodges77 - 16 hours 55 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 | 135 Views | Created by carlosadrr - Thursday, February 19, 2015 12:02 AM | Last reply by krotha - 17 hours 42 minutes ago -
0 Votes
String Aggregate Concatenation
Link on aggregate concatenation with variable: CREATE FUNCTION CSVLanguage (@Title as varchar(50)) RETURNS ...Answered | 12 Replies | 18136 Views | Created by Kalman Toth - Sunday, July 04, 2010 9:01 PM | Last reply by Alexey Stepanov - 18 hours 4 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 | 44 Views | Created by ITBobbyP - 19 hours 30 minutes ago | Last reply by Tom Phillips - 19 hours 5 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 - 19 hours 11 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 | 227 Views | Created by SqlDev12 - Tuesday, February 17, 2015 11:54 PM | Last reply by pituach - 19 hours 14 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 | 73 Views | Created by Sushil Agarwal - Friday, February 27, 2015 1:33 PM | Last reply by Patrick Hurst - 19 hours 21 minutes ago - Items 1 to 20 of 75346 Next ›
No announcements
