WayneS

Forum Replies Created

Viewing 15 posts - 5,536 through 5,550 (of 5,588 total)

RE: performance difference between Query and View.

A view would be pre-compiled; therefore it could potentially be faster than a query which would need to be compiled. In practice, you may not be able to perceive a...
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

July 10, 2008 at 6:37 am

#840758
RE: SQL Server XML

Good question!
But, even better, GREAT explanation of all of the answers. I wish that all of the QODs did the answers this 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

July 10, 2008 at 6:31 am

#840755
RE: Can't use 'Group By'

Or is there a better way to do this?
2 agents in one row is not normalized data. Split the agents out into a separate table, and you'll find that your...
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

July 3, 2008 at 7:09 am

#837812
RE: Having problem resending parameter to report

Resolution:
when setting the parameter specifically to null, do it as:
Param[0] = new ReportParameter("Section", new string[] {null});
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

June 24, 2008 at 7:02 am

#833285
RE: How to return large multi-value list to sql sp?

I found the problem... it wasn't that it was too large of a "dataset" for sql to handle as XML.
In this report, we are literally building an XML string of...
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

June 18, 2008 at 9:54 am

#830595
RE: Print an empty row in SSRS

Add an extra row (detail or group as appropriate). Just don't put any fields in it. Watch out for the data wrapping across pages.
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

June 17, 2008 at 8:12 am

#829800
RE: Please can anyone tell me how to use Bucket Concept in SSRS

I like this. But if I'm reading this right, the logic is reversed.
Shouldn't it be:
Fields!Age.Value >= CInt(Parameter!AgeRange.Value / 1000) and Fields!Age.Value <= Parameters!AgeRange.Value Mod 1000?
the CInt(AgeRange/1000) returns 18; the...
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

June 13, 2008 at 7:52 am

#828500
RE: How to return large multi-value list to sql sp?

Do you happen to have an example of doing this from a report?
Michael Earl (6/12/2008)
That is one way. I remember seeing an article on this subject recently, but I...
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

June 12, 2008 at 7:27 am

#827834
RE: Drill down display issue

Okay, I found it.
On the item that toggles the visibility, on IT'S visibility tab you can set it's initial appearance of the toggle icon to [+], [-], or use an...
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

June 5, 2008 at 1:29 pm

#825068
RE: **Help Needed ** SUMMING HH:MM:SS Issues in SQL Reporting

If you want people to help you with this, I suggest you read:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Your post as is has way too many questions about the data structure to be able to answer...
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

May 29, 2008 at 5:30 pm

#822046
RE: Inserting Comma Seperated Values in Sql Server 2005

Aswanth (5/29/2008)
I'm Using Asp.Net with C#..
i'm having One ListBox control in which I'm getting Data Dynamically.. I want to Insert the Selected data (or ALL DATA) from ListBox Control into...
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

May 29, 2008 at 7:08 am

#821728
RE: Excel Source

prasukj (5/29/2008)
hi
i am Prasanna
I have a excel source (only one excel , having many sheets )
,, in that source we find many sheet, each sheet is having data
so i...
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

May 29, 2008 at 6:49 am

#821721
RE: Telecommuting – Thinking Outside the Cube

Great article.
One of the things I've always said is that we are already working remotely on the databases... the database doesn't know if the user is in their office,...
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

May 29, 2008 at 6:20 am

#821711
RE: Having trouble printing barcodes in a report

Well, it's now working. Didn't change a thing. Took a break, and when I came back to this, it's working.
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

May 28, 2008 at 1:41 pm

#821426
RE: SSRS Adding multiple yearly values into 1 table

Gekko (5/28/2008)
Not sure of a solution for this. I will try explaining what I need to do, and hopefully it makes sense. I need to make a report to track...
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

May 28, 2008 at 10:07 am

#821288

Viewing 15 posts - 5,536 through 5,550 (of 5,588 total)