Viewing 15 posts - 1,426 through 1,440 (of 2,452 total)
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),''))
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 4, 2014 at 2:55 pm
helal.mobasher 13209 (6/4/2014)
id NAME addresses CounterName
1 john doe 50 north john doe-001
1 john doe ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 4, 2014 at 2:42 pm
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,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 4, 2014 at 7:36 am
Koen Verbeeck (6/2/2014)
Lynn Pettis (6/2/2014)
Looks like someone was writing the query using the ANSI-89 joins but forgot the WHERE clause to properly...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 2, 2014 at 2:23 pm
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
,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 2, 2014 at 12:46 pm
lsalih (6/1/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 2, 2014 at 2:34 am
AndrewSQLDBA (5/30/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 31, 2014 at 11:26 am
AndrewSQLDBA (5/30/2014)
I know this is a little tough with not seeing anything.
Andrew...Happy Friday 🙂
any reason why you cant provide more details?
regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 30, 2014 at 11:52 am
click on the shortcut in the box on the left of the message pane
paste code between the two code blocks
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 30, 2014 at 6:33 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 28, 2014 at 11:47 am
danaanderson (5/25/2014)
J Livingston SQL (5/25/2014)
danaanderson (5/25/2014)
Anyone else have any thoughts? It's surprising that there was only one person replying in a time span of about 23 hours.
not sure what...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 26, 2014 at 8:57 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 25, 2014 at 9:59 am
danaanderson (5/25/2014)
Anyone else have any thoughts? It's surprising that there was only one person replying in a time span of about 23 hours.
not sure what you expect from a...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 25, 2014 at 4:20 am
autoexcrement (5/24/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 25, 2014 at 1:18 am
Jo Pattyn (5/24/2014)
Welkom back wolfkillj, could you fix the link to your blog? It points to the thread.
http://sqlsouth.wordpress.com/2014/05/23/export-xml-from-sql-server-using-bcp/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 24, 2014 at 5:23 am
Viewing 15 posts - 1,426 through 1,440 (of 2,452 total)