Delete from a table which requires lookup in another table

-
Problem: To delete rows from TableA based on filter condition which requires a lookup on another table TableB.

Solution 1)

DELETE FROM TableA
FROM
TableA as A INNER JOIN
TableB as B on A.ID = b.ID
WHERE B.COL2 = ''someval' and B.COL3 = 'someval'

Solution 2)

DELETE FROM TableA
WHERE ID IN
(SELECT ID FROM TableB where COL2 = ''someval' and COL3 = 'someval')


Comments

Post a Comment

Popular posts from this blog

Wix: How to hide the License Agreement dialog in Mondo UI

-
We are using the WixUI_Mondo in our setup so that we could allow the users to select/de-select features. However the app is installed on intranets so we did not want to show the License Agreement dialog box. A few pp. suggested downloading the Wix source code and manually changing the part which shows up the LA dialog box.I found out that we could also, change the click event action of Next and Back button controls using Publish tag.So we changed the Next button click event action of the ‘Welcome dialog’ (WelcomeDlg) to show directly the second dialog box. For .e.g:<PublishDialog="WelcomeDlg"Control="Next"Event="NewDialog"Value="ConnectionPortsDlg"Order="3">1</Publish>

And of course also the Back button event action to display the ‘Welcome dialog’.

The full <UI> tag code:<UIId='MyAppWix_UIMondo'>
<UIRefId="WixUI_Mondo"/>
<UIRefId="WixUI_ErrorProgressText"/>
<DialogRefId=&qu…
Read more

WPF: TreeView example (Part 4)

-
Image
In the example shown in Part 3, we saw how to show a tree, with depth of 3.

But what about scenarios, where we do not really know the depth of the tree? Best example is Windows Explorer, it shows a tree with folders, sub-folders, more sub-folders and so on. How do build such a tree?Let’s try to implement this. We create a class Folder:

publicclass Folder
{
publicstring Name
{
get
{
if (!String.IsNullOrEmpty(Path))
{
return io.Path.GetFileName(Path);
}
returnnull;
}
}
publicstring Path
{ get; set; }
public List<Folder> Folders
{ get; set; }
public Folder()
{
Folders = new List<Folder>();
}
publicstatic Folder CreateFolderTree(string rootFolder)
{
Folder fld = new Folder { Path = rootFolder };
foreach (var item in io.Directory.GetDirectories(rootFolder))
{
fld.Folders.Add(CreateFolderTree(item));
}
return fld;
}
}
XAML…
Read more