drop table if exists sql-server 2008/2005

drop table if exists sql-server 2008/2005
 
In this sample I am dropping a temp table #temp4 :-
 
IF OBJECT_ID('tempdb..#temp4', 'U') IS NOT NULL
DROP TABLE #temp4

SQL-Server PIVOT/Transpose with dynamic column, convert row into column

If you have data like following and want to transpose row into column using sql-server 2008 PIVOT,

focomp	FOBUFMED1QT	FOBUFMED2QT
310	2	4
520	5	3
520	5	8
850	3	6
310	3	4
310	3	8
580	3	6

 

 

Transpose means you want Data like following in multiple column sum :

Like following:-

310	520	580	850
8	10	3	3
16	11	6	6

 

In this example my table name is BOFASY

Use following sql query to achive this:-

 

DECLARE @listCol VARCHAR(2000)

DECLARE @query VARCHAR(4000)

DECLARE @query1 VARCHAR(4000)

DECLARE @query2 VARCHAR(4000)

 

SELECT  @listCol = STUFF(( SELECT DISTINCT

                                '],[' + ltrim(focomp)

                        FROM    BOFASY

                        ORDER BY '],[' + ltrim(focomp)

                        FOR XML PATH('')

                                    ), 1, 2, '') + ']'

SET @query =

'SELECT * FROM

      (SELECT  focomp,cast(FOBUFMED1QT as int) FOBUFMED1QT FROM BOFASY) src

PIVOT (SUM(FOBUFMED1QT) FOR focomp

IN ('+@listCol+')) AS pvt'

 

SET @query1 =

'SELECT * FROM

      (SELECT  focomp,cast(FOBUFMED2QT as int) FOBUFMED2QT FROM BOFASY) src

PIVOT (SUM(FOBUFMED2QT) FOR focomp

IN ('+@listCol+')) AS pvt'

set @query2=@query +' union '+ @query1

 

EXECUTE (@query2)

 

Sql-server 2008/2005 Pivot Multiple Column Sum

Not a brilliant way but this is a way...
 
drop table temp5
SELECT 'media1' Type1,
[310],
[520-530],
[850] into temp5
FROM ( SELECT [focomp],
cast(FOBUFMED1QT as int) FOBUFMED1QT
FROM BOFASY
) p PIVOT
( SUM(FOBUFMED1QT)
FOR [focomp] IN ([310], [520-530],[850] )
) AS pvt
 
 

insert into temp5
SELECT 'media2' Type1,
[310],
[520-530],
[850]
FROM ( SELECT [focomp],
cast(FOBUFMED2QT as int) FOBUFMED2QT
FROM BOFASY
) p PIVOT
( SUM(FOBUFMED2QT)
FOR [focomp] IN ([310], [520-530],[850] )
) AS pvt



select * from temp5

PIVOT CAST / sum varchar is not working Sql-server

PIVOT CAST / sum varchar is not working Sql-server  2008/2005 , you have to change in select from table like following:-

 

SELECT

[310],

[520-530]

,

[850]

FROM

( SELECT [focomp],

cast(FOBUFMED1QT as int) FOBUFMED1QT

FROM BOFASY

) p PIVOT ( SUM(FOBUFMED1QT)

FOR [focomp] IN ([310], [520-530],[850] )

) AS pvt

Saving changes is not permitted Error in SQL Server 2008 Express

If you are getting this error-
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.
 
Tools -> Options -> Designers->Table and Database Designers-> and uncheck the option "Prevent saving changes that require table re-creation.

Add member failed for DatabaseRole 'db_securityadmin' sql-server 2008

TITLE: Microsoft SQL Server Management Studio
------------------------------
Add member failed for DatabaseRole 'db_securityadmin'.  (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+member+DatabaseRole&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot use the special principal 'dbo'. (Microsoft SQL Server, Error: 15405)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=15405&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

BlackBerry's PlayBook tablet

BlackBerry's PlayBook tablet fact:-
Research in Motion unveiled the PlayBook
The PlayBook tablet features:
 7-inch screen
 Flash-capable video 
 front and rear high-definition camera
 9.7 millimeters Thick
operating system: new platform from QNX Software Systems
 
 
source:cnnmoney

The recipient server did not accept our requests...

This error message indicates that we've attempted to make a connection with your recipient's server but didn't receive a reply. Some possible causes include the following:

• The other domain doesn't have up-to-date MX records or is otherwise misconfigured.
• The other domain is blacklisting or graylisting messages from Gmail.
• The other domain is experiencing temporary networking problems.

We recommend contacting the customer service department of the recipient's domain for further instructions. If you receive this bounce message when sending to your Google Apps domain, please see our instructions for configuring your MX records.
 
 
htp://mail.google.com/support/bin/answer.py?answer=7720

Unable to start the Transact-SQL debugger.

Unable to start the Transact-SQL debugger. The Transact-SQL debugger does not support SQL Server 2005 or earlier versions of SQL Server. (SQLEditors)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.DebugWrapper.Start()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.OnDebugScript(Object sender, EventArgs a)

Data-driven document generation with Word 2007 and the Office XML File Formats: Part 1

Data-driven document generation with Word 2007 and the Office XML File Formats: Part 1
 
http://blogs.msdn.com/b/erikaehrli/archive/2006/08/11/word2007datadocumentgenerationpart1.aspx

Why ASMX web services are not an excuse anymore with WCF 4.0

http://weblogs.asp.net/cibrax/archive/2010/09/06/why-asmx-web-services-are-not-an-excuse-anymore-with-wcf-4-0.aspx

 

 

Account detail & balance problem in JD Edwards EnterpriseOne/xe

I found this problem in GL module, if you create one transaction in GL detail, means F0911 file, but after some time you detailed that transaction, sometime its not working its not deleting from balance file F0902, and even if you run repost program- R099102 its not fixing account balance.
Solution:- you have to go database lavel to fix this problem, I mean you have to use SQL-Servre and update that particlure period.
ps: this happens only when if you have only 1 transaction for that year for that account & subledger.

Add OpenID Login Support In Your ASP.NET Application

http://midnightprogrammer.net/post/Add-OpenID-Login-Support-In-Your-ASPNET-Application.aspx

MVC 2 Model Metadata to Render Dynamic UI

http://geekswithblogs.net/michelotti/archive/2010/09/08/mvc-2-model-metadata-to-render-dynamic-ui.aspx

 

Internet explorer 9 all info with free download -beta

Main link: http://ie.microsoft.com/testdrive

Download link http://windows.microsoft.com/ie9?os=winvista&arch=a&browser=ie

Demo: http://ie.microsoft.com/testdrive/views/alldemos/default.html

world wide download link:  http://windows.microsoft.com/en-US/internet-explorer/download/ie-9/worldwide

wiki:http://en.wikipedia.org/wiki/Internet_Explorer

 

 

SQL Server Performance Tips and Guidelines

SQL Server Performance Tips and Guidelines - CodeProject

Access link table column default as number, how to change

I have a column of data with mixture of text and number, in link table its comming as number, how to convert all in text.

Solution:http://office.microsoft.com/en-us/excel-help/three-ways-to-convert-numbers-to-text-HA001136619.aspx

Introduction to Android development : TouchCalculator - CodeProject

http://www.codeproject.com/KB/android/androidcalculator.aspx

SQL-Sever The query processor ran out of stack space during query optimization.

Server: Msg 8621, Level 17, State 93, Procedure pSaleovINN, Line 14
Internal Query Processor Error: The query processor ran out of stack space during query optimization.

 

Queries that contain a large number of  IN or a NOT IN clause may generate a stack overflow.

Solution: Rewrite query with temp table.

 

http://support.microsoft.com/kb/288095

 

ASP.NET ImageDraw - Graphics

http://www.asp.net/community/control-gallery/browse.aspx?category=18

S#arp Architecture 1.6 Released! - Billy McCafferty - Devlicio.us - Just the Tasty Bits

S#arp Architecture 1.6 Released!

 
http://devlicio.us/blogs/billy_mccafferty/archive/2010/08/19/s-arp-architecture-1-6-released.aspx