mw_sql_developer

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 637 total)

RE: [SQL SERVER AGENT] related query

Thom A - Monday, June 26, 2017 9:39 AM
Something like:
SELECT *
FROM dbo.sysjobsteps sjs
WHERE sjs.subsystem = 'SSIS'
AND sjs.command LIKE '/ISSERVER...

June 26, 2017 at 9:54 am

#1948181
RE: [SQL SERVER AGENT] related query

Jacob Wilkins - Monday, June 26, 2017 9:23 AM
I don't have access to an appropriate server to test, but msdb.dbo.sysjobsteps should have a...

June 26, 2017 at 9:30 am

#1948177
RE: SSRS Question - How to break the parameters with multiple values to a dataset or #table

mw112009 - Friday, June 16, 2017 11:34 AM
Sorry
I answered my own question here ..... Found the following code in a website. Does the...

June 16, 2017 at 11:35 am

#1947142
RE: SSRS Question - using VS2012 - How can we make the column headers to freeze ( like Excel )

mw112009 - Wednesday, June 14, 2017 6:57 AM
I tired the usual ways but did not work out well.

OK I found how...

June 14, 2017 at 8:23 am

#1946777
RE: SSRS Question - using VS2012 - How can we make the column headers to freeze ( like Excel )

Step1 - Right Click Table, go to Tablix properties
Step2- ( below )

Step3 - You need to open the advance mode ( as shown below ), Highlight...

June 14, 2017 at 8:20 am

#1946773
RE: SQL QUESTION but SSIS related - How do we get a list of parameters used by each DTSX file ?

BTW-Thanks, that query worked fine.
Since you are an expert on this stuff, let me ask you another question. I see these 2 dtsx files. I see them in...

June 7, 2017 at 3:03 pm

#1945908
RE: SQL QUESTION but SSIS related - How do we get a list of parameters used by each DTSX file ?

bmg002 - Wednesday, June 7, 2017 2:04 PM
I believe what you are looking for is the view catalog.object_parameters.
But that will give you the...

June 7, 2017 at 2:51 pm

#1945907
RE: SQL Question with SELECT STATEMENT

Sue_H - Friday, June 2, 2017 11:40 AM
There are a few different ways. Here is one:
SELECT DISTINCT Name ,
STUFF((...

June 2, 2017 at 1:42 pm

#1945203
RE: SSIS Question - Syntax question - Help me with building the expression

bmg002 - Wednesday, May 31, 2017 11:16 AM
Heh. Glad you figured it out.
Was your solution similar (or identical) to mine?
Identical

May 31, 2017 at 11:23 am

#1944783
RE: SSIS Question - Syntax question - Help me with building the expression

bmg002 - Tuesday, May 30, 2017 4:01 PM
First, posting the screenshot is nice, but posting that text is also helpful. For others who...

May 31, 2017 at 11:09 am

#1944779
RE: Help needed with configuring sp_rename ( Works well but how do we include the schema name )

Lowell - Tuesday, May 9, 2017 11:03 AM
you are probably looking to move an object to the other schema. THERE ALTER SCHEMA command...

May 9, 2017 at 11:27 am

#1941862
RE: Help needed with configuring sp_rename ( Works well but how do we include the schema name )

Chris Harshman - Tuesday, May 9, 2017 10:10 AM
you can specify the schema name of the original object in the @objname parameter, you...

May 9, 2017 at 10:48 am

#1941853
RE: Help needed with configuring sp_rename ( Works well but how do we include the schema name )

Chris Harshman - Tuesday, May 9, 2017 9:59 AM
sp_rename only renames the object itself, you can't change the schema it is in, so...

May 9, 2017 at 10:05 am

#1941842
RE: SQL help - help me write the SQL stmt

Jason A. Long - Monday, May 1, 2017 5:14 PM
Give this a try...

WITH
    cte_AddRN AS (
        SELECT
            t.admdt,
            t.dischdt,
            t.ID,
            RN = ROW_NUMBER() OVER (PARTITION BY...

May 2, 2017 at 11:18 am

#1940743
RE: SSRS Report Schedule - getting info from the DB - What do these numbers mean ? -

mw112009 - Friday, April 21, 2017 12:55 PM
See picture below you can clearly see there are more than 5 subscriptions
These were...

April 21, 2017 at 12:58 pm

#1939378

Viewing 15 posts - 136 through 150 (of 637 total)