Viewing 15 posts - 3,691 through 3,705 (of 9,722 total)
Sean Lange (3/28/2013)
kk1173 (3/28/2013)
discharged_entered is a date field.Then forget all the convert nonsense. Just compare it to a datetime.
c.discharge_entered_dt >= DATEADD(DAY, -14, getdate())
Sean, This won't necessarily work for him. If...
March 28, 2013 at 12:39 pm
kk1173 (3/28/2013)
Both tables (employer and case1)have the necessary indexes.
Something else to consider.
Are you absolutely 100% positive that the indexes are 1) being used by the query engine and 2) properly...
March 28, 2013 at 12:28 pm
First, try changing the JOIN to a more common version of the JOIN, which may (or may not) help.
SELECT Distinct
c.EMP_ID as ID,
e.name as Display
FROM Case1 c
INNER JOIN Employer e
ON...
March 28, 2013 at 12:23 pm
Most monitoring tools at my workplace is stuff we built ourselves. Part of that is due to budget / corporate approval constraints. Part of that is the need for things...
March 28, 2013 at 12:17 pm
Did you say you ARE or ARE NOT able to open the server in SSMS and import the package that way?
Steps would be: Open SSMS, connect to Integration Services with...
March 28, 2013 at 12:12 pm
Please be more detailed on where the error is coming from and what the error says.
What type of configuration are you trying to create? (XML, Table, etc.) and where...
March 13, 2013 at 8:21 am
AEdel (2/25/2013)
[25-Feb-2013 01:10:17] PHP Warning: odbc_connect(): SQL error: [Microsoft][SQL Native Client]Named Pipes Provider:...
February 26, 2013 at 4:19 am
Abu Dina (2/14/2013)
Maybe this?
SELECT ordertotalFROM #MoneyTest
where ordertotal - round(ordertotal, 2) > 0
Oh. You want me to use the SIMPLE solution. 😀
<headdesk>
Really? I had to make things THAT difficult for myself?
Thanks,...
February 14, 2013 at 9:48 am
Why can't you just change your IF statement?
February 14, 2013 at 9:22 am
Grant Fritchey (2/14/2013)
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
February 14, 2013 at 5:04 am
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
February 14, 2013 at 4:39 am
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.
February 14, 2013 at 4:15 am
Jeff Moden (2/13/2013)
RBarryYoung (2/8/2013)
Ewww, Tom! I hesitate to ask what "squat thrusts" must mean over there. :sick:
BWAAAAAAAAA-HAAAAAAA-HAAAAAAA!!!!! (clutching my sides and just blew a half dozen Cheerios out my...
February 14, 2013 at 4:13 am
I'm going to SQL Saturday in Omaha, NE. But I'm afraid that and the Jax (and probably Orlando) events are the only SQL Server related events I'll be able to...
February 13, 2013 at 8:15 am
Grant Fritchey (2/13/2013)
I think we're back to the Roadhouse rule set here. Be nice.
And always keep a set of spare tires in the trunk.
February 13, 2013 at 4:54 am
Viewing 15 posts - 3,691 through 3,705 (of 9,722 total)