maybe something like this ??

declare @address as varchar(300)

set @address = 'removeme 100 1st Street Somewhere'

select @address

select ltrim(stuff(@address,1,charindex(' ',@address),''))

helal.mobasher 13209 (6/4/2014)

---

Results:

id NAME addresses CounterName

1 john doe 50 north john doe-001

1 john doe ...

currency format, with symbol and commas, right aligned (output to text or file)

messy 😀

USE tempdb;

GO

DECLARE @testtable TABLE (

[AccountNo] VARCHAR(12) NOT NULL

, [IVTotal] DECIMAL(18, 5) NOT NULL

, [GLTotal] DECIMAL(18,...

Koen Verbeeck (6/2/2014)

---

Lynn Pettis (6/2/2014)

---

Looks like a Cartesian product to me as well.

Looks like someone was writing the query using the ANSI-89 joins but forgot the WHERE clause to properly...

wild guess....OP please provide expected results based on your sample data.....thanks

;with cte_tab as (

SELECT weekdate

, Aid

, Cid

, row_number() OVER (PARTITION BY AID ORDER BY weekdate DESC) rn

FROM Tab1

)

SELECT weekdate

, Aid

,...

lsalih (6/1/2014)

---

Sorry for the late reply, I got busy with other things... Attached is a test file which includes a sample script. The goal is to list person information such...

AndrewSQLDBA (5/30/2014)

---

What about inserting all the rows into the ETL table that I have already verified, and then delete the rows from the ETL table that are already in the...

Andrew...Happy Friday 🙂

any reason why you cant provide more details?

regards

click on the shortcut in the box on the left of the message pane

paste code between the two code blocks

maybe be easier for us to give you a tried and tested answer if you can please provide set up scripts for create table / insert sample data and the...

danaanderson (5/25/2014)

---

J Livingston SQL (5/25/2014)

---

not sure what...

Hi auto....code without the SalesRepId.......based on previous code provided....still using the temp table.

IF OBJECT_ID('#tempsales') IS NOT NULL DROP TABLE #tempsales

SELECT CustID

, SalesRepID

, SaleDate

, eligibility

INTO #tempsales

FROM Sales

CREATE CLUSTERED INDEX cix_jls ON...

not sure what you expect from a...

autoexcrement (5/24/2014)

---

Also, for whatever reason, I wasn't able to get it all working with the 3-part assignment syntax. Maybe my fault. But it's all working great with the more verbose...

http://sqlsouth.wordpress.com/2014/05/23/export-xml-from-sql-server-using-bcp/