Viewing 15 posts - 2,161 through 2,175 (of 4,820 total)
September 29, 2017 at 11:32 am
September 29, 2017 at 11:18 am
The more I think about this, the more it seems likely that COUNTRY_CD was not meant to be a literal string. I suspect that the query was created without that...
September 29, 2017 at 11:12 am
September 29, 2017 at 11:08 am
If you want a better splitter, then I can't recommend strongly enough that you use Jeff Moden's DelimitedSplit8K, found here:
http://www.sqlservercentral.com/articles/72993/
It performs quite well, and only...
September 29, 2017 at 10:35 am
What kind of SAN fabric sits between the server and the SAN? 1 Gigabit ? 10 Gigabit? You may be I/O bound to some degree. The difference between a local...
September 29, 2017 at 10:22 am
Your picture shows some strange dates for the Check Amount column, and you've provided no description of your data beyond that picture, which because of what I referred to previously,...
September 29, 2017 at 9:03 am
Looking to find record that contain characters berfore and after and ignore the ones in...
September 29, 2017 at 8:45 am
Try this:
declare @Calendar table ([Year] int, [Month] int)
insert into @Calendar values (2017, 1)
insert into @Calendar values (2017, 2)
insert into @Calendar values (2017, 3)
insert into @Calendar...
September 29, 2017 at 8:33 am
September 29, 2017 at 8:25 am
I forgot to mention that varchar for dates are datetime in my production environment.
My database...
September 29, 2017 at 7:03 am
September 29, 2017 at 6:46 am
September 29, 2017 at 6:28 am
LAG function gives us value which was encountered in previous line.
There is no lag...
September 29, 2017 at 6:05 am
Thank you for your reply. Problema. Is that the Soure file is excel, not sql....
September 29, 2017 at 5:58 am
Viewing 15 posts - 2,161 through 2,175 (of 4,820 total)