Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9343,9353,9363,9373,938»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 2:24 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 17,977, Visits: 15,981
WayneS (4/10/2013)
Anyone have experience with Dynamics AX 2009 and using stored procedures with it instead of the cursor-ridden DAX "language"?


I DO. I DO




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1441024
Posted Thursday, April 11, 2013 9:21 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 12:17 PM
Points: 737, Visits: 5,460
I hate Reporting Services in a locked down network...

That is all.
Post #1441325
Posted Thursday, April 11, 2013 10:38 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:00 AM
Points: 20,808, Visits: 32,747
This really makes one want to help, doesn't it.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1441376
Posted Thursday, April 11, 2013 11:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, November 6, 2014 5:01 AM
Points: 2,116, Visits: 6,441
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.


Dunno, but it really looks like he was dumped into getting this job done.


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1441388
Posted Thursday, April 11, 2013 11:13 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:00 AM
Points: 20,808, Visits: 32,747
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.


Dunno, but it really looks like he was dumped into getting this job done.


Yes, but what happens when it breaks or needs to be modified? Right back here expecting us to fix it. Least he is honest about not being strong on the coding side, but I just can't get motivated to help when he wants the code. I mean really, what good are ideas if you can't translate them into code.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1441389
Posted Thursday, April 11, 2013 12:29 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:45 AM
Points: 7,871, Visits: 9,610
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.


Dunno, but it really looks like he was dumped into getting this job done.


Well, I've stepped in and told him he can't use EVENTDATA() in a DML trigger. I don't know why no-one else told hime that before.


Tom
Post #1441425
Posted Thursday, April 11, 2013 12:48 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:05 PM
Points: 31,284, Visits: 15,750
L' Eomot Inversé (4/11/2013)
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.


Dunno, but it really looks like he was dumped into getting this job done.


Well, I've stepped in and told him he can't use EVENTDATA() in a DML trigger. I don't know why no-one else told hime that before.


Drive by answer. In a hurry I confused DML with DDL.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1441435
Posted Thursday, April 11, 2013 12:50 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:05 PM
Points: 31,284, Visits: 15,750
Lynn Pettis (4/11/2013)
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.


Dunno, but it really looks like he was dumped into getting this job done.


Yes, but what happens when it breaks or needs to be modified? Right back here expecting us to fix it. Least he is honest about not being strong on the coding side, but I just can't get motivated to help when he wants the code. I mean really, what good are ideas if you can't translate them into code.


Then this is a place you ignore the post, move on.

I think this is the type of person I want to help learn things. I don't want to give them every answer, but help them investigate a bit.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1441438
Posted Thursday, April 11, 2013 12:51 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:45 AM
Points: 7,871, Visits: 9,610
Lynn Pettis (4/11/2013)
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.


Dunno, but it really looks like he was dumped into getting this job done.


Yes, but what happens when it breaks or needs to be modified? Right back here expecting us to fix it. Least he is honest about not being strong on the coding side, but I just can't get motivated to help when he wants the code. I mean really, what good are ideas if you can't translate them into code.

I think it a pity that no-one mentioned his fundamental mistake. I wouldn't write the code for him, but I don't see any good reason not to tell why the approach he has taken stands no chance at all of working. Nor for not telling him what the appropriate functions to use for his purpose in a DML trigger are.


Tom
Post #1441441
Posted Thursday, April 11, 2013 12:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:10 AM
Points: 13,230, Visits: 12,709
Lynn Pettis (4/11/2013)
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.


Dunno, but it really looks like he was dumped into getting this job done.


Yes, but what happens when it breaks or needs to be modified? Right back here expecting us to fix it. Least he is honest about not being strong on the coding side, but I just can't get motivated to help when he wants the code. I mean really, what good are ideas if you can't translate them into code.


Didn't even cross my mind. I knew the value had to be NULL I just didn't think about WHY it was NULL.

--EDIT--

Got bitten by the quote bug, but you still get the idea.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1441442
« Prev Topic | Next Topic »

Add to briefcase «««3,9343,9353,9363,9373,938»»»

Permissions Expand / Collapse