Viewing 15 posts - 19,366 through 19,380 (of 59,072 total)
Luis Cazares (10/19/2015)
Unless I'm missing something, here's my suggestion.
--Dynamic Pivot
DECLARE @sql NVARCHAR(MAX);
/*
STUFF is used...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2015 at 7:11 pm
Meatloaf (10/23/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2015 at 6:16 pm
I'll never understand why anyone considers dynamic SQL to not be an elegant solution when it's so bloody effective (and safe) when done correctly.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2015 at 6:09 pm
I use the "IsActive" type of thing because 1 is usually considered to be TRUE. I've seen people use negative logic and names before and it's nothing but trouble...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2015 at 6:00 pm
rajbetl11 (10/23/2015)
I have tried with below code in "Execute SQL Task"
Declare @FileDate datetime
declare @filename varchar
-- filename = test_source_file_20150920
Set @FileDate = substring(@filename,11,8)
select @FileDate
but it's giving default value not from...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2015 at 4:13 pm
asafswis2 (10/23/2015)
i add the filei need help to build sql query as show in file
tnx all
Links to speadsheets just aren't going to cut it for readily consumable...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2015 at 3:50 pm
robert.sterbal 56890 (10/23/2015)
On a related note:What is the ISO standard for midnight?
2015-03-04 23:59
2015-03-0? 00:00
2015-03-05 00:01
Does ? = 4 or 5
To the best of my knowledge, I know of no temporal...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2015 at 3:36 pm
Tamrak (10/23/2015)
I did not use the tally. But decide to use...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2015 at 2:10 pm
marc.corbeel (10/23/2015)
Does this means that Sunday 3 January 2016 is also week 53 in US standards?
No. It means that it's week 53 according to ISO standards.
The US is a...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2015 at 2:17 pm
marc.corbeel (10/23/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2015 at 9:16 am
Beugen (10/23/2015)
Thanks for this simple and effective code.
Is there a similar easy way to get the year of that week we are looking for? Or the "ISO-year"?
Lets say I put...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2015 at 9:14 am
robert.sterbal 56890 (10/23/2015)
I like the way your formula skips the leap year problem.I still remember when the church moved the calendar by a couple of weeks - https://en.wikipedia.org/wiki/Gregorian_calendar
That would be...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2015 at 8:50 am
Jayanth_Kurup (10/23/2015)
Jeff Moden (10/23/2015)
Jayanth_Kurup (10/23/2015)
Here is a screen shot with clustered index on the monolithic table on REF_AGE column as requested. Notice that it took 17 sec ,...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2015 at 8:38 am
Took a quick peek at the code you posted.
EXEC sys.sp_db_vardecimal_storage_format N'partitioned', N'ON'
I could be misreading something but you do know that VarDecimal has been deprecated, yes?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2015 at 8:34 am
michal.lisinski (10/23/2015)
Invoice 1
Invoice header
Item lines
Subtotal netto
Subtotal by VAT
Total
Footer
...
Invoice n
Invoice header
Item lines
Subtotal...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2015 at 8:28 am
Viewing 15 posts - 19,366 through 19,380 (of 59,072 total)