Viewing 15 posts - 166 through 180 (of 402 total)
Sounds like you are trying to update a column that has a numeric datatype with text..
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 12, 2012 at 5:26 am
The Master contains all of the SQL system items ect:
http://msdn.microsoft.com/en-us/library/ms187837.aspx
A the term Staging DB is normally applied to Data Warehousing and it is the area where you clean and transform...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 12, 2012 at 5:20 am
Or if you wanted to do it dynamically:
CREATE TABLE #BaseData(ClientNo INT, Code VARCHAR(3))
INSERT INTO #BaseData(ClientNo, Code)
VALUES
(123,'AAL')
,(1234,'AAC')
,(123,'AAC')
,(1234,'QPL')
DECLARE
@sql VARCHAR(MAX)
,@COLUMNS VARCHAR(MAX)
SET @COLUMNS =
STUFF(( SELECT ',' + QUOTENAME(Code) AS [text()] FROM...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 12, 2012 at 4:46 am
This may be of help..
http://www.blackwasp.co.uk/SQLIsLeapYear.aspx
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 11, 2012 at 8:00 am
I dont want to create a table to hold and highlight the leap years, I'm assuming there must be a way to do it without the use of an extra...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 11, 2012 at 7:50 am
Have you considered creating a calendar table and using this to identify the leap years?
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 11, 2012 at 6:46 am
10 pints where consumed in the space of around 3-4 hours
/Tips Hat
Impressive!!
I'd be no good for anything after that!! :sick:
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 10, 2012 at 9:06 am
anthony.green (7/10/2012)
I take it these are the ones you are talking about?http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/
I've used those reports in the past and they really are first rate
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 10, 2012 at 3:52 am
Jared:
Agreed all around. So, when we needed to look up a balance on a current customer we could do that calculation on a small number of records from just that...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 9, 2012 at 3:06 pm
I did once when my Active Directory permissions were changed by accident and this filtered down to my SQL permissions. If you use AD worth looking into..
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 9, 2012 at 12:05 pm
aside from that, one important rule is to never store the calculated/summary balance in the row data or in a static table;
Hi Lowell
I'm interested in your thoughts...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 9, 2012 at 11:58 am
Gosh. I certainly hope that ISN'T true. A non-normailzed database will cause you more grief than you can ever imagine. Rather, you should ensure the database is properly normalized and...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 9, 2012 at 8:43 am
It's a little extra work, but I always try to add a new column 'in the right place' where applicable. I concede that it doesn't actually make any difference from...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 9, 2012 at 7:07 am
If you use the GUI Right Click on the table > Design > Right Click on the area you want to insert > Insert Column
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 9, 2012 at 5:42 am
Hi
have you tried
WHERE
(CompanyID IN (1,2,3) OR CompanyID IS NULL)
AND (AreaID IN (1,2,3) OR AreaID IS NULL)
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 9, 2012 at 5:34 am
Viewing 15 posts - 166 through 180 (of 402 total)