WayneS

Forum Replies Created

Viewing 15 posts - 3,406 through 3,420 (of 5,588 total)

RE: Dynamic Columns - Cash Flow problem

Bezan (9/2/2010)
Problems/to do:
- with more periods (>10) there is complete mess .... why?
- another test: periodlength = 30 ... also totally different results... why?
- have to figure out better way...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 2, 2010 at 7:04 am

#1215568
RE: Dynamic Columns - Cash Flow problem

Bezan (9/2/2010)
Problems/to do:
- have to figure out better way of getting numbers 1,2,3,4,... than as it is now from table
- Comumns name like 1-7 8-14 not...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 2, 2010 at 6:54 am

#1215561
RE: did you leave a secure job, what pushed you to move and how did you get on?

Ian Massi (9/2/2010)
Worst case, you practice your interview skills and that's not a bad thing at all.
So true. Interviews is one of those things that I'm always a little bit...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 2, 2010 at 6:39 am

#1215545
RE: Dynamic Columns - Cash Flow problem

irobertson (9/2/2010)
As an aside, I'd definitely be interested in seeing how the performance matches up on the interim disk write against the nested cte approach.
One thing that can be done...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 2, 2010 at 6:15 am

#1215532
RE: Array in SQL server

I would suggest you read this article Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays[/url]
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 2, 2010 at 5:56 am

#1215528
RE: How can I show just the name only once?

simflex-897410 (9/1/2010)
I have a quick question Wayne.
Why didn't I just do that for only name since that's the only one we are interested in displaying first value only while leaving...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 2, 2010 at 5:52 am

#1215526
RE: transferring or replacing data from excel into sql table

Probably the easiest way would be for you to use the import wizard (right-click the database | Tasks | Import data). For the data source, select "Excel Source", and follow...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 9:35 pm

#1215386
RE: Exporting in Excel Sheets and loosing format

Neither SSIS nor the OpenRowset/OpenDatasource functions can do this... they all use the JET database engine, and all they do is manipulate data (insert, update, delete, select).
To do formatting, you...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 9:30 pm

#1215383
RE: Looking for more elegant solution for date identification mechanic

Craig Farrell (9/1/2010)
WayneS (9/1/2010)
No problem.
At least is doesn't "end up tripping on the leap year for multiple year scenarios."
True, but neither does the mm one, just gotta deal with that...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 9:21 pm

#1215380
RE: Use of separating SQL Bianry files and Shared tools othen than C (OS) drive

I guess that would depend on the size of the drives. On the systems that we were getting just a couple of years ago, we were putting the binaries on...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 9:16 pm

#1215378
RE: How can I show just the name only once?

Craig Farrell (9/1/2010)
simflex-897410 (9/1/2010)
Craig,
The data was just dumped from mainframe to a .txt file and I just imported it to sql server db.
Nasty. Alright, quick fix. First, back...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 8:58 pm

#1215374
RE: Looking for more elegant solution for date identification mechanic

Craig Farrell (9/1/2010)
Hm, that tally table looks interesting, and I'll explore it more shortly, I'm not immediately familiar with it. The crossjoin computations seems like it takes a lot...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 8:52 pm

#1215372
RE: Looking for more elegant solution for date identification mechanic

Okay Craig, how's this?
declare @DateToCheckAgainst datetime;
--SET @DateToCheckAgainst = DateAdd(day, DateDiff(day, 0, GetDate()), 0);
SET @DateToCheckAgainst = '20100822';
SELECT repeatID,
BeginDate,
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 8:17 pm

#1215367
RE: Dynamic Columns - Cash Flow problem

Bezan (9/1/2010)
WayneS, Result seems to be OK but there are fixed 5 periods and they have to be dynamic. I should be able to exec this with 3 or 20...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 7:37 pm

#1215365
RE: getutcdate during daylight savings time

Marcia Q (9/1/2010)
And just because I'm paranoid, I have marked on my calendar to double check this on November 7th. 🙂
I would not call this paranoid, but prudent. Always remember:...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

September 1, 2010 at 7:02 pm

#1215361

Viewing 15 posts - 3,406 through 3,420 (of 5,588 total)