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
Rows to Columns
Hi all, this question may have been asked many times but I cant get my data work with the sample queries I found on different sites, I have a ...Unanswered | 6 Replies | 231 Views | Created by hatra - 7 hours 24 minutes ago | Last reply by Erland Sommarskog - 14 minutes ago -
0 Votes
Convert rows to columns using t-sql.
Hi All, I have a table with below 6 columns.... I want to convert the source records from rows to columns using t-sql. Due to sensitive data, I am posting sample data. ...Answered | 2 Replies | 325 Views | Created by sql9 - Friday, December 6, 2019 8:55 PM | Last reply by sql9 - 1 hour 2 minutes ago -
0 Votes
Data insert from xml to table by OPENROWSET
1) my data base is installed in machine 1 and i am connecting to db from my machine 2. here xml file path given \GeoPITS_Test_XML.xml 2) do i need to copy xml ...Proposed | 3 Replies | 485 Views | Created by Sudip_inn - Sunday, December 8, 2019 4:37 PM | Last reply by Yitzhak Khabinsky - 2 hours 13 minutes ago -
0 Votes
Splitting total time by day (Start & End crosses midnight)
Hello, I have a query that returns records for a category and their Start/End times. I need to calculate the total time between the start/end. This works fine with Datediff, but I ...Answered | 4 Replies | 98 Views | Created by hellomynameiskayla - 5 hours 31 minutes ago | Last reply by Jingyang Li - 2 hours 34 minutes ago -
1 Votes
list of columns and their datatype returned from SP
hello all, i have a stored procedure which will return nearby 40 columns from different tables. now my doubt is, how do i find all columns returned from the SP and corresponding ...Unanswered | 7 Replies | 151 Views | Created by vclub.it - 10 hours 35 minutes ago | Last reply by Viorel_ - 2 hours 53 minutes ago -
0 Votes
Calculating percentage between two values in one column
I have one column that hold multiple values. For example 'Sold', 'In production','resale', 'recycle' etc. I need to calculate the percentage of assets that went to resale versus ...Unanswered | 1 Replies | 83 Views | Created by KingRBG2009 - 4 hours 58 minutes ago | Last reply by Ana Gauna - 4 hours 33 minutes ago -
0 Votes
To create the function to find the Net Varance after take off maximum 10 mins from NetClockMins for Extra ClockinMins and . 10 Mins from NetClockMins from extra time clockout.
an employee supposed to be worked 9am to 5pm , 30 mins break. How get the code to the function to find the Net Varance in Hrs clocked, after take off ... -
0 Votes
OpenrowSet throws exception-Login timeout expired
ola, when i execute below query then it throws following exception SELECT col1, col2, col3 INTO ...Unanswered | 4 Replies | 116 Views | Created by vclub.it - 10 hours 1 minutes ago | Last reply by vclub.it - 8 hours 27 minutes ago -
0 Votes
Growth Factor on Year-to-Year, Month-to-Month Quarter-to-Quarter
Hi All, below is my ...Answered | 8 Replies | 375 Views | Created by skmnaik - Sunday, December 8, 2019 8:03 AM | Last reply by skmnaik - 8 hours 38 minutes ago -
1 Votes
sp_helptext give wrong store procedure
I tried to get a store procedure with sp_helptext. In result it gives me almost same name another store procedure. That suffers me a lot. Is That a Bug?Unanswered | 12 Replies | 207 Views | Created by RezaurRahman - 15 hours 26 minutes ago | Last reply by Tom Phillips - 11 hours 6 minutes ago -
0 Votes
Table Takes long time to Delete Crores of Records
0) Begin Delete Top(100000) from dbo.TableA where Primary_key_Field in (select distinct Primary_key_Field from ...Unanswered | 5 Replies | 393 Views | Created by Rajkumar Sivanpandi - Sunday, December 8, 2019 1:52 PM | Last reply by Erland Sommarskog - 13 hours 17 minutes ago -
0 Votes
CTE - grouping question
Hello - please can you help? I currently use a longish query with a couple of CTEs that helps me total / rank the number of orders received per ...Answered | 4 Replies | 205 Views | Created by William Faulkner2 - 15 hours 26 minutes ago | Last reply by William Faulkner2 - 14 hours 2 minutes ago -
0 Votes
How to calculate local time based on GMT?
Hello Experts, I am trying to figure out the local time for various countries based on the GMT time data I have for them. I would also need to know if any of them observe Daylight ...Unanswered | 3 Replies | 339 Views | Created by Bangaaram - Friday, December 6, 2019 2:44 PM | Last reply by Rachel_Wang - 14 hours 8 minutes ago -
0 Votes
Check if the column exist and then update
I am checking if the column exist and then I am trying to update the column but the script is erroring out with Invalid column error. IF COL_LENGTH('Table', ...Unanswered | 4 Replies | 398 Views | Created by Lio1972 - Friday, December 6, 2019 2:50 PM | Last reply by Rachel_Wang - 14 hours 17 minutes ago -
0 Votes
Finding timegap between Customer and Company Communications in Claims Data
Hi All, Hope you are doing well!...I am working on a table that has the communications that happen between a customer who buys the product online from Amazon and the company which ...Answered | 4 Replies | 403 Views | Created by Hellothere8028 - Friday, December 6, 2019 10:30 AM | Last reply by Hellothere8028 - 14 hours 23 minutes ago -
0 Votes
How to map Security/Logins users?
If I right click on a login userAdmin, Properties, User Mapping, under "User mapped to this login:", I check the myDatabase I wanted and then under the "Database role membership for: ...Unanswered | 2 Replies | 566 Views | Created by Charlie2 - Friday, December 6, 2019 4:37 PM | Last reply by Rachel_Wang - 14 hours 56 minutes ago -
0 Votes
BI Developer
kjksjs/gsl sss/kvlkfklkvlfkl/Liyabona-- >gsssssskgjs/kfs Kind RegardsUnanswered | 4 Replies | 829 Views | Created by Elly-Joy - Saturday, December 7, 2019 8:25 PM | Last reply by Rachel_Wang - 15 hours 56 minutes ago -
0 Votes
Performance tuning Logical read
Hi All, I have a search query which utilizes 2 parameters to give search result back. I have index on both parameters. I want to bring it down logic read from higher number (15K) to lower number part ...Unanswered | 7 Replies | 167 Views | Created by rommy08 - 17 hours 59 minutes ago | Last reply by Soumen Barua - 17 hours 17 minutes ago -
0 Votes
Need help on SQL select
Hi all, I have data as below and would like to run a query to extract data as the example below. ID1 ...Answered | 2 Replies | 456 Views | Created by ddee - Sunday, December 8, 2019 5:52 PM | Last reply by ddee - Sunday, December 8, 2019 9:37 PM -
0 Votes
Find the average distance between the house of one employee and other employee's houses in the column
I am working on a practice question in SQL. A sample database of employees is provided. The screenshot attached contains the details of the employees. It also includes their ...Proposed | 5 Replies | 1019 Views | Created by karanhindocha8 - Saturday, January 19, 2019 11:53 AM | Last reply by scott_morris-ga - Sunday, December 8, 2019 12:40 PM - Items 1 to 20 of 94306 Next ›
No announcements
