Viewing 15 posts - 8,161 through 8,175 (of 8,731 total)
Maybe we're thinking a little bit different. Here's the solution I came with and a possible improvement using a temp table. If you're going to filter your information remember to...
April 3, 2013 at 1:26 pm
I'm willing to help you (as a matter of fact, I already have a solution for you). However, I want you to show me what have you done so far....
April 3, 2013 at 12:26 pm
Do you want the query to be online? or the output?
Can you be more explicit? We can't see what you see, we don't know what you have.
April 1, 2013 at 3:04 pm
There's no difference between AFTER and FOR triggers. They're the same thing. (Reference: http://msdn.microsoft.com/en-us/library/ms178134(v=sql.105).aspx)
Why are they treated as a single transaction? I'm not sure how to explain it, it's part...
April 1, 2013 at 2:57 pm
You can use it as a CTE as well, instead of the subquery.
April 1, 2013 at 2:48 pm
I support the idea of using SSIS to have more options. You can start by reading the Stairway to Integration Services[/url].
However, I wonder why would you use a bat file...
April 1, 2013 at 2:33 pm
The trigger is part of the transaction. If the trigger fails, the whole transaction fails.
As simple as that.
April 1, 2013 at 2:27 pm
Your data was going to drive me crazy, until I realized that there was an error on the year for the variables.
This is what I did:
First, I created a "table"...
April 1, 2013 at 2:23 pm
Something like this would work?
(Using the sample data provided before)
SELECT * FROM (
SELECT [Proc], MIN( Seq) Seq, Type AS Task
FROM @temp
GROUP BY [Proc], Type) A
UNION
SELECT [Proc], Seq, Task
FROM @temp
April 1, 2013 at 1:55 pm
Using the new data:
SQL_Enthusiast (1/29/2013)
CLAIM 100 had 2 CHARGE_ITEM_ID records and CLAIM 101 had 2 CHARGE_ITEM_ID records
CLAIM 100 - CHARGE_ITEM_ID 5000 & 50550 have REVENUE_SITE_ID of 1000 and...
January 29, 2013 at 2:13 pm
Could you provide some sample data?
I'm sure you can use my query by tweaking it a little, but we don't have the complete information because now you're mentioning claims.
January 29, 2013 at 1:58 pm
Format the column in Excel before it gets the data.
January 29, 2013 at 1:45 pm
Before copying, format the column as Text.
Alternatively, you can use
SELECT '''' + MemberID AS MemberID FROM Member
to add an apostrophe before the string so Excel will treat it as...
January 29, 2013 at 1:39 pm
Shouldn't this work?
SELECT S.agentNumber,
MAX(S.auditdate) as auditdate,
A.agencyName,
A.state,
A.region,
A.Parent
FROM tblAudit_Auditschedule S
LEFT OUTER JOIN tblAgents A On A.agentNumber = s.agentNumber
LEFT OUTER JOIN tblAgentStates R ON A.agentNumber...
January 29, 2013 at 1:16 pm
Do you get job1 printed twice? or only once?
January 29, 2013 at 11:33 am
Viewing 15 posts - 8,161 through 8,175 (of 8,731 total)