Assuming more is required, the following 215 results were found.
-
can change just this script instead of the ones for every package). Here is the near enough final version of my script (or more like an experienced colleague's comprehensive script to which I have merely added my transform part) added as a data flow...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
have), I found out you cannot declare the parameters used by the software within the SQL script... So the above should look more like this: -- =============================================================================== -- Description: Gets the room...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
version 2008 through combining Transact-SQL and MDX expressions" but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
key dates and deadlines popup which a single user assigned as "calendar manager" may have missed. Not automated? No but far more manageable when using Outlook 2007 instead of the SharePoint 2007 web interface... Other Searches Import Outlook 2007...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
is losing time because of a system clock problem. A workaround in this instance is to change the NTP client to update more often. Note: The following process requires administrator (installation) rights on your computer. Open regedit.exe through the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
the different windows. As with previous versions of MS Windows, holding down the Alt key and pressing Tab will give you the more traditional window switcher (2D). Assigning Aero Flip 3D to a shortcut command: Visit...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
for every change. About a zillion group policies control our every deviation from the standard staff image and so we spend more time on "how do you make it like it was in XP?" situations. How? Who doesn't want to change their desktop background...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
| Mirror 1 Right-click on the AppleBcUpdate.exe file and select "Show more options" > Hover over 7-Zip > Select Extract to AppleBcUpdate > Browse to this folder > Browse to "ApplePrecisionTrackpadBluetooth" Right-click on...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand separator, and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
be included: ALTER TABLE table_name MODIFY COLUMN misplaced_column BIT(1) NOT NULL DEFAULT b'0' AFTER other_column; -- OR A MORE COMPLETE EXAMPLE -- ALTER TABLE table_name MODIFY COLUMN misplaced_column VARCHAR(13) NOT NULL DEFAULT 'DefaultString'...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
or business intelligence development studio, you can specify in the report designer how to format the returned value to a more user-friendly date format (such as Month name then year - eg. November 2010). I have been told that data types are a nightmare...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
1.00 002 3.00 2000-02-18 1.00 002 3.00 2000-02-18 1.00 003 2.00 1999-02-25 1.00 003 2.00 1999-02-25 1.00 If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first database name and "myDB2"...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you will NOT be adding these rows to... SET @count:=0; SELECT '2012/2013' AS SetID,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
delim, '')))/LENGTH(delim) + 1; -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB