No announcements
-
1 Votes
Who will be announced as the next Transact-SQL Guru? Read more about April 2018 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is your chance ... -
0 Votes
POSTING 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
How can I possibly Backup LocalDB deployed by ClickOnce programmatically
I have been trying to write VB.Net Code to programmatically backup LocalDB, that is deployed by ClickOnce, using BACKUP DATABASE command in SQL. My requirement is to back-up the DB upon user request ...Unanswered | 12 Replies | 230 Views | Created by mdshameer - Tuesday, April 03, 2018 6:49 AM | Last reply by mdshameer - 5 hours 2 minutes ago -
0 Votes
I am trying to get a result from our DB of stores in which no credits have been made for old invoices. Does this make sense?
I am trying to get a result from our DB of stores in which no credits have been made for old invoices. Does this make sense? SELECT DISTINCT T0.[DocNum], T0.[DocDate], ...Answered | 2 Replies | 55 Views | Created by jbrotto - Wednesday, April 18, 2018 4:08 PM | Last reply by jbrotto - 5 hours 14 minutes ago -
0 Votes
SQL where case
0 when @includezero = 1 then l.quantity > =0 end http://www.isolutionspartners.com/Unanswered | 3 Replies | 50 Views | Created by Ryan McBee - 8 hours 41 minutes ago | Last reply by Visakh16 - 5 hours 18 minutes ago -
0 Votes
Summary calculation
Hi, I want to update net total in summary table as below create table summary (sno ...Answered | 9 Replies | 65 Views | Created by Antonioy - 14 hours 35 minutes ago | Last reply by Visakh16 - 9 hours 21 minutes ago -
0 Votes
Update with non matching
Hi, I want compare three table and find the record which is not exists in two table CREATE TABLE ...Answered | 4 Replies | 57 Views | Created by Antonioy - 11 hours 44 minutes ago | Last reply by Visakh16 - 10 hours 31 minutes ago -
0 Votes
Remove time portion from character colums
SQL Server 2005 Hi Guys I have a column am_value5 (varchar(254)) and in that column the values are store like below: 3/5/2018 2:00:00 ...Proposed | 25 Replies | 158 Views | Created by Muzokhh - Friday, April 20, 2018 4:14 PM | Last reply by Erland Sommarskog - 11 hours 20 minutes ago -
0 Votes
For a Huge data insert which one is better SSIS or batch wise TSQL query
For a Huge data insert which one is better SSIS or batch wise TSQL query. Thanks LijuAnswered | 2 Replies | 60 Views | Created by Liju Lalithangathan - 20 hours 16 minutes ago | Last reply by Visakh16 - 16 hours 1 minutes ago -
0 Votes
Performance question: In SSIS, use T-SQL or SSIS data flow transforms for linked server table data?
Hi All, Question: In SSIS, should we be using Execute SQL task or a Data Flow task (with the appropriate transforms) for doing various lookups, filters, and joins from data on ...Unanswered | 1 Replies | 50 Views | Created by SQL Server dude - 23 hours 24 minutes ago | Last reply by Soumen Barua - 19 hours 1 minutes ago -
0 Votes
Duplicate Data Issue ...Retaining duplicates
I have a data flowing from outside into table A . The ID column is sometimes same for two similar records ...Unanswered | 1 Replies | 40 Views | Created by usher227 - Friday, April 20, 2018 6:36 PM | Last reply by Visakh16 - Friday, April 20, 2018 6:44 PM -
1 Votes
Where clause with multiple cases
Create table Department ( DepartmentID int null, PriorityID int null ) GO Insert into Department(DepartmentID,PriorityID) ...Answered | 22 Replies | 146 Views | Created by odeddror - Friday, April 20, 2018 3:28 AM | Last reply by odeddror - Friday, April 20, 2018 6:35 PM -
0 Votes
select statement and xml path
Hi, I need to create xml as string from table data. This is how I am doing: declare @tmp table ( id ...Unanswered | 12 Replies | 139 Views | Created by Spunny - Tuesday, April 17, 2018 7:47 PM | Last reply by Visakh16 - Friday, April 20, 2018 6:00 PM -
0 Votes
DATE CONVERSION
Hi, When i try to convert date column with varchar to number it is giving below error Msg 242, Level 16, ...Answered | 11 Replies | 121 Views | Created by Antonioy - Wednesday, April 18, 2018 8:08 AM | Last reply by Jingyang Li - Friday, April 20, 2018 1:08 PM -
0 Votes
how to write case statement for following scenario
= getdate()) or (EndDate>= getdate())) THEN 1 WHEN jobstatus =14 AND ((StartDate>= getdate()) or (EndDate>= getdate())) THEN ...Answered | 10 Replies | 78 Views | Created by Sai Pranav - Friday, April 20, 2018 9:34 AM | Last reply by Visakh16 - Friday, April 20, 2018 12:37 PM -
0 Votes
ROUND VALUE SQL
Hi, Please help to how to round the value in sql query Example : If Value is 3 result 5 If Values ...Answered | 4 Replies | 81 Views | Created by Tiruttani_baskaLakshmi - Friday, April 20, 2018 6:56 AM | Last reply by Visakh16 - Friday, April 20, 2018 10:22 AM -
0 Votes
Can I change SP to use Views rather than Tables
This is a very useful SP, but it doesn't look at the views, is there anyway to modify this to ONLY point to sys.views rather than sys.tables?? CREATE PROCEDURE ...Unanswered | 1 Replies | 51 Views | Created by SimonKEvans - Friday, April 20, 2018 9:31 AM | Last reply by TiborK - Friday, April 20, 2018 9:39 AM -
0 Votes
Alternative to Union All
Hi All, I have a query that runs on the same table but different conditions combined using 'union all' Select * from table where Id =1 union ...Proposed | 3 Replies | 68 Views | Created by gangarocks - Thursday, April 19, 2018 2:10 PM | Last reply by Srinivasa Rao Gude - Friday, April 20, 2018 6:27 AM -
0 Votes
Length of data_file argument Bulk Insert Command in SQL server
Hello Experts, I am using Bulk Insert command to read Mutiple CSV files as File Pattern. When I was executing the command it failed for "Error ...Unanswered | 3 Replies | 64 Views | Created by BSTech - Thursday, April 19, 2018 7:44 AM | Last reply by Xi Jin - Friday, April 20, 2018 6:24 AM -
0 Votes
AWS Redshift vs T-SQL
Hello All, I am SQL Server Developer (t-sql). I am trying to find out which SQL AWS Redshift is using or the difference between AWS Redshift SQL vs T-SQL. Are they same or ...Answered | 4 Replies | 104 Views | Created by Shreepal Bhandari - Thursday, April 19, 2018 11:26 AM | Last reply by Xi Jin - Friday, April 20, 2018 6:00 AM -
0 Votes
please how do i get end of month date with the data for beginning of month status and end of month status
below is my original table(eviction table) i will be pulling my data from: Assetkey AsofDay ...Proposed | 5 Replies | 123 Views | Created by pizaro87 - Thursday, April 19, 2018 3:26 PM | Last reply by Xi Jin - Friday, April 20, 2018 3:16 AM -
0 Votes
sql help
Hello All, I have one special requirement to delete the data for incremental purpose .Data elements year,month and count previous ...Unanswered | 1 Replies | 75 Views | Created by cmk1 - Friday, April 20, 2018 12:54 AM | Last reply by Xi Jin - Friday, April 20, 2018 3:01 AM - Items 1 to 20 of 89364 Next ›
No announcements