Hi Nenad,

Yes, this can be painfull. Therefore is better to use the pattern IF NOT EXISTS - CREATE than IF EXISTS - DROP. In case of stored procedures it would...

Hi Carlo,

Thanks for your posts and reminders to batch separator settings.

I referred to GO as a common and widely used batch separator in SQL Server world, not to it as...

I would recommend BIDS Helper for this task (and not only for this). It's a great extension for business intelligence development studio (BIDS). Here is the link https://bidshelper.codeplex.com/wikipage?title=Variables%20Window%20Extensions

No, you need to provide scripts for creating tables from your sample query and fill them with a...

You can use SQL Server Management Objects (SMO) to programmatically script out database objects. An intro to SMO scripting you can find here: http://technet.microsoft.com/en-us/library/ms162153.aspx

Could you please post the definition of the function? This can help us to focus to problems in your UDF instead of discussing potential problems with any UDF.

Generally, the parameter...

Maybe something like this...

WITH cte AS

(

SELECT DISTINCT dbpatid

FROM epsallcontracts

)

SELECT dbpatid,

CASE WHEN

(

(SELECT SUM(LdgAmt) FROM epsallcontracts ec WHERE ec.dbpatid = cte.dbpatid)

=

(SELECT SUM(LedgerAmount) FROM epstransactions et WHERE et.patientid = cte.dbpatid)...

Sorry, I did not see the declaration:

declare @Acct int = 1

Then we will just slightly modify the statement from my previous post:

DECLARE @Acct INT = 1;

MERGE @TextTable AS target

USING (SELECT...

I guess that the problem was to identify the frist monday in a year and...

--first Monday of the month

SELECT DATEADD(day, DATEDIFF(day, '19000101', DATEADD(month, DATEDIFF(month, '19000101', GETDATE()), '19000101')-1) /7*7 + 7, '19000101');

--first Monday of the year

SELECT DATEADD(day, DATEDIFF(day, '19000101', DATEADD(year, DATEDIFF(year, '19000101', GETDATE()),...

This is one case where SQL Server 2014 In-Memory OLTP is successfully implemented.

https://blogs.technet.com/b/dataplatforminsider/archive/2013/07/30/sql-server-2014-in-memory-oltp-bwin-migration-and-production-experience.asp

The following merge statement replicates text description from the FIRST row in the temmp variable @TextTable to the rows which position is defined in the second table variable @tempTable. From...

First you can create a function converting a string to table. For instance you can use this one:

CREATE FUNCTION dbo.StringToTable

(

@Input NVARCHAR (4000),

@Delimiter NVARCHAR(1)

)

RETURNS @OutputTable TABLE (val NVARCHAR(50))

AS

BEGIN

...

If you need details about customers and their running totals for each day you would need a table or function generating one entry for each day. For instance you could...

DECLARE @t AS TIME = '2:15:00.000';

SELECT

DATEPART(hour, @t) +

(

DATEPART(minute, @t) * 60 +

DATEPART(second, @t) + DATEPART(millisecond, @t) * 1.0/1000

) * 1.0/3600 AS FormattedTime