richardmgreen1 (5/28/2015)

---

Hi Sean

Here's the insert statement:-

set dateformat dmy

truncate table [CDSExtractInpatients6.2].dbo.CDS_Inpatients_CDS_Feeds_Import

INSERT INTO [CDSExtractInpatients6.2].[dbo].[CDS_Inpatients_CDS_Feeds_Import]

SELECT

CdsType,

i.CdsUniqueIdentifier,

CONVERT(VARCHAR(10),CdsExtractDate,120) AS [Extract_DATE],

CONVERT(VARCHAR(10),CdsReportPeriodStartDate,120) AS [Report_Start_DATE],

CONVERT(VARCHAR(10),CdsReportPeriodEndDate,120) AS [Report_End_DATE],

CONVERT(VARCHAR(10),cdsactivitydate,120) AS [Activity_Date],

-- Updates Prime Recipients for Null & Old Pct_Codes

Case

When CdsPrimeRecipient...

AswinKrishnan (5/28/2015)

---

Dear All,

How can we identify the Date Format from a String in SQL Server.

I might get an input from external source as "MM-DD-YYYY" or "DD-MM-YYYY" or "YYYY-MM-DD" or "YYYY-DD-MM",...

dale_berta (5/28/2015)

---

I think I prefer [/url] as a better reference for character naming.

0022, ", is QUOTATION MARK.

0027, ', is APOSTROPHE.

The other two you mentioned are 2017 and 2018, LEFT and...

Richard Warr (5/27/2015)

---

Just out of interest is there a rule or convention on what these symbols are called? Strictly speaking,

' is an apostrophe, and

" is a quote.

Confusion sets in...

devsql123 (5/27/2015)

---

Hi Friends,

I want to change Set clause of Update Statement dynamically based on some condition.

Basically i have 2 Update statments having same FROM clause and same JOIN clause.

Only diff...

I am just surprised...

Luis Cazares (5/26/2015)

---

I know while loops aren't bad even if they're used for data processing and not administrative tasks. That's why I wrote the article, to show how loops can...

Oh boy...looking back at my post...

SQL-DBA-01 (5/22/2015)

---

HI Guys,

I'm automating some of the TDE stuff and while doing so stuck somewhere. I'm unable to use section [ENCRYPTION BY PASSWORD = ''"' + @db_pswd + '"'' ]...

Adrian Sims-154382 (5/22/2015)

---

Hi,

I have a 3rd party product that has tables and object within the dbo schema of a given database, and I would like to set up dedicated AS400...

Thanks for the table. Unfortunately you didn't post the select statement, the insert statement, the source table ddl or the sample data. From what you posted it sounds like maybe...

Yes indeed!!! Welcome to the "water cooler" commonly referred to as "the thread". 😀

You still haven't posted the ddl for the base tables here so we can build this on our systems to test with. Your code now is further from accomplishing the...

Hi and welcome to the forums. Your trigger doesn't make much sense to me. You have specified it to be a trigger for insert, update and delete. However, it doesn't...

newbieuser (5/19/2015)

---

Ok..Here is the background.. This SQL runs from our application connected to SQL Server via ODBC. TABLE1 in the SQL is an oracle table, queried via linked server. We...