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 ...
-
1 Votes
DB Access Speed improvement
When try accessing and acquiring huge data and speed is too slow, what should I consider in order to improve this poor performance. There can be a server side improvement and client ...Unanswered | 3 Replies | 91 Views | Created by dy0803 - Tuesday, February 24, 2015 5:25 PM | Last reply by Eric__Zhang - 54 minutes ago -
0 Votes
Dynamic sql usage?
Hello Everyone, Can somone tell when or where to use Dynamic sql ( exec sp_executesql and exec commands) over normal sql ...Unanswered | 2 Replies | 32 Views | Created by Sqlfav - 1 hour 10 minutes ago | Last reply by Dan Guzman - 54 minutes ago -
5 Votes
Latest Number of Consecutive Weeks
I recently posted a similar question about getting the latest number of consecutive days. I thought with that information I'd be able to do the same for consecutive weeks, but I was ...Answered | 29 Replies | 163 Views | Created by MJFara - Tuesday, March 03, 2015 1:22 AM | Last reply by MJFara - 2 hours 57 minutes ago -
0 Votes
SSIS - Using Variables in Execute SQL Task Error
The following query in my Execute SQL Task throws the following error when run - [Execute SQL Task] Error: Executing the query "SELECT @columnz = COALESCE(@columnz + ',[' + times..." ... -
0 Votes
Capturing the row info that causes an error during a massive insert/update by usign TRY ... CATCH - SQL Server 2012
Hi, in a my stored procedure, I've put a massive update under the control of TRY ... CATCH construct. I'd like to capture for which key values it occurs the error ...Proposed | 8 Replies | 102 Views | Created by pscorca - Monday, March 02, 2015 5:03 PM | Last reply by George Robertson Jr - 5 hours 35 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 | 7 Replies | 227 Views | Created by carlosadrr - Thursday, February 19, 2015 12:02 AM | Last reply by carlosadrr - 6 hours 41 minutes ago -
0 Votes
How to rollback after update
Good Morning All, I have the following UPDATE statement that i need to run. What i'm looking for , is there a process or method where in if the updated results are not satisfactory, ...Answered | 9 Replies | 79 Views | Created by saivenkat77 - 13 hours 33 minutes ago | Last reply by Tom Phillips - 7 hours 1 minutes ago -
0 Votes
Why am I losing addressability to my Common Table Expression
My Query contains half-a-dozen or so CTEs. At the very end I am creating a #TempTable...but I wanted the capability to create another #TempTable but I sxeem to have lost the addressability to the CTE ...Proposed | 4 Replies | 72 Views | Created by ITBobbyP - 7 hours 43 minutes ago | Last reply by Tom Phillips - 7 hours 11 minutes ago -
0 Votes
Setting a calculated field to 1
I have the following ...Unanswered | 5 Replies | 66 Views | Created by system243trd - 12 hours 58 minutes ago | Last reply by Guoxiong - 8 hours 27 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 ...Proposed | 4 Replies | 154 Views | Created by dba60 - Friday, February 27, 2015 4:09 AM | Last reply by dba60 - 8 hours 50 minutes ago -
1 Votes
Insert / Update in to database depending on a record
Hello Experts, I am very new to SQL Server and stored procedures. I need some suggestion to my problem, I have a requirement where the data has to be inserted (if it is not ...Answered | 14 Replies | 153 Views | Created by vdha - Monday, March 02, 2015 5:51 PM | Last reply by Guoxiong - 9 hours 4 minutes ago -
0 Votes
Trapping and Reporting Invalid Dates
I am querying a postgres database for data that I import into SQL Server. Several of the source columns I'm querying for are datetime data types. I'm seeing a problem where the postgres ...Proposed | 3 Replies | 49 Views | Created by Mark Kraffert - 10 hours 15 minutes ago | Last reply by KEAARPEE - 9 hours 24 minutes ago -
0 Votes
Optimizing SP
0 OR CHARINDEX('byupdatedate', LOWER(@control_parm)) > 0 SELECT @by_update_date_ind = 'y' ELSE SELECT ... -
0 Votes
How do I handle my Final SELECT based on a @ReportType Run Parameter
So I have multiple CTEs in my SQL... WITH CTE_1 AS (SELECT...) , CTE_2 AS (SELECT...) , CTE_3 ...Unanswered | 4 Replies | 56 Views | Created by ITBobbyP - 13 hours 23 minutes ago | Last reply by Visakh16 - 11 hours 30 minutes ago -
0 Votes
Stuff Sql server
Hi, I am trying to convert rows into one single string using stuff . It is replacing with single string but every end of the row it replaced empty string ...Answered | 1 Replies | 49 Views | Created by vinay2110 - 12 hours 26 minutes ago | Last reply by Patrick Hurst - 11 hours 59 minutes ago -
0 Votes
List tables and column names a stored procedure is querying
Hello, Is there a way to list tables and column names that a stored procedure is querying, i.e, selecting from, using T-SQL? If yes, is there a way to also show data ...Answered | 16 Replies | 116 Views | Created by LenFinkel - Monday, March 02, 2015 4:49 PM | Last reply by Tony C-UK - 12 hours 34 minutes ago -
0 Votes
Case within a where clause
I have a select statement with a case within the where clause, but I'm getting stuck in one part would someone be able to show me the correct way to do it? SELECT * FROM TABLE WHERE ...Answered | 11 Replies | 173 Views | Created by Debra has a question - Tuesday, February 24, 2015 9:42 PM | Last reply by Debra has a question - 13 hours 13 minutes ago -
3 Votes
Latest Number of Consecutive Days ("Current Streak")
Using SQL Server (On Azure) I am trying to figure out how to get the latest number of consecutive days in an SQL query. I have a habit tracking app in which I ...Answered | 34 Replies | 355 Views | Created by MJFara - Tuesday, February 24, 2015 9:47 PM | Last reply by MJFara - 13 hours 33 minutes ago -
0 Votes
Query to display one row per group based on highest value
I have the following table and I want to be able to create a query that displays only the highest number based on a group. (see ...Proposed | 4 Replies | 65 Views | Created by system243trd - 14 hours 33 minutes ago | Last reply by Visakh16 - 13 hours 36 minutes ago -
0 Votes
Alter Database Remove File : Partition Files on different folders
I need to remove partition files, once I switch the partition with staging table and empty/truncate the partition. When I was running the code on my local machine I was ...Answered | 2 Replies | 66 Views | Created by SQL_Admirer - Tuesday, March 03, 2015 3:28 AM | Last reply by SQL_Admirer - 13 hours 38 minutes ago - Items 1 to 20 of 75396 Next ›
No announcements
