SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• COUNT(*) returns wrong value

  Hi I have some difficulties getting a COUNT(*) on my below SQL Query, atleast one that returns the …

  sk 939

  4 replies

  6 years, 11 months ago

  By: Jonathan AC Roberts

• Rewrite query

  Hi, Is there another way of writing this query without first having to get the MAX date for an id a…

  PiMané

  22 replies

  6 years, 12 months ago

  By: Jason A. Long

• Your Opinion? New "ReSharper" tool for SQL Server

  Need to modify your Database Objects without breaking dependent Applications? Or enforce …

  ethouin 94797

  9 replies

  6 years, 12 months ago

  By: ethouin 94797

• Unzip only a single file from all the files using Execute Process Task

  Hi, I have a zip file and I am using Execute Process Task to Unzip them. Below is the Expression I …

  kashyap4007

  5 replies

  6 years, 12 months ago

  By: Phil Parkin

• Inconsistent results with parameter / variable pulling from Oracle

  In the self-same SSIS package, I have two data flow tasks. Each connects to the same Oracle server …

  Michael Gerholdt

  3 replies

  7 years ago

  By: Michael Gerholdt

• Simple Data Deployment Stored Procedure

  HiI'm not T-SQL/SP expert. Is it possible to write a small procedure that can copy the data/result …

  rotcha99

  2 replies

  7 years ago

  By: sgmunson

• Comparison between multiple sql views join statement

  Experts,I am trying to  bring the result from  multiple sql views . Below is my code.SELE…

  ShawnBryan

  3 replies

  7 years ago

  By: sgmunson

• Join date ranges with data from 2 tables

  Hello:I have 2 tables with data as below:create table #product(product_id int, product_name varchar…

  ganeshmuthuvelu

  5 replies

  7 years ago

  By: drew.allen

• need help on Derived table

  I have table named family with familyid,totalcount,adultcount,childcount now i need to create deriv…

  saptek9

  3 replies

  7 years ago

  By: jcelko212 32090

• Extract XML values stored in colums of table

  Hi I have  at Table named "triggers" with a column named "body" that contain XML data that I n…

  sk 939

  1 replies

  7 years ago

  By: sk 939

• Loading html file data to SQL Server table

  HI, I have data in a website and I want to load that to my database. For now, I am looking for only…

  kashyap4007

  1 replies

  7 years ago

  By: Sue_H

• MDX: how to find poorly performing measures

  I have an MDX query with 220 measures (don't ask) that is performing poorly and I'd like to find an…

  andre.quitta

  1 replies

  7 years ago

  By: sgmunson

• Help with Join

  Hi Guys, I'm hoping for some help with these joins. From my sample data you will see I am get dupl…

  craig.jenkins

  2 replies

  7 years ago

  By: Sergiy

• Automate date to always show current Tuesday

  Hi Guys, At the moment I have to run the a query and manually change the date every Tuesday. So eve…

  craig.jenkins

  8 replies

  7 years ago

  By: craig.jenkins

• SSIS Package run from Visual Studio but fails from SQL Server Agent with the Error: Exception has been thrown by the target of an Invocation.

  HI,I have an SSIS Package which goes to a website using http connection and gets a zip file and loa…

  kashyap4007

  9 replies

  7 years ago

  By: kashyap4007