Viewing 15 posts - 1,666 through 1,680 (of 4,272 total)
Actually getting it into the database isn't all that difficult and the scenario you paint is a good one for storing the data in database.. I would recommend two...
January 26, 2011 at 10:32 am
John Hoare-150006 (1/26/2011)
January 26, 2011 at 9:53 am
Are there any triggers on the table? Check contraints? Foreign Keys? All of these can have an effect. But my first thought was triggers.
CEWII
January 26, 2011 at 9:43 am
Gianluca Sartori (1/26/2011)
Elliott Whitlow (1/26/2011)
Gianluca Sartori (1/26/2011)
Funny. I always thought that Hubbard had written Scientology related books. Looks like this one is focused on other topics.
I read that as: he...
January 26, 2011 at 9:40 am
Provided the password is correct.. Does the login SQL is using to exec the package have access to the location of the package? Is it on a local...
January 26, 2011 at 9:38 am
Gianluca Sartori (1/26/2011)
Funny. I always thought that Hubbard had written Scientology related books. Looks like this one is focused on other topics.
I read that as: he wasn't always a nut..
January 26, 2011 at 9:33 am
Sometimes I just have to ask.. Really?
http://www.sqlservercentral.com/Forums/Topic1053904-338-1.aspx
January 26, 2011 at 9:10 am
No, that wouldn't help, keep in mind that the individual user stats are dropped at the end of a session. A session could last for 1 query or all...
January 26, 2011 at 9:05 am
Jpotucek (1/26/2011)
select * FROM forms_holderWHERE rec_date <= DateAdd("d",-365,Date())
the error I get is 'Date' is not a recognized built-in function name.
2 things.. the d shouldn't need the double quotes and...
January 26, 2011 at 8:56 am
What you tried at first glance would seem inventive and probably work, not sure what the issue is.. It is also a method I hadn't thought of..
What I had...
January 26, 2011 at 8:51 am
Not without continual logging. Also, what would you use this for?
CEWII
January 26, 2011 at 8:47 am
Not trying to be snarky, but what have you tried? What do you think the query should look like? I ask because this is a fairly basic type...
January 26, 2011 at 8:34 am
homebrew01 (1/26/2011)
January 26, 2011 at 8:28 am
The datatype is varbinary(max), it will store any binary format, which is all that an MP3 or any such thing is.
Now, with that out of the way.. I always...
January 26, 2011 at 8:15 am
Well in most ways I don't do anything special for SSRS. I try to make the queries as fast as possible, I usually use sprocs to hide the logic...
January 25, 2011 at 3:41 pm
Viewing 15 posts - 1,666 through 1,680 (of 4,272 total)