Viewing 15 posts - 5,041 through 5,055 (of 8,731 total)
CELKO (4/8/2015)
I have a column which needs to be 9 digits long. The first four digits are independent from the other digits. The following digits need to be 5 and...
April 8, 2015 at 12:26 pm
Alan, I believe that you missed the important part of the sample data. 😀
-- sample data
DECLARE @yourtable TABLE (Clt char(5), Part char(5), Date_a datetime, Val_b decimal(8,2), percent_b varchar(6));
-- only did...
April 8, 2015 at 10:49 am
I think that I found the problem. Is easy to notice it if you format your strings.
I'm tempted to post the corrected code but I'd love to have the opportunity...
April 8, 2015 at 10:13 am
I wouldn't say that it's completely right, but it's a nice try.
- The main problem (IMO) is the DVD table. It isn't normalized. I suggest you to create a...
April 7, 2015 at 5:51 pm
Alan.B (4/7/2015)
Brandie Tarvin (4/3/2015)
Koen Verbeeck (4/3/2015)
SqlSanctum (4/3/2015)
April 7, 2015 at 3:53 pm
Just adding a solution that goes a little bit further than Don's.
WITH
E(n) AS(
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) E(n) --10 rows
),
E2(n) AS(
SELECT...
April 7, 2015 at 3:32 pm
The "DDL" is not good as we can't use it.
Some questions:
Why are you concatenating values instead of parametrizing your queries?
Are you aware of SQL injection?
Why are you using RBAR in...
April 7, 2015 at 2:47 pm
Alan.B (4/7/2015)
pietlinden (4/7/2015)
Found an article at SQLAuthority that covers your options:Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function[/url]
This is 2008 forum 😉
That's why it simulates LEAD...
April 7, 2015 at 2:25 pm
It's easy to test this formula, but that's just the tip of the iceberg on this process. 🙂
April 7, 2015 at 1:28 pm
Maybe changing the splitter function with the DelimitedSplit8K which is available in here:
http://www.sqlservercentral.com/articles/Tally+Table/72993/
I'll also go with the recommendation of using RECOMPILE or using dynamic sql as this seems like a...
April 7, 2015 at 12:18 pm
If there are less than 5 digits, it means that there are bigger problems than a formula.
However, I'll stay with the original because I was trying to improve the process...
April 7, 2015 at 9:52 am
Thank you both for your solutions.
April 7, 2015 at 8:46 am
Using DB_NAME() is an easy option.
SELECT DBname= DB_NAME()
April 6, 2015 at 2:57 pm
This might surprise you, but Holidaydate column is now part of the pivot columns.
SELECT DutyRosterPeriodID,
StartDate,
EndDate,
pvt.HolidayDate,...
April 6, 2015 at 12:19 pm
Eirikur Eiriksson (4/6/2015)
Luis Cazares (4/6/2015)
SELECT
TB.DiaryID
,TA.MedicalCodeID
FROM dbo.TableA TA
JOIN dbo.TableB TB ON TB.EmisCode LIKE...
April 6, 2015 at 12:03 pm
Viewing 15 posts - 5,041 through 5,055 (of 8,731 total)