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
Database Mail Error
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-03-04T16:06:48). Exception Message: Could not write to temp attachment file. (The ...Unanswered | 2 Replies | 55 Views | Created by RahulDoshi1983 - 10 hours 6 minutes ago | Last reply by Eric__Zhang - a few seconds ago -
0 Votes
Not in to not exists
1) STG1 ON STG.AR_CUST_NUM = STG1.AR_CUST_NUM Where STG.AR_ACCOUNT_NUM NOT IN (SELECT AR_ACCOUNT_NUM FROM ETL.ACCOUNT_HST) UNION SELECT '20' as ...Unanswered | 2 Replies | 27 Views | Created by Eswararao C - 1 hour 1 minutes ago | Last reply by Eswararao C - 4 minutes ago -
1 Votes
Reading from XML
Team , Thanks in advance for your time and help . while i'm still researching on XML functions can some assist with reading few contents from this spcified XML below ...Unanswered | 2 Replies | 36 Views | Created by Rajkumar Yelugu - 1 hour 5 minutes ago | Last reply by Rajkumar Yelugu - 9 minutes ago -
0 Votes
Year or Datepart versus Table with Date Groupings
Hello! In running queries for sales history in a given timeframe, I've typically always used things like "where year(salesorderdate) = year(getdate())" ...Unanswered | 1 Replies | 28 Views | Created by AHubbard440 - 33 minutes ago | Last reply by Kalman Toth - 25 minutes ago -
2 Votes
table with delimited column to new columns
i have a table col1,col2,col3 a,b,"1,2,3,4,5" x,c,"5,1,3,1,3" and i want to transfer it to ...Unanswered | 11 Replies | 106 Views | Created by want to learn1 - 11 hours 12 minutes ago | Last reply by want to learn1 - 31 minutes ago -
0 Votes
CHECKSUM
select checksum(3,1,'$VSNS.XKMQDS.IXKMUPDT') select checksum(3,1,'$VSNS.XTRQDS.IXTRUPDT') select ...Unanswered | 7 Replies | 78 Views | Created by MotKn - 7 hours 5 minutes ago | Last reply by Tom Cooper - 2 hours 3 minutes ago -
0 Votes
Best SQL Challenege: TSQL Query Maximum Concurrent Connections (Participants)
Hi All, I have a table called dbo.PhoneCalls with below columns PhoneID |PhoneNumber| Callstarttime| CallEndtime| 1 |111-111-1111|2013-04-01 ...Proposed | 8 Replies | 112 Views | Created by nexus2vijay - 21 hours 39 minutes ago | Last reply by nexus2vijay - 2 hours 25 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 ...Unanswered | 1 Replies | 49 Views | Created by tedlong - 5 hours 26 minutes ago | Last reply by dave_gona - 2 hours 33 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 | 33 Replies | 210 Views | Created by MJFara - Tuesday, March 03, 2015 1:22 AM | Last reply by MJFara - 6 hours 25 minutes ago -
0 Votes
Database Analysis -Load balance.
Hi Experts, There is new db onboraded in our existing database server in upcoming few week. I would like to know what are the thinng we need to check in the terms of CPU and ...Unanswered | 1 Replies | 95 Views | Created by Shivraj Patil - Friday, February 27, 2015 8:48 AM | Last reply by HoroChan - 6 hours 42 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 | 1 Replies | 32 Views | Created by Chandra Shekar Nagisetty - 10 hours 13 minutes ago | Last reply by George Robertson Jr - 7 hours 1 minutes ago -
0 Votes
Cube or Group By columns with Case Expressions with a total row (SQL Server 2008)
I am trying to create a summary tabe of some data. I think that I can use Cube(my heart is not set on it though), but I cant figure a way to define new columns via a case ...Proposed | 1 Replies | 33 Views | Created by mcinvalek - 10 hours 7 minutes ago | Last reply by George Robertson Jr - 7 hours 5 minutes ago -
0 Votes
Aggregate columns which contain Case Expressions and a total row (SQL Server 2008)
I am trying to create a summary tabe of some data. I think that I can use Cube(my heart is not set on it though), but I cant figure a way to define new columns via a case ...Answered | 3 Replies | 50 Views | Created by mcinvalek - 10 hours 3 minutes ago | Last reply by mcinvalek - 7 hours 44 minutes ago -
1 Votes
Select distinct rows based on latest date
Hi I need to produce data from two tables and return results where only data for the latest OriginationDate is returned for each unique client. I have been ...Unanswered | 5 Replies | 61 Views | Created by wha59 - 9 hours 20 minutes ago | Last reply by SeIina KyIe - 8 hours 55 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 ...Proposed | 12 Replies | 102 Views | Created by gurudevam - 12 hours 42 minutes ago | Last reply by Guoxiong - 9 hours 16 minutes ago -
0 Votes
SQL Server HyerarchyID inheritance
Good Afternoo...! Again please forgive me because I'm too new in HierarchyID data type in SQL Server and I'm so dummy! I have the next table for ...Proposed | 6 Replies | 57 Views | Created by Jamesit0 - 11 hours 43 minutes ago | Last reply by Jingyang Li - 9 hours 23 minutes ago -
0 Votes
Create Create table statement dynamicallly
I am trying to create a SP that return a “Create table “statement dynamically using a table called “Employee” in database. How can I create a dynamic Create ...Proposed | 3 Replies | 69 Views | Created by SSAS_5000 - 11 hours 54 minutes ago | Last reply by altuko - 9 hours 28 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 | 10 Replies | 139 Views | Created by ITBobbyP - Tuesday, March 03, 2015 8:45 PM | Last reply by Patrick Hurst - 9 hours 39 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 | 3 Replies | 66 Views | Created by SyedF - 15 hours 18 minutes ago | Last reply by Patrick Hurst - 10 hours 10 minutes ago -
0 Votes
Inserting data using stored procedure
Using SQL Server Express 2014, I'm creating a stored procedure to accept parameters and convert data from a staging table to a production table. The parameters specify the table names and a field to ...Answered | 8 Replies | 67 Views | Created by Adam-M - 18 hours 1 minutes ago | Last reply by Jingyang Li - 10 hours 39 minutes ago - Items 1 to 20 of 75428 Next ›
No announcements
