Lukasz8519 asked

update table many times in one procedure

Nov 2, '18 stored-procedures·azure sql db·update_query

tlenzmeier asked

Categorizing ACH Transactions

Nov 1, '18 sql-server·like·charindex·patindex

csouchik published

Finding the MIN of a group of values not used in a previous group

Nov 1, '18 tsql

Jon Crawford answered

How to Use TSQL to Query JSON String into its Component Parts?

Oct 30, '18 query·tsql·json

Jon Crawford answered

Multiples values from xml document not extracted

Oct 30, '18 xml

Kev Riley answered

Where can I obtain Microsoft.ACE.OLEDB.16.0 Provider?

Oct 30, '18 microsoft-access-database-engine

Jon Crawford answered

How do I loop through a date range and count only the weekdays?

Oct 30, '18 count·date·loop

Jon Crawford answered

Using WHERE in a CAST Query

Oct 29, '18 sql·where·cast

Jon Crawford answered

Why is the .bak file from Sql Server 2014 is bigger in size as compared to .bak file from Sql Server 2008 for same database

Oct 29, '18 sql server 2014

Invalid Objet Name SSIS, Error code: 0x80004005

Oct 29, '18 ssis

prathik answered

Issue while using like operator with regex expression

Oct 28, '18 sql-server-2012·like·filter·expression·regex

Ash88 asked

Getting 'the network path was not found' error while downloading excel file from SharePoint site in SSIS.

Oct 27, '18 ssis excel

tpez published

I have a powershell script below that imports data from a filepath to a table in sql server management studio. It runs painfully slow. Is there anyway that is recommended to speed it up?

Oct 26, '18 sql·import-data·powershell·export-data

Jon Crawford answered

Select Top N Query

Oct 26, '18 sql-server-2012

sathismca commented

Need result for below

Oct 25, '18 sql-server-2008·sql server 2008 r2