v.razaghzadeh (12/14/2016)

---

I just tried this and below is my whole query now:

ITH VALID_CUSTOMERS AS (

SELECT DISTINCT BK.CustomerLoyaltyNumber , rs.RwdMember_id, bk.Day_Uid_TRADE

FROM HUDS.dbo.SALE_Basket AS BK

INNER JOIN HUDS_Analytics.dbo.map_SiteBusinessManager AS GSM

ON GSM.Site_Code =...

halifaxdal (12/15/2016)

---

Sorry, for the later visitor, here is the solution:

DECLARE @test-2 varchar(max);

set @test-2 = 'US01/00000/12345/123456';

set @test-2 = Replace(@test, '/', '.');

SELECT ParseName(@test, 4)

SELECT ParseName(@test, 3)

SELECT ParseName(@test, 2)

SELECT ParseName(@test,...

Just curious if this is any easier?

WITH MyData (A, B) AS (

SELECT 'ProdA', 'ProdB' UNION ALL

SELECT 'ProdB', 'ProdA' UNION ALL

SELECT 'ProdB', 'ProdC' UNION ALL

SELECT 'ProdC', 'ProdB' UNION ALL

SELECT 'ProdD', 'ProdE'...

ChrisM@Work (12/15/2016)

---

yuvipoy (12/15/2016)

---

Hi

Error converting data type nvarchar to float is returning

Select Convert(mycolumn as float) from mytable;

mycolumn is nvarchar(100)

but my destination table is float , so i am converting...

yuvipoy (12/15/2016)

---

Hi

Error converting data type nvarchar to float is returning

Select Convert(mycolumn as float) from mytable;

mycolumn is nvarchar(100)

but my destination table is float , so i am converting to...

Doug.F (12/14/2016)

---

sgmunson (12/14/2016)

---

Doug.F (12/14/2016)

---

Sonova...yep, I see where the hole is, in my logic =/

To be completely honest, I had rewritten it with ISNULL by the time I got back to...

Doug.F (12/14/2016)

---

Sonova...yep, I see where the hole is, in my logic =/

To be completely honest, I had rewritten it with ISNULL by the time I got back to reading the...

SQL-DBA-01 (12/13/2016)

---

Hi Experts

I want to write a windows batch file, to take backup file and once the backup is taken successfully, want to delete the backup files older than 7...

Please don't duplicate your posts. But to answer the question, I just realized that the VALID_CUSTOMERS cte does not have any date controls in it. It...

Yes, but that assumes that the values "StartDate" and "EndDate" are always...

squvi.87 (12/14/2016)

---

Need to generate random number based on ID3 column. Have mentioned each rows logic in remarks. Note: This is a sample data I need to apply on big set...

Manic Star (12/13/2016)

---

Hi,

Getting the message "[Execute Process Task] Error: An error occurred with the following error message: "The requested operation requires elevation"."

I've tried to date:

1) Calling this...

bradwilliams51 (12/14/2016)

---

Hi,

I am creating an invoice report from scratch in report builder, all the report data is correct and working fine. The issue I am having is adding the...

csyz (12/14/2016)

---

Dear NG

I have following issue:

2 Tables (Zusatzfeld, Vorschuss)

dbo.Zusatzfeld

Bold_ID (PK)

WertDatum (the one with the values)

MetaZusatzfeld (the one with Searchvalue)

UserEintrag (connection to dbo.Vorschuss)

dbo.Vorschuss

Bold_ID (PK)

Description (one column with the value)

Projekt (one column...

How about using a well-known highly performant string splitter function, that you can find here:

http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D

SELECT Col1, Col2, S.Item AS Col3

FROM YourTable AS YT

CROSS APPLY dbo.DelimitedSplit8K(YT.Col1, ',') AS S

WHERE YT.Col2 =...