Forum Replies Created
Viewing 15 posts - 1,171 through 1,185 (of 15,381 total)
-
RE: Display Live clock event
Are you even using sql server? Your insert statements look like mysql.
What do you expect for output based on your sample data? The business rules here are pretty vague and...
-
RE: Sql Send_Db_mail Vertical Table
Nicely done. I assume you can handle it from here?
-
RE: lookup value for each row
To learn more about APPLY take a look at the two articles in my signature. Paul White's explanation on this is the best one I have seen.
-
RE: lookup value for each row
marc.corbeel (10/14/2016)
This gives me a list of all days, not the rates on 2016-10-3
I thought you wanted each days information. I am guessing as to what you want for output...
-
RE: How to get full name of the employer by getting rid of null values in between
marc.corbeel (10/14/2016)
Sean Lange (10/14/2016)
marc.corbeel (10/14/2016)
Forum admin... this is creepy!I paste a peace of code text with a double space in it, in the topic reply text box, and once saved,...
-
RE: lookup value for each row
You can leverage a tally table for this sort of thing. I keep one in a view on my systems.
create View [dbo].[cteTally] as
WITH
E1(N) AS (select 1 from (values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1))dt(n)),
E2(N) AS...
-
RE: How to get full name of the employer by getting rid of null values in between
swarun999 (10/14/2016)
Thank you all.I tried this It also works.
select Id, ltrim((isnull(Firstname,'') + ' ' + isnull(Middlename,'') + ' ' + isnull(Lastname,''))) as FullName from EmployeeName
This captures most of it but...
-
RE: How to get full name of the employer by getting rid of null values in between
marc.corbeel (10/14/2016)
Forum admin... this is creepy!I paste a peace of code text with a double space in it, in the topic reply text box, and once saved, the double space...
-
RE: How to get full name of the employer by getting rid of null values in between
marc.corbeel (10/14/2016)
Sean Lange (10/14/2016)
marc.corbeel (10/14/2016)
here is how I do thisreplace(coalesce(FirstName,'')+' '+coalesce(MiddleName,'')+' '+coalesce(LastName,''), ' ', ' ')
What is the point of the replace here? You are replacing all single spaces...
-
RE: How to get full name of the employer by getting rid of null values in between
marc.corbeel (10/14/2016)
here is how I do thisreplace(coalesce(FirstName,'')+' '+coalesce(MiddleName,'')+' '+coalesce(LastName,''), ' ', ' ')
What is the point of the replace here? You are replacing all single spaces with a single...
-
RE: lookup value for each row
marc.corbeel (10/14/2016)
I have a table with currencies, and a table where each day the exchange rates for those currencies are downloaded. I want to write 1 query to generate a... -
RE: Sql Send_Db_mail Vertical Table
You will need to make your rows contain all the data for the row. Something like this in a select statement.
'<tr><tr bgcolor=#E6E6FA><b>Data Nota</b></td>' + CONVERT(VARCHAR(10), N.DATEMI, 120) + '</td></tr>'
-
RE: Sql Send_Db_mail Vertical Table
adrhohmann (10/14/2016)
Ok!Tks again
I really not could do it them I resorted this forum
But.. I will keep trying ;-);-)
Show us some work. So far all you have shown is code you...
-
RE: Sql Send_Db_mail Vertical Table
adrhohmann (10/14/2016)
tks for your replyI'm a little familiar with HTML but not so much.
I get this code from the web and changed to my data. so I got the first...
-
RE: Sql Send_Db_mail Vertical Table
adrhohmann (10/14/2016)
Tks!!I copyed this from the web
You can post a E.G ?
You have an example. Are you familiar with HTML? I get that you copied this from somewhere else but...
Viewing 15 posts - 1,171 through 1,185 (of 15,381 total)