Viewing 15 posts - 31 through 45 (of 2,903 total)
Using SQL2012, you have the TABLEDIFF option. I'd look into that. Each table would need a PK though. You tell it which is the source database/table and the...
October 12, 2016 at 5:16 pm
Lynn Pettis (10/3/2016)
What ever happened to basic problem solving skills?
Basic Problem Solving Skills checklist:
1. post issue on SQL Server Central without examples or all the details
2. if you don't get...
October 3, 2016 at 2:59 pm
While probable not quite accurate...the way to think about is this way...when using a single # think of it as being owned by the schema that made it:
Conn1.temp01
Conn2.temp01
When using a...
September 14, 2016 at 5:53 pm
JALLYKAMOZE (8/30/2016)
I have a problem where i want to get the diffrence in minutes between two times, my datatype is TIME, i have also used the function below
ABS(DATEDIFF (MINUTE,...
August 30, 2016 at 10:53 am
A couple of suggested Error messages:
--If the parameter is NULL return:
Parameter is not supplied. This stored procedure requires one parameter.
--If no data is found return:
Data not found based on supplied...
August 25, 2016 at 4:08 pm
Matt Miller (#4) (8/25/2016)
Eric M Russell (8/25/2016)
Matt Miller (#4) (8/25/2016)
SQLBill (8/25/2016)
Eric M Russell (8/25/2016)
August 25, 2016 at 4:02 pm
Eric M Russell (8/25/2016)
August 25, 2016 at 9:35 am
Manic Star (8/19/2016)
Kaye Cahs (8/19/2016)
Hugo Kornelis (8/19/2016)
Ed Wagner (8/19/2016)
Luis Cazares (8/19/2016)
Ed Wagner (8/19/2016)
ChainsawMassacre
Texas
Dallas
Cowboy
Cheerleader
Debby
August 19, 2016 at 2:33 pm
But isn't your results from two different weeks (week 26 and week 27)? Why would you be combining them into one week? Shouldn't it be the first two...
August 18, 2016 at 1:41 pm
Another option is to create a job. One of the schedule options for jobs is "Start Automatically when SQL Agent starts".
-SQLBill
July 14, 2016 at 2:48 pm
Heck with floppies...my first computer used a cassette tape.
-SQLBill
July 13, 2016 at 4:55 pm
Here's an example of using BCP:
use info
go
declare @sql varchar(2000), @command varchar(2000)
set @sql = '
SELECT ID,Type,Value, GETDATE() FROm info.dbo.temp'
set @command = 'bcp "'+@sql + '" queryout \\servername\drive:\info_temp.data -T -c -b10000'
print @command
--exec...
July 12, 2016 at 9:45 pm
Not that I'm aware of, however, you could add a trigger that would stop them from doing the insert or whatever (INSTEAD OF trigger) and instead of doing the work,...
June 22, 2016 at 3:42 pm
I am experienced tableau developer with SSIS and SQL
Maybe that job title/experience is too narrow and not needed at most companies. One issue I've heard as a problem...
June 16, 2016 at 3:06 pm
Viewing 15 posts - 31 through 45 (of 2,903 total)