Viewing 15 posts - 631 through 645 (of 1,082 total)
Thanks Paul,
Do you have an example of thing that would work on the other servers and not PRODUCTION?
This way I can go to boss and try and explain this to...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 16, 2008 at 5:33 am
Sorry Mark,
I didn't realise it need to greater than 5 as opposed to greater than or equal too :hehe:
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 16, 2008 at 5:31 am
Hi Mark,
You solution seems to be missing some of the results.
Here is a solution that seems to work, but I have a feeling that with a large data set this...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 16, 2008 at 4:20 am
Hi Gila,
I'm South African, but not currently in SA, would I be of any help to your 🙂
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 16, 2008 at 3:50 am
Hi there,
Is the difference between:
01/10/2008 01:00
AND
01/10/2008 01:17
Not also 5mins?
Also check this link out for tips on getting the best out of your posts:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 16, 2008 at 3:43 am
HI there,
Could you please show us what you want your out put to look like?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 16, 2008 at 3:28 am
Grant Fritchey (9/15/2008)
Yeah, open the query plan you posted. It's right there on top, including all the syntax except the query name to create it.
Sorry but I got last by...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 16, 2008 at 2:25 am
HI There,
How Many rows is this gonna be updating?
Also is this table being used alot by other uses? (cause locks)
Last but not least do you have an execution plan...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 15, 2008 at 10:26 am
What do you mean you can't find?
What happens when you set up a connection using the same user as you used in your SSMS connection window, and run "SELECT *...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 15, 2008 at 10:22 am
Can you do a simple select from this table using your c# connection?
Also can you do a simple selecting in SSMS?
thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 15, 2008 at 10:14 am
HI there,
Does you c# connection have permissions to this new table?
Also what is the select statement you wrote ?
thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 15, 2008 at 10:01 am
That looks good.
Prob a good idea to also do some testing with different examples with different times that are greater, less and equal to your getdate value.
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 15, 2008 at 6:56 am
You could also use the DEFAULT reserved word in SQL this will force it to use the default value as well
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 15, 2008 at 6:50 am
HI There,
Could you show us what you have so far.
HINT:
This is going to require a where clause with the GETDATE() function in it
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 15, 2008 at 6:45 am
Thanks for that Brandi,
In BIBS when I run my Package execusion task to run one of my packages it gives this error
[Execute SQL Task] Error: Failed to acquire connection "DestinationConnectionOLEDB"....
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 10, 2008 at 8:26 am
Viewing 15 posts - 631 through 645 (of 1,082 total)