Search results for query: *

Given the following example code from the MS docs, how would one force alignment on the SELECT td = .... elements? Is there some secret documentation mother load in the sky I haven't found yet documenting how this works? Much thanks in advance, Paul DECLARE @tableHTML NVARCHAR(MAX) ; SET...

I have a data source to an MS SQL data base that returns an XML datatype column along with a number of other columns I'm using in my report. Is there an elegent way to shred this column with Reporting Services or will I best shred it on the SQL side and return it in a separate data set? Best...

I have a need to schedule an SQL Job for the first 'business day' in a month. This would be Monday if the 1st fell on a Saturday or Sunday. Of course holidays also have the potential to mess this one up big time. My only thought was to create 12 '1st day of ...' schedules and update them...

I have an environment where our live database, (MC_Live), gets backed up and restored to a development environment, (MC_Training), periodically. In this database, there are some stored procedures that update a second database via a linked server connection. When working in MC_Live, we want to...

I have a development environment that talks to MSSQL through a 3rd party driver. The driver appears to be setting up a cursor and then 'Fetching' against that cursor. My problem is that I see these in the activity monitor but have no way of identifying the TSQL code that set up the cursor so I...

I have a number of tables with cascading relational constraints. When I update the parent table it cascades down through the whole relational tree perfectly however there is a field that is not part of the relationship that needs to be updated in the child tables ONLY if the related field...

I need a good set based solution to run a select statement that generates : 131234 2 134321 5 154234 3 I need: 131234 131234 134321 134321 134321 134321 134321 154234 154234 154234 I can think of several convoluted ways...

I have an Excel spreadhseet that is giving the following error when previewing: TITLE: There was an error displaying the preview. ADDITIONAL INFORMATION: Index and length must refer to a location within the string. Parameter name: length (mscorlib) Anyone have any clue as to what the problem...

I have an application running on SQL Mobile (or lite or whatever it's called these days). What I need to do is run an SQL query that will tell me if an index has been defined on a particular table. I know I can do this with SQL Enterprise but how is it done on SQL Mobile? Much thanks in...

Given an SQL XML table column with contents like this: <fld> <state>WA</state> <taxcert>A18 3865 10</taxcert> <effective>1/1/2010</effective> <certexp_yn>Y</certexp_yn> <expires>12/31/2010</expires> <singleuse_yn>N</singleuse_yn> <exempt_yn>N</exempt_yn> <exempt_reason /> </fld>...

I have an e-mail sent to me once a day that I need to automate processing for. It has an e-mail attachment that I need to save to a network directory and processing using a SSIS package. I would think with all the automation we do these days that someone has solved this...

I'm not sure this is the place to ask but I'll start here..... I have an e-mail sent to me once a day that I need to automate processing for. It has an e-mail attachment that I need to save to a network directory and processing using a SSIS package. I would think with all the automation we do...

Has anyone observed different results when running the same query on CE and Std editions? The following code is a cluge to get around not having a 'TOP' clause in CE. It returns a different value depending on the engine it's run against. SELECT CASE WHEN MAX(Class) LIKE 'H%'...

How can you test to see if a file exists before you run a file operation on it?

Hair pulling time.... I have an SQL task that returns a list of 'From' and 'To' full file path specifications that I want to use to move some files. 1) I was able to set up an SQL Task that executes a stored procedure returning a list of files to move (with full paths) This data was mapped to...

What development environments have you had success with on hand held devices? Has anyone worked with Mobileframe? What techniques are you using to syncronize hand held data with back office SQL systems? Replication?

I'm using a product sitting on top of SQL CE that allows me to run an SQL query. The following query runs on the same table in SQL Std just fine but throws an error (which is hidden by the product I am working with), under CE. Can someone point out what might not be supported under CE for the...

I'm a newbie at SSIS. I have a package that I've been able to install on my SSIS server which is running on the same machine as my SQL server. The SQL code I am running is below: DECLARE @cmd VARCHAR (1000) SELECT @cmd = 'dtexec /SQL "\Load Columbia River" /SERVER MCSQL2008 /USER SSIS...

I have a dataflow that reads a flat file, does a fair bit of manipulation, and writes the data into two SQL tables, one of which is are header records and the other detail lines related to those headers. The Header and Detail tables are set up with relational integrity. The problem I'm having...

I believe this problem is with the MS rendering engine but I'm going to post here to see if anyone has any ideas. I have a SSRS 2008 report that consists of 1 chart and 1 Tablix. The chart has custom code to handle the color and the line styles on the chart. (The number of series in the report...