Viewing 15 posts - 2,551 through 2,565 (of 7,191 total)
No, SQL Server Browser is just to resolve instance name to port name on the local computer.
John
June 9, 2016 at 1:59 am
Welsh Corgi (6/8/2016)
I am getting a Primary Key Violation when Loading a Table.I queried the source table and there is only one record with value of the primary key.
In that...
June 8, 2016 at 9:55 am
Brilliant! I knew there'd be a better way of doing it. You're returning that final separator, but that can be either ignored or easily got rid of.
John
June 8, 2016 at 9:36 am
Yes, with queries, part of the execution time is transmitting and displaying the result set. With maintenance activities, that's a very much small proportion of the work that's done.
John
June 8, 2016 at 5:45 am
Specify an alias for Table1 in your FROM clause and use that in your SELECT list.
John
June 8, 2016 at 5:05 am
Yes, but it's certainly not pretty and probably not efficient on large data sets.
WITH Numbered AS (
SELECT
CAST(id AS char(2)) + ' ' + name AS Concatenated
,Dept
,ROW_NUMBER() OVER (PARTITION BY Dept...
June 8, 2016 at 4:32 am
Abhas
That's a task usually best done in the presentation layer. Reporting Services would be good for something like that. If you must do it in T-SQL, please will...
June 8, 2016 at 2:58 am
Does your package involve a SQL Server, and if so, can you send messages from that server with sp_send_dbmail? I always find that easier than using the Send Mail...
June 7, 2016 at 9:27 am
To know what the previous row is, you need a column (or combination of columns) by which to sort. A table has no inherent order, so which column(s) will...
June 7, 2016 at 9:25 am
OK, we're getting somewhere. Not quite all bold yet, though.
Please post the exact error message. Is the Execute SQL task the only task in your ForEach Loop container? Is...
June 7, 2016 at 9:01 am
I'm out of my depth now, I'm afraid. I have the immense good fortune very rarely to have worked with Access.
John
June 7, 2016 at 8:50 am
You can use sp_send_dbmail to send the results of a query by e-mail.
John
June 7, 2016 at 8:22 am
I don't think that's to do with the network. The MSOLAP provider is for Analysis Services, not Access.
John
June 7, 2016 at 7:48 am
Does your remote SQL Server capture failed logins in its errorlog? If so, do you see anything in there after you attempt to connect? Can you connect to...
June 7, 2016 at 7:27 am
A different interpretation of the requirement:
SELECT
Deptno
,locationid
,pid
,sid
,LAST_VALUE(value) OVER (PARTITION BY locationid, pid, sid ORDER BY Empid RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) * 1.0
/ FIRST_VALUE(value) OVER (PARTITION BY locationid, pid,...
June 7, 2016 at 5:15 am
Viewing 15 posts - 2,551 through 2,565 (of 7,191 total)