Viewing 15 posts - 1,081 through 1,095 (of 7,191 total)
I think I would have separate stored procedures - one to insert into the monthly table and one to insert into the weekly.
John
November 20, 2017 at 2:19 am
Have you established which database's log file is growing? Has anything changed in the last two days? Maybe you've imported (or deleted or updated) a lot of data in one...
November 17, 2017 at 1:14 am
,
November 16, 2017 at 9:56 am
Good job with the table DDL and sample data. You didn't show us your query that didn't work, though. I suspect that what you need to do is number the...
November 15, 2017 at 9:06 am
November 15, 2017 at 8:27 am
November 15, 2017 at 4:33 am
Then you'll need to do a bit of investigation. Run xp_logininfo 'DomainName\GroupName', 'members' for each to group to find out which group(s) the user is a member of. ...
November 15, 2017 at 4:11 am
Check the properties of the login. What is its default database. Now, does the login have access to that database?
John
November 15, 2017 at 3:20 am
You can use the same disks. If the databases are heavily used or performance is crucial, you might want to keep them separate, though.
John
November 14, 2017 at 5:50 am
Post the code, please.
I imagine it's going wrong because you have DECLARE statements in your query text. You should only include the actual query.
John
November 14, 2017 at 3:58 am
Thom A - Tuesday, November 14, 2017 3:19 AMAhh, good point. Perhaps:
SUM(t1.credit) - SUM(t1.debit)
Yes, that should work.
John
November 14, 2017 at 3:27 am
November 14, 2017 at 3:00 am
I just typed "running balance query" into my favourite search engine - it's amazing what you can find with a bit of research.
Now, are you really on SQL...
November 14, 2017 at 2:31 am
Viewing 15 posts - 1,081 through 1,095 (of 7,191 total)