Viewing 15 posts - 16 through 30 (of 377 total)
Thank you for this article. As a developer, I get slammed by management when the database I deployed runs slow in production. "Didn't you test it!!!!" I...
May 6, 2016 at 7:34 am
Can you provide a sample table that has data that should not return rows as well as where you do want rows. Something like this:
declare @t table (id int...
April 14, 2016 at 3:33 pm
If rather than using the Table source or even a command with "Select * from " you actually spelled out the column name "SELECT IsOrderAGift from " then the package...
February 11, 2016 at 8:37 am
You can validate multiple elements in an XML file using .Net. But not using SQL XML.
I don't have the environment to test this, but I think that the code...
October 7, 2015 at 3:50 am
Do you have a parameter mapping of parameter name "0" to variable @filename?
February 16, 2015 at 7:03 am
SELECT [c].[Name],[c].[ItemID],[xl].[ReportID]
, MAX([TimeStart]) [LastRunDate]
FROM [dbo].[Catalog] [c]
RIGHT OUTER JOIN [dbo].[ExecutionLogStorage] [xl]
on [c].[ItemID] = [xl].[ReportID]
and [c].[Type] NOT IN (1,5) -- Not a folder or a...
February 13, 2015 at 3:29 pm
A thought. I assume that you know of a row in the target that matches a row in the source. It matches on the key and on the...
February 12, 2015 at 5:39 pm
Are the physician and surgeon keys I a table?
February 5, 2015 at 10:20 am
Try replacing CAST(... AS Date) with CONVERT(Date, ..., 112). Here is my hypothesis. Casting from a string to date is not deterministic because a change in the system...
February 4, 2015 at 7:03 am
What is the query (without for xml) that you need output in the format you like? Are the codes in your xml columns in the table you are querying?
February 3, 2015 at 12:37 pm
jacksonandrew321 (10/11/2014)
update Employee set id='1' where username='markhenry'; I am trying to update my column id to 1 which is actually...
October 11, 2014 at 4:21 am
jacksonandrew321 (10/11/2014)
I wrote query to update id int(1,1) to some value but its not giving me the result. Is it not possible to update id on the table. Please...
October 11, 2014 at 4:02 am
I'm not sure what you mean by "always the same." There are things that you can't do with Raw that you can with Path.
IF OBJECT_ID('XMLForHomework') IS NOT NULL DROP...
May 25, 2014 at 9:51 am
Great article. So far I have only had one employer mention reading my blog, which is still a little light, but is still a better representation of me than...
April 22, 2014 at 4:49 am
You can use the where or put the query into your XQuery (I don't know which is more efficient):
DECLARE @X XML;
DECLARE @CategoryID int = 9;
SET @X = '<root>...
April 8, 2014 at 4:44 am
Viewing 15 posts - 16 through 30 (of 377 total)