Viewing 8 posts - 106 through 114 (of 114 total)
So, on a given day, the value per item is the weighted average of the purchase prices of all the purchase entries prior minus the weighted average price of all...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
July 29, 2009 at 3:45 pm
If the DLL is .net, you can use .net reflector to grab the source code and recompile it for x64. Be carefull doing this in case the original code...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
July 29, 2009 at 2:17 pm
In VS2005, you can create a new database project, which will allow you to create and debug test scripts. You can step into the sql stored procedure code this...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
January 2, 2009 at 11:38 am
I do not have any problem exporting reports w/ images to excel... Do you have service pack 2 installed? I believe sp2 fixed some issues with the export...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
January 2, 2009 at 11:22 am
two concatenating two nvarchar(max) variables will result in one nvarchar(max) string.
If you use varchar instead of nvarchar, you will get an extra 4000 characters, but the overall issue still remains.
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
January 2, 2009 at 10:09 am
Again, I don't know what requirements led to your decision to use dynamic sql, but a stored procedure will give you much better performance and security even if you have...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 31, 2008 at 1:49 am
I doubt I'm saying anything not contained in that document, but my first impulse is to tell you not to use dynamic sql.
Depending on what you're trying to do this...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 30, 2008 at 2:04 pm
Use modulo.
=23 Mod 3
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 30, 2008 at 1:43 pm
Viewing 8 posts - 106 through 114 (of 114 total)