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
CASE - IN - COUNT - SUM all in one?
How do I go about not only doing a total count in a case statement but also SUM it all: Eg. Case when TYPE IN ('YR', PR') THEN ...Unanswered | 2 Replies | 40 Views | Created by KittyCat101 - 2 hours 28 minutes ago | Last reply by Rachel_Wang - 7 minutes ago -
0 Votes
SQL Server looking for column that does not exist - is there a way to override this?
IF COL_LENGTH('[PREF System Preferences]','PrefAgeOutPaymentsTF') IS NOT NULL BEGIN Select [PREFAgeOutPaymentsTF] From [PREF System Preferences] Where [PREF Company ID] = 'Demo''s ...Answered | 3 Replies | 48 Views | Created by cupboy1 - 9 hours 39 minutes ago | Last reply by cupboy1 - 3 hours 49 minutes ago -
0 Votes
Find identical result sets per id challenge
Hi everybody, I have following T-SQL challenge: there are 2 tables that store data from UI, header and detail: create table #header (id int, name ...Unanswered | 11 Replies | 83 Views | Created by Pedja Stojakovic - 11 hours 49 minutes ago | Last reply by Jingyang Li - 4 hours 45 minutes ago -
0 Votes
Round up date to whole hour
I have a date column in 2017-07-01 05:15:00 . I want round up the column to whole next hour. for example out put should be 2017-07-01 06:00:00 for 2017-07-01 ...Answered | 5 Replies | 45 Views | Created by Imran Desai - 8 hours 4 minutes ago | Last reply by Jingyang Li - 5 hours 3 minutes ago -
8 Votes
User defined function to add column in existing table
I have a table that looks like this: Date ...Answered | 18 Replies | 279 Views | Created by MilesToGoBeforeISleep - 11 hours 30 minutes ago | Last reply by MilesToGoBeforeISleep - 6 hours 47 minutes ago -
1 Votes
Windowed Function Id per group
Dear all , I need to find all consecutive tickets done per a client in the SAME Store. My final goal is to define the last store where the client did 3 ...Unanswered | 2 Replies | 34 Views | Created by Bohor - 10 hours 51 minutes ago | Last reply by Bohor - 10 hours 4 minutes ago -
0 Votes
SQL: Update Column with random Alpha Numeric values
Hi Guys, I am writing an Update SQL query to update the PIN column in Patient Table. But when I update, I need to check that the same PIN shouldn't be ...Answered | 11 Replies | 171 Views | Created by kkran - Tuesday, August 14, 2018 8:43 PM | Last reply by kkran - 10 hours 7 minutes ago -
0 Votes
Return result from 3 combined queries in stored procedure
Hi Gurus, In re-writing my Access 2010 DB to VB.Net I'm trying to get to grips with the different approach & syntax & capabilities of sql server stored procedure queries. ...Unanswered | 13 Replies | 112 Views | Created by Hugh Self Taught - 19 hours 30 minutes ago | Last reply by Hugh Self Taught - 11 hours 53 minutes ago -
0 Votes
Format varchar string as 00:00
I have a column Task_Created_Time with the value as 3:0 now I want to display the result as 03:00 The Task_Created_Time is varchar datatype and can't be ...Answered | 12 Replies | 101 Views | Created by sudhu99 - 21 hours 7 minutes ago | Last reply by Jingyang Li - 12 hours 5 minutes ago -
0 Votes
More efficient than a SQL - like - join
I would like a more efficient suggestion on doing this join rather than using a like statement as it seems to be slow. INNER JOIN ...Unanswered | 5 Replies | 98 Views | Created by KittyCat101 - Wednesday, August 15, 2018 9:18 PM | Last reply by SwePeso - 12 hours 25 minutes ago -
0 Votes
Maintain table of the last 20 invoices for all clients, deleting older ones as new ones are generated
I have a requirement to have a table that is used to hold just the last 20 invoices for all of our clients and am wondering the best approach to this. I thought of just dropping the table and ...Answered | 5 Replies | 191 Views | Created by FLSojourner - Wednesday, August 15, 2018 8:42 PM | Last reply by FLSojourner - 12 hours 57 minutes ago -
0 Votes
DB Log File dont want to Shrink
shrink > files > log, tried first 2 options not the split allocation Please Help RegardsUnanswered | 2 Replies | 48 Views | Created by Ismailc1 - 13 hours 31 minutes ago | Last reply by Ismailc1 - 13 hours 0 minutes ago -
0 Votes
MailChimp API Key missing - Cannot make connection
i wrote following bit of Code to create a list in MailChimp but constantly getting error that API Key is missing, althought i am passing API key. does anyone know how i can pass ... -
0 Votes
Importing CSV file
Hi, I'm using SQL -2014 to import csv file into my staging table.... Error OLE DB provider "MSDASQL" for linked server ...Answered | 8 Replies | 164 Views | Created by StSingh - Tuesday, August 14, 2018 12:33 PM | Last reply by StSingh - 13 hours 55 minutes ago -
1 Votes
How to sum in the group by query and print the total sum in respective place
66780882 below is my query. SELECT ...Answered | 18 Replies | 296 Views | Created by Gani tpt - Thursday, August 9, 2018 12:15 PM | Last reply by Gani tpt - 15 hours 29 minutes ago -
2 Votes
generated script is not complete
Hello, Please help me..... I implement log shipping by SSMS and when it generates transact script of whole process, its not complete, I mean, when I run it, the ...Answered | 4 Replies | 75 Views | Created by MariamG - 18 hours 0 minutes ago | Last reply by MariamG - 15 hours 37 minutes ago -
2 Votes
How to incrementally Update a table with repeating Monthly columns
Disclaimer - this is not my design or even my company's design There is an AmtHistoryMaster table that has 8 repeated columns for the last 48 months. The month ...Answered | 3 Replies | 155 Views | Created by TheBrenda - Monday, August 13, 2018 9:12 PM | Last reply by Will_Kong - 15 hours 55 minutes ago -
0 Votes
How to know the rows repeated from which table in this query
Problem How to get which relation or table cause duplicate rows or repeated rows this query not all cases show repeated rows only in some cases ...Proposed | 7 Replies | 96 Views | Created by engahmedbarbary - Thursday, August 16, 2018 1:19 AM | Last reply by SwePeso - 16 hours 16 minutes ago -
1 Votes
Make the linked server ask for password
Till today i am using the linked server with the user of sql having same username and password in both the servers. For now on i can not keep the 2 servers password same for some reason and ...Proposed | 8 Replies | 161 Views | Created by IT researcher - Tuesday, August 14, 2018 10:41 AM | Last reply by pituach - 16 hours 54 minutes ago -
0 Votes
Enabling #RCSI on a #database that is part of #CDC
Hey #SQLFamily, I need #sqlhelp! Can I enable #RCSI on a #database that is part of #CDC without things going south?Unanswered | 1 Replies | 41 Views | Created by Steve Rezhener - 20 hours 21 minutes ago | Last reply by Will_Kong - 18 hours 13 minutes ago - Items 1 to 20 of 90493 Next ›
No announcements
