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
CASE Statement To Set Database Context
Hi, Using SQL Server 2012. We have a series of table-valued functions and stored procedures (wrapped in scheduled jobs) used to compile data for use in a management ...Unanswered | 1 Replies | 46 Views | Created by 2012S4 - 3 hours 0 minutes ago | Last reply by Visakh16 - 35 minutes ago -
0 Votes
ALTER DATABASE SET COMPATIBILTY_LEVEL executes irrespective of IF EXIST condition
110 AND name='mydatabase' ) BEGIN ALTER DATABASE mydatabase SET COMPATIBILITY_LEVEL = ...Unanswered | 2 Replies | 45 Views | Created by Gokula_k - 2 hours 25 minutes ago | Last reply by Visakh16 - 50 minutes ago -
0 Votes
Can't not update when have trigger
Hello everyone! I write trigger for update, but can not update new value. help me please create trigger ...Proposed | 3 Replies | 107 Views | Created by Ho Duy Loi - Monday, March 02, 2015 7:11 AM | Last reply by Charlie Liao - 4 hours 3 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 | 47 Replies | 284 Views | Created by MJFara - Tuesday, March 03, 2015 1:22 AM | Last reply by MJFara - 4 hours 34 minutes ago -
0 Votes
multi-part identifier could not be bound.
Hi I have the below query which runs fine for most of the servers(SQL 2008 R2, 2005 and 2012). But in some of the servers getting error msg as "The multi-part identifier ...Unanswered | 8 Replies | 95 Views | Created by Rani_Van - 15 hours 41 minutes ago | Last reply by Rani_Van - 5 hours 57 minutes ago -
0 Votes
Self join to get related records in one row
I have a table that has individual records for each family member. tPerson.LastName, tPerson.FirstName, tPerson.RelationshipCode, tPerson.FamilyUnitCode, ...Unanswered | 2 Replies | 55 Views | Created by JWollman - 7 hours 24 minutes ago | Last reply by Reshma Mahabir-Poeran - 6 hours 6 minutes ago -
0 Votes
Perecent of Total Query
I am trying to come up with a query that provides a percent of total of products delivered in the same month that they were ordered. so the example below should reveal that all of ...Unanswered | 5 Replies | 55 Views | Created by siera_gld - 7 hours 48 minutes ago | Last reply by Guoxiong - 6 hours 22 minutes ago -
0 Votes
Select where case
I am trying to build the query below to throw in SSRS. I have a multivalued parameter called @category. When the value of USCATVLS_2 is blank I want to still have the option to ...Unanswered | 8 Replies | 59 Views | Created by Ryan McBee - 11 hours 17 minutes ago | Last reply by Guoxiong - 6 hours 50 minutes ago -
0 Votes
How to attatchment some files that are in other server to send an email?
Hi I need to send an enmail with sql, but i have to attatchment some files, those files are in anohter server, so I want to know, how attatchment those ...Unanswered | 4 Replies | 52 Views | Created by Ángel Anguiano - 10 hours 16 minutes ago | Last reply by Stan210 - 8 hours 54 minutes ago -
0 Votes
How to handle XML string with Single Quotes as a parameter to SP dynamically?
Hi, I would like to know if there is a way to handle the Single Quotes in XML value when it is passed to Stored Procedure? I should be able to handle it without ...Unanswered | 5 Replies | 71 Views | Created by Chandra Shekar Nagisetty - Wednesday, March 04, 2015 10:00 PM | Last reply by Stefan Hoffmann - 10 hours 3 minutes ago -
2 Votes
Order By Compile Error On View
I have a view that I am trying to use Cast on an Order by statement but it is generating the below error Only text pointers are allowed int he work tables, never text, ntext, or ...Answered | 3 Replies | 52 Views | Created by IndigoMontoya - 11 hours 4 minutes ago | Last reply by Jingyang Li - 10 hours 15 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 ...Answered | 14 Replies | 187 Views | Created by ITBobbyP - Tuesday, March 03, 2015 8:45 PM | Last reply by ITBobbyP - 10 hours 32 minutes ago -
1 Votes
Lag and Lead not recognized
Hi All, I am using these new functions "Lag", "Lead", and "ISError" in RC0 Now while executing I am getting this ...Answered | 13 Replies | 3621 Views | Created by HimanshuSharma - Thursday, September 12, 2013 1:57 PM | Last reply by Tom Cooper - 10 hours 57 minutes ago -
0 Votes
Find unchanged rows
I want to do a report - find the revenue which is not changed in last six month for projects. I am selecting 3 rows, project, revenue and date column. I want to see only those revenue (along with ...Unanswered | 17 Replies | 173 Views | Created by gurudevam - Wednesday, March 04, 2015 7:31 PM | Last reply by johnqflorida - 10 hours 58 minutes ago -
0 Votes
condtion based xml for each row of the table t-sql
Hello , i have below data. create table #students ( id int identity(1,1) primary key, student_id int not null, [s_m_cml] ...Proposed | 1 Replies | 41 Views | Created by Chakradhar Masineni - 11 hours 46 minutes ago | Last reply by Stan210 - 11 hours 8 minutes ago -
0 Votes
Getting same output without cursor in SQL
I dont want to use cursor but i want same output shown below. How can i do it in SQL DECLARE ...Unanswered | 7 Replies | 106 Views | Created by SyedF - Wednesday, March 04, 2015 4:55 PM | Last reply by Patrick Hurst - 12 hours 34 minutes ago -
2 Votes
Update statement tuning
I have update statement which needs to be updated 50M records. Direct update takes 8 plus hours, so made a chunks with following code and still takes about 5 hours to run. is there best method to ...Answered | 5 Replies | 89 Views | Created by krotha - Wednesday, March 04, 2015 6:07 PM | Last reply by Guoxiong - 13 hours 16 minutes ago -
0 Votes
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
Windows Server 2008 SQL Express 2012 Tried opening a .csv and a .xls file, without success. File is located on the local server and not somewhere ...Answered | 2 Replies | 79 Views | Created by tedlong - Thursday, March 05, 2015 2:47 AM | Last reply by tedlong - 13 hours 18 minutes ago -
0 Votes
Stored procedure tuning
I have following simplified version of stored procedure and it takes more than 5 hours to run. I have lot of updates with implicit conversions. I ran execution plan and created necessary indexes and ...Unanswered | 4 Replies | 77 Views | Created by krotha - 14 hours 43 minutes ago | Last reply by Niting123 - 14 hours 0 minutes ago - Items 1 to 20 of 75443 Next ›
No announcements
