Viewing 15 posts - 1,381 through 1,395 (of 2,452 total)
SELECT *,'pedro' FROM VW_DEVOLVESELECCAO
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 18, 2014 at 9:37 am
appreciate that you have provided sample data....but in your "real" world and to ensure scalability for a solution...can you tell us approx. number of rows in @t table and confirm...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 17, 2014 at 4:15 pm
http://www.sqlservercentral.com/Forums/Topic917650-146-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 17, 2014 at 10:30 am
is this as simple as a cross join?
eg:
SELECT TOP 186 IDENTITY(INT, 4070039 , 37) AS lat
INTO dbo.lat
FROM ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 17, 2014 at 8:26 am
does your function return id or pallet?...this would possibly provide a "join"
maybe better if you posted create table/insert sample data scripts and your expected results...am sure this will result is...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 16, 2014 at 2:17 pm
itortu (6/16/2014)
no duplicates, different quote number and quote date
may not be relevant ...but I beg to differ on duplicates in your test data
script
insert into dbo.salesquotestest values('QUO-10566-0', 'X16093', '10024', '2', ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 16, 2014 at 12:04 pm
I think you have duplicate rows in the data...can you please check.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 16, 2014 at 11:23 am
my effort...too much time on my hands 😀
DECLARE @Question VARCHAR(100) =
'The Answer to the Ultimate Question of Life, the Universe, and Everything'
DECLARE @Source VARCHAR(100) =
'The Hitchhikers Guide to the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 16, 2014 at 4:18 am
cbrammer1219 (6/14/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 15, 2014 at 1:22 pm
Jeff...+1 many times 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 14, 2014 at 2:00 pm
if as OP was specific about "spaces"...heres a first cut ....may be a start??;-)
--drop table #tempcall
SELECT
ID = IDENTITY(INT, 1, 1),
RTRIM(LTRIM(REPLACE(REPLACE(REPLACE(REPLACE(SUBSTRING(calldata,0,7),'-',''),'%',''),'+',''),'/','-'))) as...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 14, 2014 at 9:39 am
Tallboy (6/13/2014)
1234, 10/1/14, 42.75, 84.001234, 9/2/14, 11.25, 12.00
1111, 10/1/14, 10.50, 23.00
maybe I misread your requirements...but I thought that the week end date was a Sunday?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 14, 2014 at 3:22 am
who set the requirement?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 14, 2014 at 12:36 am
jorichard31 (6/13/2014)
Select tmp.* from openquery( [LinkedServerName], 'select * from viewname1' ) as tmp. When I executed this query, I am getting below error. Could you please help?...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 1:22 pm
Sean Lange (6/13/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 13, 2014 at 11:07 am
Viewing 15 posts - 1,381 through 1,395 (of 2,452 total)