A Possible Alternative to SQL UNPIVOT
Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.
2017-01-16
4,226 reads
XPATH
retrieve SSRS report schedule info through SQL
Grabs information about what reports in SSRS are scheduled, when are they due to be sent out, report parameters and any errors in the last run etc.
2014-02-21 (first published: 2010-08-18)
2,552 reads
RE: How to!
SQL doesnot allow you to use derived column names in the where clause. You will have to repeat the formula in the where clause
2004-12-14
RE: SQL Server User
Thank you AdiCohn for your comments. I am experiencing two problems in changing the application-user to Sql-user. 1) My system is too complex having almost 350 tables and 80 or more data entry screens, 200 more report screens. It is something like an ERP system. In Sql server I can give only table level permissions. […]
2003-12-09
1 reads
RE: How to import a .sql file with DTS
quote: Incorrect syntax near ' '. Just remembered, isql gives this error for unicode files. Try osql instead. Same parameters just replace isql with osql
2003-11-21
1 reads
RE: Getting UNIQUEIDENTIFIER data
we're using java swing client/server and sql 2k.... i guess the reason i say do it on the client is that you can create the uniqueid and then reference it immediately before inserting a new row - just like what's-his-name says...
2003-07-18
RE: unused space in db of SQL server 2000
I want to add something regarding this topic. If I run the following query: use Madison DBCC SHRINKFILE ('opms_Data', XXXX) where XXXX stands for the next reachable file size which is calculated as allocated space or database_size (checked with sp_spaceused @updateusage = true) minus unallocated space equals = free space to be released. Also you […]
2003-05-19
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers