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're asking for ...
-
0 Votes
Trying to Import Excel Data from query
SaveAS > Excel 97 - 2003 Workbook option but still not able to import data from query. Here's the query which I am using in Query ...Proposed | 8 Replies | 384 Views | Created by Kenny_Gua - Wednesday, August 14, 2019 4:00 AM | Last reply by Yitzhak Khabinsky - 27 minutes ago -
0 Votes
Export table data to .MSG file using SP
Is it possible with a stored procedure to write/export/output the data as .msg outlook file using existing table data? TIA.Unanswered | 2 Replies | 169 Views | Created by Pari.K - Friday, August 23, 2019 8:47 PM | Last reply by pituach - 55 minutes ago -
0 Votes
Query Running Independently but not as Dynamic Query
0 ) then pi.qty_conv else 1 End)) as qty, pi.price as rate,Pur.l_currency,pi.item_unit as pur_unit,pi.ord_no as job_no, pi.fitem_id as ...Unanswered | 5 Replies | 179 Views | Created by aviral91 - Saturday, August 24, 2019 8:57 AM | Last reply by pituach - 1 hour 10 minutes ago -
0 Votes
How to recode T-SQL without Tally Table
Hello Community, Can someone please help recode the following T-SQL such that I get the same result but without using a Tally ...Unanswered | 6 Replies | 111 Views | Created by carlton7372 - 8 hours 12 minutes ago | Last reply by Viorel_ - 7 hours 20 minutes ago -
0 Votes
T-SQL Query Won't execute when converted to Spark.SQL
Hello Community, The following T-SQL executes with no problems in MS SQL Server SELECT MakeName, SUM(Cost) AS TotalCost FROM Data.Make AS MK ...Unanswered | 3 Replies | 139 Views | Created by carlton7372 - Saturday, August 24, 2019 4:48 PM | Last reply by pituach - 7 hours 44 minutes ago -
0 Votes
Find Rating for specific Percentage range
= 1 and @Param4 < 25 THEN 1 ...Unanswered | 1 Replies | 145 Views | Created by LeeRoyGerber - Friday, August 23, 2019 12:15 PM | Last reply by pituach - 17 hours 15 minutes ago -
0 Votes
Wrap in a Transaction with an Output Clause
So we have a Data Repair we need to make and our DBA is asking me to "wrap the T-SQL in a Transaction and use an Output clause with a Rollback" to determine the effect of the Data Repair. ...Unanswered | 1 Replies | 131 Views | Created by ITBobbyP - Friday, August 23, 2019 4:18 PM | Last reply by pituach - 18 hours 20 minutes ago -
0 Votes
get a rows for every day in a date range?
I have a table that indicates the periods of work on the project. I want to get a list of active projects for every day: THEME_PROJECT ...Answered | 1 Replies | 108 Views | Created by Aleks Roth - 21 hours 26 minutes ago | Last reply by pituach - 19 hours 57 minutes ago -
0 Votes
Update a column in a table with all possible combinations of values within a single column in SQL
Hello, How can I update a column in a table with a value from other column for all possible combinations ? Example: ...Unanswered | 1 Replies | 99 Views | Created by Kiran84 - 21 hours 43 minutes ago | Last reply by Viorel_ - 20 hours 53 minutes ago -
0 Votes
Open XML getting Error - Only one top level element is allowed in an XML document.
i was trying to parse this xml by open xml DECLARE @xml_text XML, @i INT SELECT @xml_text = ' <Broker ...Answered | 2 Replies | 108 Views | Created by Sudip_inn - Saturday, August 24, 2019 11:07 AM | Last reply by Dan Guzman - Saturday, August 24, 2019 11:52 AM -
0 Votes
How can I satisfy a Variable using SELECT FROM OPENQUERY
By itself...this works SELECT * FROM OPENQUERY([LinkedServer],'SELECT * FROM [Schema].[dbo].[TableName]') But this does ...Unanswered | 3 Replies | 153 Views | Created by ITBobbyP - Friday, August 23, 2019 8:36 PM | Last reply by Erland Sommarskog - Saturday, August 24, 2019 9:36 AM -
0 Votes
How to have a not null and unique SSN column where SSN data is not always available
I am trying to figure out how to create an iterating proxy SSN to insert where a SSN is not yet available on new accounts, because in this application the SSN is used, along with other column values, ...Unanswered | 2 Replies | 742 Views | Created by RavenCohoSalome - Friday, August 23, 2019 6:25 PM | Last reply by RavenCohoSalome - Saturday, August 24, 2019 12:17 AM -
0 Votes
Building a Time Machine for Data
Hi All, I'm looking for some general direction on a query that I need to build for a report that I have been asked to write. The report is basedon oilfield data ...Unanswered | 4 Replies | 152 Views | Created by Phill D - Friday, August 23, 2019 3:24 PM | Last reply by Phill D - Friday, August 23, 2019 8:28 PM -
0 Votes
PS Extended Events Read
Hi Experts, I have query related to streaming extended events using the PS. Dan Sir assisted me with a solution like below CREATE TABLE ...Answered | 7 Replies | 309 Views | Created by Priya Bange - Thursday, August 22, 2019 9:56 AM | Last reply by Priya Bange - Friday, August 23, 2019 6:01 PM -
0 Votes
SQL Unit Testing Advice Best Practices
Hello Community, Can someone please advise on the best methods to deploy for unit testing SQL queries. I have read something about tSQLt, but I'm ...Unanswered | 3 Replies | 129 Views | Created by carlton7372 - Friday, August 23, 2019 4:14 PM | Last reply by Tom Phillips - Friday, August 23, 2019 4:55 PM -
0 Votes
How to do full outer join with three queries
I have three queries that I need to do a full outer join on the fields Week and Year. Only those results with matching Weeks and Years will be in the result. Do I need to create temp tables ...Answered | 3 Replies | 234 Views | Created by TWIKLE - Thursday, August 22, 2019 11:18 PM | Last reply by TWIKLE - Friday, August 23, 2019 4:39 PM -
7 Votes
Tsql Query to read data between brackets
Hi All I want the query to read the data between the brackets. I have table like ...Answered | 5 Replies | 16285 Views | Created by xXShanXx - Friday, June 14, 2013 2:26 PM | Last reply by Jingyang Li - Friday, August 23, 2019 4:10 PM -
0 Votes
Update with CTE and sub-query expressions
Hello World! I've posted the problem previously but I keep missing the big picture. I need to calculate the maximum value from multiple columns of every row in a table. ...Answered | 3 Replies | 109 Views | Created by deskcheck1 - Friday, August 23, 2019 3:07 PM | Last reply by Jingyang Li - Friday, August 23, 2019 3:49 PM -
0 Votes
How to get Column Name of Maximum record in a row
Hi all, Suppose I have a table created as follows: CREATE TABLE [dbo].[Table1]( [MUKEY] [int] NULL, [LU11] ...Answered | 2 Replies | 136 Views | Created by deskcheck1 - Friday, August 23, 2019 12:45 PM | Last reply by Guoxiong - Friday, August 23, 2019 2:36 PM -
1 Votes
IIF with a date - conversion failed error
Hello I have a date column in a report that is often null. I need to highlight this in reports and want to do something like, IIF(a.date is ...Answered | 2 Replies | 132 Views | Created by William Faulkner2 - Friday, August 23, 2019 1:25 PM | Last reply by William Faulkner2 - Friday, August 23, 2019 2:20 PM - Items 1 to 20 of 93521 Next ›
No announcements
