Viewing 15 posts - 2,521 through 2,535 (of 4,820 total)
Try this, which uses a CTE-based calendar table:
WITH E1 AS (
SELECT 1 AS N UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1...
June 21, 2017 at 5:55 am
I'm going to presume that's a SQL Server 2016 database, but as I don't actually have a 2016 instance I can play with, I still have no means of easily...
June 21, 2017 at 5:42 am
If I understand FILESTREAM correctly, that's where you have a physical file on a disk somewhere that's accessible to the server's service account. If you restored this database, and the...
June 20, 2017 at 10:42 am
Joe Torre - Tuesday, June 20, 2017 9:37 AMYou can use WinRar
No, actually, I can't. That requires installation of a...
June 20, 2017 at 10:09 am
ALTER FUNCTION [dbo].[LastBuyer]
(@SC1 varchar(30))
RETURNS VARCHAR(3)
AS
BEGIN
DECLARE @LB VARCHAR(3)
SELECT...
June 20, 2017 at 10:02 am
June 20, 2017 at 9:54 am
It would be more helpful if you could capture a screen shot of it...
June 20, 2017 at 9:47 am
Nice to see you solving a problem on your own. You should also take a closer look at a highly performant string splitting function that Jeff Moden wrote back in...
June 20, 2017 at 9:26 am
June 20, 2017 at 8:08 am
You'll need SSIS to handle that kind of file format. Your format file is from SQL 2008, so I have to ask, given that you are posting in the SQL...
June 20, 2017 at 8:05 am
June 20, 2017 at 7:30 am
June 20, 2017 at 6:51 am
Unfortunately, just having the results of the query doesn't really tell us where the problem is. Your query looks only at data for 2017 based on your WHERE clause, but...
June 19, 2017 at 2:03 pm
I'm guessing you never got an answer because designing an SSRS report to be dependent on execution order of data sources is a particularly bad idea, because it suggests that...
June 19, 2017 at 10:27 am
June 19, 2017 at 9:09 am
Viewing 15 posts - 2,521 through 2,535 (of 4,820 total)