Viewing 15 posts - 391 through 405 (of 1,957 total)
trwillcox (10/14/2014)
Example...
October 14, 2014 at 4:59 pm
patilyatin542 (10/10/2014)
:: Code 128 ::
I have used your code in sql which you described in http://www.sqlservercentral.com/Forums/FindPost1470956.aspx
and returning value of a column like SELECT encoded_for_128 FROM dbo.Code128Barcode('140000009','B') through procedure to...
October 11, 2014 at 5:26 pm
patilyatin542 (10/2/2014)
thanks M.M for reverting back!!!please upload the updated code, you are saying. 🙁
I already changed the code.
October 2, 2014 at 11:05 am
SELECT FORMAT(getdate(),'aSNAP_Da\ta_yyyyMMdd_P-yyyy-MM-dd_hh.mm.ss.dat')
September 29, 2014 at 5:52 pm
patilyatin542 (9/29/2014)
I have used this code as my sql function, and returning barcode value using this function to SSRS.
And in rdlc file I am using Code128 as font; but...
September 29, 2014 at 5:42 pm
The Access Database Engine 2010 Redistributable is not intended:
As...
August 5, 2014 at 6:12 pm
Alternatively, a way that might help if the elements to be inserted can vary by each run - using XML.modify to insert the child elements into the TopLevel document.
Each...
July 29, 2014 at 6:01 pm
It sounds a lot like you really need to have two nested loops,
Loop 1 ) foreach date
.. Loop 2) foreach file matching date
July 29, 2014 at 4:37 pm
This may help kick you along the right path, but if you are dealing with a large dataset this won't be good for performance...
declare @ID int; -- the first order...
July 28, 2014 at 5:21 pm
You will need to add support for SQL2012 by changing line 163 to this:
IF @Version IN (N'9', N'10', N'11')
I would change the final select to this:
...
July 28, 2014 at 5:01 pm
That doesn't look like a running total, merely a grouped sum.
Try this:
SELECT
EmployeeID
, Project
, Sunday
, Monday
,....Saturday
, ProjectHours
, SUM(ProjectHours) OVER(Partition BY FiscalWeek)...
July 27, 2014 at 5:07 pm
Evil Kraig F (7/21/2014)
mister.magoo (7/21/2014)
July 21, 2014 at 6:06 pm
Make sure the format file is encoded as ANSI, not unicode.
You can do this using notepad.exe - just open the file, then go to Save As... and check the Encoding....
July 21, 2014 at 5:56 pm
So is that right? You have a stored procedure that produces XML from data stored in tables and now you want to shred that XML to store the data in...
July 21, 2014 at 5:50 pm
christine.c.ringleb (7/16/2014)
I have the DATEFORMAT set correctly and validated with dbcc useroptions.
I don't have any date fields stored as character strings. All date fields...
July 16, 2014 at 1:19 pm
Viewing 15 posts - 391 through 405 (of 1,957 total)