jellybean (10/8/2015)

---

Hi,

Can you help me please? I'm using the SQL indicated below:

SELECT

DISTINCT C.Field1 As 'Group',

A.Field2 As 'Security Object'

E.Field3 As 'User'

FROM TableA AS A

JOIN TableB AS B...

If you could post an example in consumable format, which others can run, it would be even better.

Jason Selburg (10/7/2015)

---

SELECT col1, col2, col3, CAST(NULL as BIT) as newCol4, CAST(NULL as VARCHAR(6)) as newCol5 FROM yourTable

in this example, newCol4 and newCol5 are your non-existent columns. Using the CAST,...

orenk (10/7/2015)

---

Hello,

who can I use a variable like the followig

set @MAG3 = '<> 0'

or

set @MAG3 = '= 0'

for the following where condition

where patindex('%;' + Mitarbeiter + ';%' , @MAG2)...

Deploy your SSIS project to SSISDB on your SQL Server instance. Here[/url] is a link that illustrates that process.

Now you are in a position to create a scheduled SQL Agent...

You just responded to a post which is six years old. I reckon all these 'bros' got...

helal.mobasher 13209 (10/7/2015)

---

I am using the following select statement to get the row count from SQL linked server table.

SELECT Count(*) FROM OPENQUERY (CMSPROD, 'Select * From MHDLIB.MHSERV0P')

MHDLIB is the library...

Clearly not using SQL Agent!

You'll need to use some other task scheduler. Or tell us why SQL Agent needs to be stopped while running these commands – there may be...

rajarajansudar (10/6/2015)

---

Guys i am building the custom logging framework in that i want get the task name ( Eg: get the data from source) which is currently executing ,...

OK. I don't fully understand what your data looks like.

Please provide the following:

1) The results of running

select MemberNumber, EndDate, UpdateDate

from dbo.DimMember

where MemberNumber = 1041

before any update and then

2) Please show...

sqlmaverick (10/5/2015)

---

Actually , for historical record I have to update End date as Updated Date where end date is Default date '2099-12-31'and for new record with same id ,...

Eric M Russell (10/5/2015)

---

Perhaps we could have a spam reporting policy that works something like this:

If a trusted user (meaning perhaps a user with a certain level of points...

Lowell (10/5/2015)

---

agreed. they added code that insta-deletes anything Celko posts(thank you for that!), so they can reuse that same code, and just add something that detects the new user spamming...

There are other potential benefits. Here are some that spring to mind:

1) Having a local copy of all database files means that you can search your database without hitting the...

erb2000 (10/4/2015)

---

Our application has serious problems after upgrading to Sql Server 2014. We tracked it down to the huge IN clauses running very slowly. It's not easy to...