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 ...
-
1 Votes
How to select last N columns
i have table which has 15 columns and last 10 column has name like Year2010, Year2011.....Year2020 so i need to show data from last 8 column. how can i do it without mention ...Unanswered | 2 Replies | 29 Views | Created by Sudip_inn - 1 hour 3 minutes ago | Last reply by nkumar230 - 46 minutes ago -
0 Votes
Incorrect syntax near 'DISTRIBUTION'. Unable to use the word DISTRTIBUTION in TRANSACT_SQL
Unable to use DISTRIBUTION in New Query red underline under REPLICATE and error msg " incorrect syntax near distribution ". Originaly I had pasted it in but thought it might contain extra ...Proposed | 1 Replies | 25 Views | Created by davidpapkin - 1 hour 1 minutes ago | Last reply by Dan Guzman - 50 minutes ago -
0 Votes
Require Query to Retrive data of Count of Applied leaves by Month wise in Horizontal way
--Leave_Table--Columns [LeaveDetailsID] [bigint] IDENTITY(1,1) NOT NULL, (Primary Key) [EmployeeLoginName] [varchar](200) NOT NULL, ...Unanswered | 18 Replies | 821 Views | Created by VinothKanna - Monday, September 30, 2019 10:38 AM | Last reply by VinothKanna - 1 hour 48 minutes ago -
0 Votes
Is a database in an availability group?
(Correct forum?...) Is there T-SQL command or code that can check if a specific database is already in an AG? I don't necessarily need the name of the AG, only whether the DB ...Proposed | 6 Replies | 116 Views | Created by District9 - 18 hours 37 minutes ago | Last reply by Kris_SQL - 2 hours 13 minutes ago -
0 Votes
Rolling 12 Months Query To Count Customers
Hello, could someone please help me write a query that would on rolling 12 months basis count number of distinct customers that are newly acquired (first transaction ever), reacquired (were newly ...Unanswered | 5 Replies | 83 Views | Created by Dodi_777 - 12 hours 37 minutes ago | Last reply by Rachel_Wang - 3 hours 10 minutes ago -
1 Votes
Case when is not working please
I am trying to assign the value 0 for the result isnull else the value should be 1 If Minclockin is null then the value should be 0 else 1. How can make it ...Proposed | 5 Replies | 141 Views | Created by polachan - Monday, October 14, 2019 10:39 AM | Last reply by Rachel_Wang - 4 hours 11 minutes ago -
0 Votes
sqlcmd from Express
We are moving our database from an SQL Express version to a Web Version and our scheduled tasks no longer work. Below are the 2 scripts we were running from a windows batch file and need to have ...Unanswered | 3 Replies | 108 Views | Created by David Chase89 - 21 hours 37 minutes ago | Last reply by Rachel_Wang - 4 hours 32 minutes ago -
0 Votes
How to avoid cross joins
Hi In my query I am trying to join on both month and year to join with another table. But this is creating cross joins and taking long time to run the query. Is there any way ...Unanswered | 3 Replies | 59 Views | Created by AlwaysLearner08 - 7 hours 52 minutes ago | Last reply by Olaf Helper - 4 hours 56 minutes ago -
0 Votes
Argument data type datetime is invalid for argument 3 of json_modify function
Hi, JSON_MODIFY does not support many base types in the 3rd argument. How fix it? DECLARE @info ...Answered | 5 Replies | 160 Views | Created by VishalMittal - Monday, October 14, 2019 10:11 AM | Last reply by VishalMittal - 5 hours 29 minutes ago -
0 Votes
Execution Plans vs Statisics I/O
Whats difference between using execution plans vs statistics i/o to analyze and troubleshoot in sql server?Proposed | 4 Replies | 87 Views | Created by CoolKid30 - 13 hours 45 minutes ago | Last reply by Shanky_621 - 5 hours 50 minutes ago -
0 Votes
Using a Variable in a Muti-Statement Table-Value Function
I am try to create a function that returns a table. I am passing the Database name as a parameter. I get a message 'Must declare the table variable ...Proposed | 15 Replies | 490 Views | Created by JeffreyPMc - Wednesday, October 9, 2019 11:34 PM | Last reply by Will_Kong - 5 hours 51 minutes ago -
0 Votes
Problem executing a stored procedure inside another stored procedure from a linked server
Hello there guys! I'm having a problem and I don't know how to solve it, I have searched the web and found good advice but I can't work it ...Unanswered | 2 Replies | 85 Views | Created by laghart - 15 hours 25 minutes ago | Last reply by Rachel_Wang - 5 hours 53 minutes ago -
0 Votes
How to create a Stored Procedure which will truncate and insert two tables
Hi I am trying to create a stored procedure which will truncate and insert two tables. Below is the structure of my stored procedure Create ...Proposed | 2 Replies | 90 Views | Created by AlwaysLearner08 - 14 hours 34 minutes ago | Last reply by Arulmouzhi - 7 hours 49 minutes ago -
0 Votes
How to list all the index from full-text catalgoue?
Hi, I know if specifying any keyword as below, all the index related the word can be retrieved, but I'd like to know the way to list the all the ...Proposed | 3 Replies | 359 Views | Created by nac1234 - Friday, November 23, 2018 9:42 AM | Last reply by nac1234 - 8 hours 39 minutes ago -
0 Votes
Conversion of Database from .db file to MYSQL or MSSQL
i have file which is of extension .db named exactly as (xxx.db) and it contains all the data information of my application and how to view this database file using what database ...Answered | 6 Replies | 8688 Views | Created by Gowtham Talluri - Monday, June 29, 2009 11:56 AM | Last reply by ShanayaS - 9 hours 1 minutes ago -
0 Votes
Out of Stock days and count
from jan 03 till jan 05 product_number 1 from location_number 12 was 3 days ...Proposed | 5 Replies | 159 Views | Created by ZaraJ - 21 hours 1 minutes ago | Last reply by Jingyang Li - 9 hours 16 minutes ago -
0 Votes
SQL Change Tracking Issue PT3
OK, lets start from the begininig with fresh data. The table structure I'm working with is as follows: CREATE TABLE PrestigeCars.dbo.data_source_table ( ...Answered | 9 Replies | 390 Views | Created by cpatte7372 - Friday, October 11, 2019 3:29 PM | Last reply by cpatte7372 - 14 hours 53 minutes ago -
0 Votes
Remove the Log file of a database
We have a database that is in Simple Recovery Mode. It has a log file that keeps growing very quickly 10GB in a couple of days. We want to delete it, remove it ...Unanswered | 2 Replies | 108 Views | Created by vsla - 18 hours 5 minutes ago | Last reply by Tom Phillips - 17 hours 46 minutes ago -
0 Votes
Select and remove value from EmpName while ignoring certain value
How to select data under the table 'EmpID' or 'EmpName' that has NOT the value '_N' behind their name Example, EmpID ...Unanswered | 12 Replies | 203 Views | Created by Zetsubo69 - Monday, October 14, 2019 5:25 AM | Last reply by Arulmouzhi - 17 hours 47 minutes ago -
0 Votes
Gathering Business Requirements & Determining Schemas
Whats best way to gather business requirements and determine and build Schemas within sql server? ThanksAnswered | 1 Replies | 100 Views | Created by CoolKid30 - 19 hours 18 minutes ago | Last reply by Arulmouzhi - 18 hours 54 minutes ago - Items 1 to 20 of 93913 Next ›
No announcements
