SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• OLEDB and Attunity both are slow with CLOB IN SSIS

  Hi Guys I need you help again I am using Auutinit drivers to extract the data from Oracle Table. On…

  learningsqlkid

  3 replies

  6 years, 4 months ago

  By: frederico_fonseca

• Writing a Complex View

  I'm working on combining the latest record from a number of tables to create one view with the most…

  yoyodynedata

  5 replies

  6 years, 4 months ago

  By: yoyodynedata

• Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

  Can this stored procedure be modified to work properly?  When trying to save, SQL Server retur…

  cchapel

  3 replies

  6 years, 4 months ago

  By: sgmunson

• SQL to write a condition to qualify Members with consecutive days of stay in same and different hotels

  I have hotel A and hotel B. A Member should not earn multiple Credits if a reservation is booked a…

  sanket.wagh7689

  6 replies

  6 years, 4 months ago

  By: drew.allen

• Insert in the Insert statement the previous value from the before value

  CREATE TABLE [dbo].[dt](    [dtVal] [datetime] NOT NULL,    [dtV…

  GG_BI_GG

  6 replies

  6 years, 4 months ago

  By: GG_BI_GG

• I need solution for this problem

  Hi All,I need a solution for this problem please help me First Create table like below querycreate …

  tvrarundeepak

  15 replies

  6 years, 4 months ago

  By: tvrarundeepak

• Automate daily table backup

  Hi,i have task is assigned to take the table backup daily wise.below is the formattablename_yymmdd …

  Diyas

  15 replies

  6 years, 4 months ago

  By: Jeff Moden

• How can I make my SQL statement smaller so my server doesn't time out?

  so I have the following problem. I have three tables in my postgresql DB. They are: package, cartyp…

  a.sophiewirth

  15 replies

  6 years, 4 months ago

  By: sgmunson

• float error in t-sql scalar function

  Hello Everyone, The below code is giving me error:Msg 3623, Level 16, State 1, Line 27An invalid fl…

  akapellas

  44 replies

  6 years, 4 months ago

  By: Sergiy

• Sql query row value if exists

  Dear All, i would like to  create the virtual column result with if exist condition. Example&n…

  ShawnBryan

  6 replies

  6 years, 4 months ago

  By: sgmunson

• Update table using inner join

  SELECT x.pkproductid        ,x.supplierbarcodecorrect …

  Shaykh

  10 replies

  6 years, 4 months ago

  By: Nate the DBA

• select random from the records with last date

  hi all, i want to make faster e more elegant a procedure, if possible transorm into a single query.…

  fabriziodb

  2 replies

  6 years, 4 months ago

  By: drew.allen

• Get a count at contacttitle but get 87 row need 22 rows

  select Country, Contacttitle, COUNT(ContactTitle) as Count,CASE WHEN GROUPING_ID() = 0 THEN ''WHEN …

  GG_BI_GG

  3 replies

  6 years, 4 months ago

  By: andycadley

• How to select all in a query but not certain items

  I have the following columns and there are 807k rows in all so this is just example: Line of Busine…

  tinamiller1

  3 replies

  6 years, 4 months ago

  By: sgmunson

• increase performance for SSIS package with BULK INSERT

  I have created a package for our company that takes all the data from a table in our ERP production…

  smantia2292

  12 replies

  6 years, 4 months ago

  By: Jonathan AC Roberts