taking that one step further, since you can directly query...

does your dataset have an ORDER BY?

remember, there is no "default" sorting.

if you do not explicitly order your results, there's no guarantee they will be in any given order.

SQL would...

when i said parameters, i mean on the report side, sorry for the confusion.

if you are building a string and executing it from your report, without parameters, you need to...

Oracle_91 (1/10/2012)

---

Hi Lowell,

This is working perfectly. I am using sql 2005 and sql 2008. However i have few questions.

1. How to unmark the stored procedure as system proc if i...

you parameters are datetime in the report, right, so they will convert cleanly to the DATE datatype for oracle?

It sounds like you are using varchars instead...

if your parameters are datetime,...

excellent, thanks Paul!

added to my toolbox.

without using dynamic SQL, you need to rename it to be sp_* and simply want to mark the procedure as a "system" procedure.

use master

go

--any proc starting with sp_ is...

what app did you use to make the "tearing" with the drop shadow? ...

yep you are missing the #1 fix to SQL injection: using parameters instead.

generally, you never want to change users data. using it for comparisons, maybe...but even then, you want to...

this was interesting...

not sure if you want to get the data as rows or columns, you might need to pivot this data if you need it as columns, see what...

ugg; except for building a presentation string for binary,

i always leave my values as integers for data manipulation...very easy to test each column for whatever it represents them.

any chance...

does a SKU have a standard length, like 6 characters?

do you have a lookup table of all skus so you could look up whether it is valid before or after...

well, first, a .cmd file is just the renamed verison of a .bat file...something you might typically call via command line / xp_CmdShell (if that is even enabled)

that .cmd...

there's another function for the UTC date you cvan use: GETUTCDATE()

select (UTCOccurrenceDateTime >= DATEADD(day, DATEDIFF(day, 0, GETUTCDATE()), 0))

i'm guessing someone may have installed the full version of Visual Studio, which would supercede the BIDS version...could that be true?

in that case, there's nothing to do...just open visual studio...