Error when loading CSV file to SQL Server using SSIS. The Column Delimiter was not found - Can someone help me with loading the attached csv file database. The issue here is the CSV file has data with...
Need to modify the Update statement to include combination two new fields instead of one field.i want to write in better way in performance wise. - Need to modify the Update statement to include combination two new fields instead of one field: Current table cp_inv structure: ID, cst1,...
Convert Varchar field - I have a Varchar field with units in inches :( that i need to convert to an integer (Unfortunately the " and...
Store values in one place and access them via various stored procedures - I am creating a number of stored procs for a particular category of things. These store procs will all have...
Clean up a Large Database - I'm looking into cleaning up a Large DB where ID and Timestamp are the fields in question and relevance. Its...
Easiest way to show client query results - I'm trying to figure out how I can basically print my query results and give them to the user before...
Exporting table to text file using BCP and XP_CMDSHELL with TAB column delimiter, not comma delimiter. - This T-SQL works perfectly (and i AM aware of security implications of enabling xp_cmdshell, not an issue here...) DECLARE @table_name VARCHAR(50) ='AgentMaster' DECLARE...
Get list of possible number of guests for a hotel - Hi guys, let me try to explain the problem. There is a hotel with rooms for 2, 3 and 4...
optimization of stored procedure - Below stored procedure taking more time to complete the process.This procedure contains left join with five view.View names are V_PROD_ALIAS_SYN, V_PROD_ALIAS_SITE,...
index scan where seek expected - On a SQL 2016 instance I have a large table with dozens of columns including: COLA INT COLB BIT and nonclustered index: (COLA...
Joins clarification - Let's say I have Table A and Table B. Table A can join onto Table B because both tables have a...
Mirroring - Working on setting up SQL Server mirroring. Following are the steps I am thinking to do.. Take Full Backup and Transaction...
I need some help with Text data type in SQL Server table. - I am trying to insert into table the approximately 74 thousand characters but Text datatype allows me to insert only...
Code to list dates end of month dates between specific start and end date ranges - Hello, Looking to list out end of month dates between a start and an end point in specific data set. For instance, Id ...
Does SQL compression process takes additional temporary disk space?, 1.2 TB database to compress - Compressing 1.2 TB database. Do I need temporary disk space for compression?. My largest table is 132 GB and for compressing,...
change column values to row - I want to change the values in the column to row based on their ID number. What I want to do...
Compute & Rollup - This statement will produce: Select EmpID, Yr, sum(Sales)as Sales from Sales Group by EmpId, Yr With Rollup EmpID Yr Sales
Read flat file but ignore everything in filename after character plus insert date into SQL Server table - I am fairly new to SSIS but not to SQL Server. Here are the conditions of the flat files: 1)...
Healthcare Data Warehouse - Starting new - small scale - Are there any members here in Healthcare? I work a lot with files that we get monthly from insurance companies...
SQL Server 2016 SSIS Basics - We have the Stairway to SSIS, but things have changed. I had a request for installing SSDT and a basic...