Viewing 15 posts - 1 through 15 (of 61 total)
The reason for copying data is that the business dictates that the data be capture at a point in time (in this case every quarter for each year). In the...
April 10, 2007 at 10:20 am
Hi Everyone,
Here is the intial output of my issue
Id |
February 14, 2007 at 8:01 am
Hi,
This is what I have so far:
Output:
Dept | ASSold |
February 13, 2007 at 1:44 pm
Actually I haven't built the table structure yet. What I'm trying to figure out right now is the best possible solution to this issue. This is the information I can...
February 12, 2007 at 12:41 pm
Thanks John,
You trigger a thought process on how to handle this issue.
I'm currently in design mode.
I'm leaning on having an admin form and like you said passing the new...
January 19, 2007 at 6:15 am
You're right the true purpose of this is to parse out the data and load the data into two separate fields. This is what I came up with:
@ConcatenateVariable would equal...
December 8, 2006 at 12:18 pm
I had posted this for someone else. I didn't have time to research this, however when I did I found the following: file import/export; choose a folder and presto it...
November 8, 2006 at 1:05 pm
Right,
At the time I posted this I had been going back and forth between SQL Server and a .NET build I was trying to get out to production. I did...
October 23, 2006 at 5:35 pm
Thanks for all the help!
September 20, 2006 at 7:38 am
Thanks Sreejith works like a charm!!
August 31, 2006 at 1:26 pm
Thanks for the input. I just wanted to find the most efficient way of being able to iterate through a record of accounts and ensure that I evaluated all the...
August 9, 2006 at 7:25 am
Hi Again,
I changed the if condition from
IF (SELECT COUNT(gldept)
FROM source_overhead_budgetaccounts_by_dept_budgets
WHERE gldept = @GLDEPT AND budgetaccount = @NextAccount) > 0
to
IF EXISTS(SELECT gldept...
August 8, 2006 at 10:41 am
Now I'm really getting confused (which is not hard to do
Anyway,
Here is my latest iteration:
DECLARE @NextAccount INT
August 8, 2006 at 9:40 am
Hello again,
This is the final T-SQL - everything is working fine now
Thanks for all your help
=============================
DECLARE @NextAccount INT
SET @NextAccount=0
WHILE @NextAccount IS NOT NULL
BEGIN ...
August 8, 2006 at 8:41 am
Viewing 15 posts - 1 through 15 (of 61 total)